pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Postgres port bindings changed after box restart 3+ messages / 3 participants [nested] [flat]
* Postgres port bindings changed after box restart @ 2008-03-04 23:07 Daniel Punton <compass2k@gmail.com> 0 siblings, 2 replies; 3+ messages in thread From: Daniel Punton @ 2008-03-04 23:07 UTC (permalink / raw) To: pgsql-admin Our redhat server was restarted and postgres is showing different databases on different ports? Could someone explain how this might happen and where this information comes from (what conf for port bindings) as is there a way of guarenteeing this will not happen on restarts. Cheers Dan ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres port bindings changed after box restart @ 2008-03-05 14:28 Andrew Sullivan <ajs@crankycanuck.ca> parent: Daniel Punton <compass2k@gmail.com> 1 sibling, 0 replies; 3+ messages in thread From: Andrew Sullivan @ 2008-03-05 14:28 UTC (permalink / raw) To: pgsql-admin On Wed, Mar 05, 2008 at 10:07:14AM +1100, Daniel Punton wrote: > Our redhat server was restarted and postgres is showing different databases > on different ports? > Could someone explain how this might happen Different configuration files? > and where this information comes from (what conf for port bindings) postgresql.conf. Other than that, you'll have to use find, I'd say. > as is there a way of guarenteeing this will not happen on restarts. Sure. When you start up, make sure each start-up script points to the correct data area. A ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres port bindings changed after box restart @ 2008-03-05 14:31 Kevin Grittner <Kevin.Grittner@wicourts.gov> parent: Daniel Punton <compass2k@gmail.com> 1 sibling, 0 replies; 3+ messages in thread From: Kevin Grittner @ 2008-03-05 14:31 UTC (permalink / raw) To: Daniel Punton <compass2k@gmail.com>; pgsql-admin >>> On Tue, Mar 4, 2008 at 5:07 PM, in message <e969e33c0803041507p5c4fcc57m5dcd2eda01012c1a@mail.gmail.com>, "Daniel Punton" <compass2k@gmail.com> wrote: > Our redhat server was restarted and postgres is showing different databases > on different ports? > Could someone explain how this might happen > and where this information comes from (what conf for port bindings) > as is there a way of guarenteeing this will not happen on restarts. It sounds like you have installed multiple PostgreSQL database clusters, and more than one is configured to start automatically. You might want to start by reviewing the documentation on what a cluster is: http://www.postgresql.org/docs/8.2/interactive/creating-cluster.html Each will have its own data directory and a different port number for connections. The port number is normally configured in the postgresql.conf file. -Kevin ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-03-05 14:31 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-03-04 23:07 Postgres port bindings changed after box restart Daniel Punton <compass2k@gmail.com> 2008-03-05 14:28 ` Andrew Sullivan <ajs@crankycanuck.ca> 2008-03-05 14:31 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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