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