Re: Run 2 versions of Postgresql on one machine?

Поиск
Список
Период
Сортировка
От Peter Alberer
Тема Re: Run 2 versions of Postgresql on one machine?
Дата
Msg-id 000901c3ecc5$b7d6b580$5be0d089@ekelhardt
обсуждение исходный текст
Ответ на Run 2 versions of Postgresql on one machine?  ("Wei Wang" <ww220@cam.ac.uk>)
Ответы Re: Run 2 versions of Postgresql on one machine?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi wei,

it is quite easy to have two different version of postgres running on
one machine. You need 2 different directories for the data files and 2
different ports for the 2 postmasters to listen.

-first you prepare the data directories with initdb, you can use the -D
parameter to give the location of the files.
-then start the database (postmaster) with parameter -p PORTNUMBER.
Default port is 5432 so your existing postmaster process will probably
listen there. The new version should listen on another port. All of the
other Postgres utilities (pgsql, createdb, ...) also need the -p
PORTNUMBER info as well, so they can connect to the right postmaster
process.

Hope that helps,

peter

ps: if you install from the Postgres source, you can specify a new
default port number for your installation via a ./configure switch.


В списке pgsql-general по дате отправления:

Предыдущее
От: "Wei Wang"
Дата:
Сообщение: Run 2 versions of Postgresql on one machine?
Следующее
От: "Andy Kriger"
Дата:
Сообщение: how can I select into an array?