Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 25A4D9FA4C1 for ; Sun, 8 Jul 2007 12:43:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 13431-03 for ; Sun, 8 Jul 2007 12:43:18 -0300 (ADT) X-Greylist: delayed 00:06:39.940772 by SQLgrey-1.7.4 Received: from relay02.pair.com (relay02.pair.com [209.68.5.16]) by postgresql.org (Postfix) with SMTP id D0A9E9FA4B6 for ; Sun, 8 Jul 2007 12:43:18 -0300 (ADT) Received: (qmail 74070 invoked by uid 0); 8 Jul 2007 15:36:37 -0000 Received: from 66.65.131.147 (HELO ?192.168.1.101?) (66.65.131.147) by relay02.pair.com with SMTP; 8 Jul 2007 15:36:37 -0000 X-pair-Authenticated: 66.65.131.147 Message-ID: <46910482.3070500@theflorys.org> Date: Sun, 08 Jul 2007 11:36:34 -0400 From: David User-Agent: Thunderbird 2.0.0.4 (Windows/20070604) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Start problem on Linux Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/67 X-Sequence-Number: 26048 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