Re: [GENERAL] Add pg server to cluster

2009-12-07 Thread Alan Hodgson
On Monday 07 December 2009, AlannY wrote: > What should I do exactly? Create NFS folder in new server? And then? > Mount NFS folder to /var/lib/pgsql/data? If so, I will confront with > space problem again, when space will ends at the new server... > > Or maybe there are more advanced modes with N

Re: [GENERAL] Add pg server to cluster

2009-12-07 Thread AlannY
On Mon, Dec 07, 2009 at 01:12:03PM -0500, Scott Mead wrote: > On Mon, Dec 7, 2009 at 10:35 AM, AlannY wrote: > > You have a couple of options: > > NFS > > Works well, just make sure you're running with 'sync' enabled, or > you could lose some data > What should I do exactly? Cre

Re: [GENERAL] Add pg server to cluster

2009-12-07 Thread Scott Mead
On Mon, Dec 7, 2009 at 10:35 AM, AlannY wrote: > Hi there. > > I'm using PostgreSQL as my main database engine. Everything works. > > I have one server for PostgreSQL, and space on it are lowing down. > > I want to buy a new server and somehow connect it with first one, that > PostgreSQL will use

[GENERAL] Add pg server to cluster

2009-12-07 Thread AlannY
Hi there. I'm using PostgreSQL as my main database engine. Everything works. I have one server for PostgreSQL, and space on it are lowing down. I want to buy a new server and somehow connect it with first one, that PostgreSQL will use this new server's HDD. I don't want to buy new HDD for the fi