Re: Run 4 postgresql session on ONE server?
От | Karl DeBisschop |
---|---|
Тема | Re: Run 4 postgresql session on ONE server? |
Дата | |
Msg-id | 1055576710.5042.5.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Run 4 postgresql session on ONE server? ("Daniel Seichter" <daniel@dseichter.de>) |
Список | pgsql-admin |
On Sat, 2003-06-14 at 03:20, Daniel Seichter wrote: > Good morning, > > > Yes, you can do it. All you have to do is create four seperate accounts > > for it to run under (pgsql1, pgsql2, pgsql3, pgsql4) and then in each of > > those accounts, set up a different PGDATA value and initdb as that user. > > Then edit each account's postgresql.conf to have a different port number > > (I just incremented from 5432 to 5433 etc...) and start them up. > Well, it looks easy *g* > I will do this today and hope, it work. > > > Then when you connect just specify the port of the database instance you > > need. Since each one is running as a different user with different > > postgresql.conf and pg_hba.conf files you can lock the production instance > > down tight to prevent brain farts (oops, I just dropped a table in the > > production database) and you're gold. > Ok, at the moment , I only can say: thank you, and I had to test it during > this weekend to start at the next week with the configuration. BTW -- this is pretty easy with the RPMs (I think you said you were on RedHat). Just make a symlink to the init script. Call it 'pg2' Then put the port and pgdata definitions in /etc/sysconfig/pgsql/pg2 -- Karl DeBisschop <kdebisschop@infoplease.com> Director of Software Development, Infoplease/Pearson Education
В списке pgsql-admin по дате отправления: