Joshua D. Drake wrote:
On Wed, 23 Apr 2008 16:27:33 +0100
John Gardner <[EMAIL PROTECTED]> wrote:
We have two PostgreSQL servers (8.2) running in a cluster.
Could you be a bit more specific about what you mean by: in a cluster?
Well, we're using middleware technology to load
We have two PostgreSQL servers (8.2) running in a cluster.
We have autovacuum switched on on both servers and also we are running
the following as a cron job;
Server 1:
30 0,2,4,6,8,10,12,14,16,18,20,22 * * * /usr/bin/vacuumdb --all --analyze
Server 2:
30 1,3,5,7,9,11,13,15,17,19,21,23 * * *
I've been testing one of our apps on PostgreSQL for the last few months
and I'm about ready to put it on the production server, but I need
advice on where to locate the tablespace. I've been so concerned
getting the app working, I haven't even considered this yet.
I'm using a RPM install of Postg
