[ADMIN] Creating Multiple Instance

2011-12-13 Thread Selva manickaraja
Hi All, We are planning to create a 2nd instance of postgres db in the same server. The reason is simple. After we added another application, the number of WAL(s) created is too much. So we want to separate the db by moving it out to another instance of postgres in the same machine. We want to

Re: [ADMIN] Creating Multiple Instance

2011-12-13 Thread Thomas Markus
Hi, thats possible. Dont forget so set another port in your postgresql.conf Thomas Am 13.12.2011 09:23, schrieb Selva manickaraja: Hi All, We are planning to create a 2nd instance of postgres db in the same server. The reason is simple. After we added another application, the number of

Re: [ADMIN] Creating Multiple Instance

2011-12-13 Thread Tom Lane
Thomas Markus t.mar...@proventis.net writes: thats possible. Dont forget so set another port in your postgresql.conf I think actually the reason pg_ctl is complaining is that it doesn't know how to read postgresql.conf, so it's unaware that the second server is supposed to be on 5433. (IIRC,

Re: [ADMIN] Creating Multiple Instance

2011-12-13 Thread Scott Marlowe
On Tue, Dec 13, 2011 at 1:23 AM, Selva manickaraja mavle...@gmail.com wrote: Hi All, We are planning to create a 2nd instance of postgres db in the same server. The reason is simple. After we added another application, the number of You don't mention which OS you're running, but any debian