pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDefault instance?
2+ messages / 2 participants
[nested] [flat]
* Default instance?
@ 2009-03-13 16:14 Carol Walter <walterc@indiana.edu>
2009-03-13 16:25 ` Re: Default instance? Julius Tuskenis <julius@nsoft.lt>
0 siblings, 1 reply; 2+ messages in thread
From: Carol Walter @ 2009-03-13 16:14 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Default instance?
2009-03-13 16:14 Default instance? Carol Walter <walterc@indiana.edu>
@ 2009-03-13 16:25 ` Julius Tuskenis <julius@nsoft.lt>
0 siblings, 0 replies; 2+ messages in thread
From: Julius Tuskenis @ 2009-03-13 16:25 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-03-13 16:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-03-13 16:14 Default instance? Carol Walter <walterc@indiana.edu>
2009-03-13 16:25 ` Julius Tuskenis <julius@nsoft.lt>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox