Postgresql 9.x Streaming Repilication on FreeBSD – Part II SSL

Configuring SSL for Postgresql:

Setting up SSL on Postgresql is quite simple.  Our requirements are to enforce SSL Encryption on all Postgresql database connections.  To that end, the creation of self-signed certificates will not be explored in this post. Continue reading “Postgresql 9.x Streaming Repilication on FreeBSD – Part II SSL”

Postgresql 9.x Streaming Repilication on FreeBSD – Part I

Installing Postgresql 9.3:

Installing and configuring Postgresql 9.3 for streaming replication is complex but not difficult.  Although replication can provide a certain level of redundancy it should never take the place of a good backup strategy. Continue reading “Postgresql 9.x Streaming Repilication on FreeBSD – Part I”