Postgres

Postgres and Moving Databases

Recently I had to recover a Postgres DB and for 'convenience' I moved it from its original Linux environment to OS X. The process had a few wrinkles most important was that the linux environment used a locale of en_US.utf8 and MAC OS only has en_US.UTF-8
Read More...

PostgreSQL CLI utility with SSL

The Postgres CLI utility can sometimes prove a little painful to use when trying to connect to a server. In this case the sticking point was require SSL on the server. Read More...