Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3C11F2E2EF4 for ; Wed, 5 Mar 2008 10:29:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 27101-04 for ; Wed, 5 Mar 2008 10:29:03 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 55F4E2E2EF8 for ; Wed, 5 Mar 2008 10:29:11 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JWuby-0001PH-3Z for pgsql-admin@postgresql.org; Wed, 05 Mar 2008 09:28:50 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id BE24650190; Wed, 5 Mar 2008 09:28:40 -0500 (EST) Date: Wed, 5 Mar 2008 09:28:40 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Postgres port bindings changed after box restart Message-ID: <20080305142840.GA32651@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/39 X-Sequence-Number: 28522 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