Обсуждение: Default instance?

Поиск
Список
Период
Сортировка

Default instance?

От
Carol Walter
Дата:
I'm upgrading my Postgres 8.2.4 instance to 8.3.6.  I will eventually
have two instances of 8.3.6, but for a time those databases that will
be migrated to the second 8.3.6 instance will need to stay on the
8.2.4.  The 8.2.4 instance is running on port 5432 and the 8.3.6
instance is running on port 5433.  The 8.2 is the default instance.
Users who connect to it don't have to specify the port number, or the
location of the correct version of psql.  I will need to reverse these
so that the 8.3 instance is the default, and users who use the 8.2
instance will have to specify the port.  How do I make this change?

Thanks,
Carol

PS  I'm on a Solaris 10 box.

Re: Default instance?

От
Julius Tuskenis
Дата:
Hi, Carol.

just change  port number in both postgresql.conf files and restart both
servers.


Carol Walter rašė:
> I'm upgrading my Postgres 8.2.4 instance to 8.3.6.  I will eventually
> have two instances of 8.3.6, but for a time those databases that will
> be migrated to the second 8.3.6 instance will need to stay on the
> 8.2.4.  The 8.2.4 instance is running on port 5432 and the 8.3.6
> instance is running on port 5433.  The 8.2 is the default instance.
> Users who connect to it don't have to specify the port number, or the
> location of the correct version of psql.  I will need to reverse these
> so that the 8.3 instance is the default, and users who use the 8.2
> instance will have to specify the port.  How do I make this change?
>
> Thanks,
> Carol
>
> PS  I'm on a Solaris 10 box.
>


--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050