Re: [GENERAL] Multiple Postgres Instances
От | Jeff Hoffmann |
---|---|
Тема | Re: [GENERAL] Multiple Postgres Instances |
Дата | |
Msg-id | 36A73DE0.3A4BA230@remapcorp.com обсуждение исходный текст |
Ответ на | Multiple Postgres Instances (David Giffin <david@agent911.com>) |
Ответы |
Re: [GENERAL] Multiple Postgres Instances
Re: [GENERAL] Multiple Postgres Instances |
Список | pgsql-general |
David Giffin wrote: > > Hello, > > I'm trying to run postgres on two different post 5432 and port 5433 with > different data directories for each instance: > > [ -x /usr/local/pgsql/bin/postmaster ] && { > su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i' > echo -n ' pgsql' > } > > [ -x /usr/local/pgsql/bin/postmaster ] && { > su -l postgres -c '/usr/local/pgsql/bin/postmaster > -D/usr/local/pgsql/data_5433 -p5433 -S -i' > echo -n ' pgsql' > } > > But when I do a psql -p 5433 and drop a table it seems to drop in both > instances. If anyone has attempted this before I like to hear how it > worked. > > David just a guess on my part, but i think what you're going to want to do is set the PG_DATA environment variable to /usr/local/pgsql/data_5433 in your script before you start the second instance. they screwed around with the ability to specify absolute paths to the data directory in 6.4.x and didn't document it, so i'm not sure what the truth is about it. i'm not sure if that's what is causing the problem in _this case_, but it has happened with other cases. (it makes good sense to require you to use environment variables in all cases, as far as i'm concerned.) i submitted some doc patches, but apparently they haven't shown up yet. again, this is just a guess, but an educated one. jeff jeff@remapcorp.com
В списке pgsql-general по дате отправления: