From: David <lists@theflorys.org>
To: pgsql-admin@postgresql.org
Subject: Start problem on Linux
Date: Sun, 08 Jul 2007 11:36:34 -0400
Message-ID: <46910482.3070500@theflorys.org> (raw)
I just installed PostgreSQL 8.2.3 on an Ubuntu server 7.04. The server
is setup in their server mode -- no gui, command line only. The system
works fine -- I can connect with psql using localhost and I have created
users and installed a database imported from a Win32 test platform.
I have two problems that may be related.
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. This
means that "pg_ctl reload", and "pg_ctl stop" do not work. I have to
use "$ ps -A | grep postgres" to find the PID and then us "pg_ctl kill"
to stop the instance.
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.
Both /usr/local/pgsql/data and /etc/postgresql/8.2/main are owned by the
database user postgres.
Any advice or suggestions would be appreciated.
Cheers, David Flory
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: lists@theflorys.org
Subject: Re: Start problem on Linux
In-Reply-To: <46910482.3070500@theflorys.org>
* 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