postmaster does not start up

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

Responses

Browse pgsql-admin by date

  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.

Browse pgsql-general by date

  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