What time was it?
This is a question that may not always be easy to answer, even with the excellent TIMESTAMPTZ data type. While it stores the UTC timestamp equivalent to the time it sees, it throws away the time zone of the client.
Here's how to capture it.
Continue reading "Stalking the Wild Timezone" »
Tuesday, February 17. 2015
Upgrading PostgreSQL on Ubuntu Without Automatically Restarting
You're in an environment where you can't take long (or worse, randomly timed) down times. It's a totally ordinary thing.
Normally, you'd want to upgrade the software in one step, and restart the service that depends on it in a different step.
Here's how. Continue reading "Upgrading PostgreSQL on Ubuntu Without..." »
Normally, you'd want to upgrade the software in one step, and restart the service that depends on it in a different step.
Here's how. Continue reading "Upgrading PostgreSQL on Ubuntu Without..." »
(Page 1 of 1, totaling 2 entries)