7.3 pg_ctl anomaly

From: Ed L(dot) <pggeneral(at)bluepolka(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: 7.3 pg_ctl anomaly
Date: 2002-12-03 19:09:50
Message-ID: 02120312095009.12975@bingo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


When I run this command in 7.3,

pg_ctl -w -o "-p 15432" start

it successfully starts the database, but the -w flag doesn't seem to
notice the successful start and continues to wait until finally
saying "postmaster does not start" and giving up. Problem is,
postmaster started fine and continues to run fine even after pg_ctl
says it didn't start. Here's an example session:

$ pg_ctl -w -o "-p 15432" start
waiting for postmaster to start....2002-12-03 11:40:55 [13105] LOG:
database system was shut down at 2002-12-03 11:40:52 MST
2002-12-03 11:40:55 [13105] LOG: checkpoint record is at 0/8019FC
2002-12-03 11:40:55 [13105] LOG: redo record is at 0/8019FC; undo
record is at 0/0; shutdown TRUE
2002-12-03 11:40:55 [13105] LOG: next transaction id: 489; next
oid: 16976
2002-12-03 11:40:55 [13105] LOG: database system is ready
....................2002-12-03 11:41:17 [13169] LOG: connection
received: host=127.0.0.1 port=47221
2002-12-03 11:41:17 [13169] LOG: connection authorized: user=pg
database=template1
2002-12-03 11:41:17 [13169] LOG: query: begin; select
getdatabaseencoding(); commit
2002-12-03 11:41:17 [13169] LOG: duration: 0.003379 sec
2002-12-03 11:41:17 [13169] LOG: query: select version()
2002-12-03 11:41:17 [13169] LOG: duration: 0.001315 sec
....................2002-12-03 11:41:37 [13237] LOG: connection
received: host=127.0.0.1 port=47242
2002-12-03 11:41:37 [13237] LOG: connection authorized: user=pg
database=template1
2002-12-03 11:41:37 [13237] LOG: query: begin; select
getdatabaseencoding(); commit
2002-12-03 11:41:37 [13237] LOG: duration: 0.001499 sec
2002-12-03 11:41:37 [13237] LOG: query: SeLect version()
2002-12-03 11:41:37 [13237] LOG: duration: 0.000777 sec
....................failed
pg_ctl: postmaster does not start

$ uname -a
Linux xxx 2.4.2-2smp #1 SMP Sun Apr 8 20:21:34 EDT 2001 i686 unknown

$ psql -d template1 -c "select version()"
version
-----------------------------------------------------------
PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2002-12-03 19:13:56 Re: PostgreSQL in Universities (Was: Re: 7.4 Wishlist)
Previous Message Richard Huxton 2002-12-03 19:07:37 Re: alter table differences on Cygwin and Linux?