Re: Postgres port bindings changed after box restart

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres port bindings changed after box restart
Date: 2008-03-05 14:28:40
Message-ID: 20080305142840.GA32651@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2008-03-05 14:31:46 Re: Postgres port bindings changed after box restart
Previous Message Professor Flávio Brito 2008-03-05 13:10:27 Re: Documenting a DB schema