Re: [ADMIN] VACUUM FULL memory requirements

I've been doing more testing on several different machines, but still haven't found a solution to my problem where VACUUM FULL is running out of memory. Besides the original case on RHEL4, I've been able to reproduce it on both Windows and OSX, with 3GB and 5GB RAM, respectively. Interestingly, i

[ADMIN] starting postgres with several Data directories

Hello, pgsql guru I have windows version of postgres 8.4 for experiments. At first - what I have done so far: 1. Copied content of Data directory to Data2 2. Changed the port to 5433 in Data2\postgresql.conf 3. Started postgres from commant prompt like (F:/Program Files/PostgreSQL/8.4/bin/pg_ctl.

Re: [ADMIN] starting postgres with several Data directories

On Mon, Dec 21, 2009 at 1:46 PM, Julius T wrote: > Hello, pgsql guru > > I have windows version of postgres 8.4 for experiments. > At first - what I have done so far: > 1. Copied content of Data directory to Data2 > 2. Changed the port to 5433 in Data2\postgresql.conf > 3. Started postgres from co

Re: [ADMIN] starting postgres with several Data directories

On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe wrote: > > > Yes, it's fine. Make a different data dir, point the postgresql.conf > gile to a different tcp port and off ya go. I do it all the time to > test slony setup at work. > Agreed, I've actually used it for a couple of different reasons, i

Re: [ADMIN] starting postgres with several Data directories

On Mon, Dec 21, 2009 at 2:26 PM, Scott Mead wrote: > > On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe > wrote: >> >> >> Yes, it's fine.  Make a different data dir, point the postgresql.conf >> gile to a different tcp port and off ya go.  I do it all the time to >> test slony setup at work. > > Ag

Re: [ADMIN] starting postgres with several Data directories

On Mon, Dec 21, 2009 at 4:35 PM, Scott Marlowe wrote: > On Mon, Dec 21, 2009 at 2:26 PM, Scott Mead > wrote: > > > > On Mon, Dec 21, 2009 at 4:17 PM, Scott Marlowe > > wrote: > >> > > > Yeah, I create a different "admin" account for each one, that has the > PGPORT and stuff already set, and setu

Re: [ADMIN] starting postgres with several Data directories

Thank you, Scott & Scott :) I appreciate your help. -- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin