pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Daniel Punton <compass2k@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres port bindings changed after box restart
Date: Wed, 05 Mar 2008 08:31:46 -0600
Message-ID: <47CE5A70.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <e969e33c0803041507p5c4fcc57m5dcd2eda01012c1a@mail.gmail.com>
References: <e969e33c0803041507p5c4fcc57m5dcd2eda01012c1a@mail.gmail.com>

>>> 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
 





view thread (3+ messages)

Message-ID: <47CE5A70.EE98.0025.0@wicourts.gov>
Permalink:  ../47CE5A70.EE98.0025.0@wicourts.gov/
Also on:    postgresql.org/message-id/47CE5A70.EE98.0025.0@wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, compass2k@gmail.com
  Subject: Re: Postgres port bindings changed after box restart
  In-Reply-To: <47CE5A70.EE98.0025.0@wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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