Greetings - this is with a newly-compiled 7.0.3 under debian 2.2 on a
pentium box. All compiling went just fine; however, although the
postmaster is running based on ps, it can't be accessed. Any ideas will be
much appreciated.
postgres@nujoma:~$ declare -x PGDATA="/var/lib/postgres/data"
postgres@nujoma:~$ ls /var/lib/postgres/data
PG_VERSION pg_geqo.sample pg_hba.conf pg_xlog
base pg_group pg_log postmaster.opts
pg_control pg_group_name_index pg_shadow postmaster.opts.default
pg_database pg_group_sysid_index pg_variable
postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl start
postmaster successfully started up.
postgres@nujoma:~$ DEBUG: Data Base System is starting up at Tue Dec 5
12:37:46 2000
DEBUG: Data Base System was shut down at Mon Dec 4 13:48:41 2000
DEBUG: Data Base System is in production state at Tue Dec 5 12:37:46
2000
postgres@nujoma:~$
postgres@nujoma:~$ psql
Connection to database 'template1' failed.
connectDB() -- connect() failed: Connection refused
Is the postmaster running at 'localhost' and accepting connections on Unix
socket '5432'?
postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl status
pg_ctl: postmaster is running (pid: 1775)
options are:
/usr/local/pgsql/bin/postmaster
-p 5432
-D /var/lib/postgres/data
-B 64
-b /usr/local/pgsql/bin/postgres
-N 32
postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl stop
Smart Shutdown request at Tue Dec 5 12:38:01 2000
postmaster successfully shut down.
DEBUG: Data Base System shutting down at Tue Dec 5 12:38:01 2000
DEBUG: Data Base System shut down at Tue Dec 5 12:38:01 2000
postgres@nujoma:~$ /usr/local/pgsql/bin/pg_ctl -w start
Waiting for postmaster starting up...DEBUG: Data Base System is starting
up at Tue Dec 5 12:38:06 2000
DEBUG: Data Base System was shut down at Tue Dec 5 12:38:01 2000
DEBUG: Data Base System is in production state at Tue Dec 5 12:38:06
2000
............................................................pg_ctl:
postmaster does not start up
postgres@nujoma:~$ ps aux | grep postmaster
postgres 1816 0.0 1.0 4280 996 pts/4 S 12:38 0:00
/usr/local/pgsql/bin/postmaster
postgres 2005 0.0 0.4 1108 404 pts/4 S 12:41 0:00 grep
postmaster
---------------------------------------------------------------------
Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
Department of Demography - University of California at Berkeley
2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199