pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David <lists@theflorys.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: Start problem on Linux
Date: Sun, 08 Jul 2007 12:29:24 -0400
Message-ID: <833.1183912164@sss.pgh.pa.us> (raw)
In-Reply-To: <46910482.3070500@theflorys.org>
References: <46910482.3070500@theflorys.org>

David <lists@theflorys.org> writes:
> First: When I restart the Ubuntu server, the Postgres instance is
> started and listens on port 5432 using ssl as requested.  However, it
> does not created its postmaster.pid file in the PGDATA directory.

The postmaster will certainly not start without creating a
postmaster.pid file.  What I think is happening is that you are confused
about where PGDATA is, ie, the start script has some other value for it
than you think.

> Second: If I manually stop the system and then start it (su postgres)
> using "pg_ctl start" the system starts and creates its postmaster.pid
> file correctly.  However, this time port 5432 remains closed and I
> cannot connect from the outside.

Sounds like your idea of PGDATA contains different configuration files
than the start script's idea of it --- after the port number,
listen_addresses and pg_hba.conf would be the things to check.

			regards, tom lane



view thread (2+ messages)

Message-ID: <833.1183912164@sss.pgh.pa.us>
Permalink:  ../833.1183912164@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/833.1183912164@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, lists@theflorys.org
  Subject: Re: Start problem on Linux
  In-Reply-To: <833.1183912164@sss.pgh.pa.us>

* 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