By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

Postgresql Compression Across Network

P: 1
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
Jan 29 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 534
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.
Jan 29 '07 #2

P: 7
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.
Jan 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.