From: | Andrew Perrin - Demography <aperrin(at)demog(dot)Berkeley(dot)EDU> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | postmaster does not start up |
Date: | 2000-12-05 17:40:10 |
Message-ID: | Pine.SUN.4.10.10012050937520.22579-100000@davis.DEMOG.Berkeley.EDU |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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(at)nujoma:~$ declare -x PGDATA="/var/lib/postgres/data"
postgres(at)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(at)nujoma:~$ /usr/local/pgsql/bin/pg_ctl start
postmaster successfully started up.
postgres(at)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(at)nujoma:~$
postgres(at)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(at)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(at)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(at)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(at)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(at)demog(dot)berkeley(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Sivagami . | 2000-12-05 22:03:47 | Foriegn key constraint |
Previous Message | Larry Rosenman | 2000-12-05 17:24:25 | Re: 1)Can't compile with ODBC support. 2)FATAL 1: AllocSetAlloc() on Pentium computer. |
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Castle | 2000-12-05 18:01:38 | Re: Sequences in transaction |
Previous Message | Adam Lang | 2000-12-05 17:05:48 | Open Source Article |