Postgresql Compression Across Network

[Walky]

Hi All,

At my company we have 5 FreeBSD servers around Australia, some on very low bandwidth connections. 1 Server (in Perth) has the Postgres Database, all other server just make calls to the database through a web server. Is it possible to set up data compression between the servers through the network, so all postgres data on port 5432 is compressed, and then decompressed on the receiving serve end??

Any thoughts ideas would be great!

Many thanks

[michaelb]

I don't think Postgres has the OOTB solution for data-compression.

You may need to look at alternatives... many VPN implementations use data-compression internally.

[ahammond]

Hi All,

At my company we have 5 FreeBSD servers around Australia, some on very low bandwidth connections. 1 Server (in Perth) has the Postgres Database, all other server just make calls to the database through a web server. Is it possible to set up data compression between the servers through the network, so all postgres data on port 5432 is compressed, and then decompressed on the receiving serve end??

Any thoughts ideas would be great!

Many thanks

You can use an ssh tunnel to do this or some other VPN solution. I think it's also possible to do compression at the SSL layer, but you probably don't want the annoyance of using SSL.