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
