Can't connect (2 dbs) or login (2 others)

From: "Morris Goldstein" <morris(dot)x(dot)goldstein(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't connect (2 dbs) or login (2 others)
Date: 2007-09-22 18:14:26
Message-ID: 41b6f5c20709221114q508fcfbeq78fcf4975e83970@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a cluster with four nodes, each running a postgres 7.4.8
database. Due to a large amount of pilot error and possibly hardware
problems (still trying to get to the bottom of it all), two of the
databases won't start, and I can't login to two others, with any
registered user.

Two of the nodes have logs that look like this:

2007-09-22 07:06:05 [3055] LOG: could not create IPv6 socket: Address
family not supported by protocol
2007-09-22 07:06:05 [3060] LOG: database system shutdown was
interrupted at 2007-09-22 06:56:27 PDT
2007-09-22 07:06:05 [3060] LOG: could not open file
"/var/lib/pgsql/data/pg_xlog/0000000000000000" (log file 0, segment
0): No such file or directory
2007-09-22 07:06:05 [3060] LOG: invalid primary checkpoint record
2007-09-22 07:06:05 [3060] LOG: could not open file
"/var/lib/pgsql/data/pg_xlog/0000000000000000" (log file 0, segment
0): No such file or directory
2007-09-22 07:06:05 [3060] LOG: invalid secondary checkpoint record
2007-09-22 07:06:05 [3060] PANIC: could not locate a valid checkpoint record
2007-09-22 07:06:05 [3055] LOG: startup process (PID 3060) was
terminated by signal 6
2007-09-22 07:06:05 [3055] LOG: aborting startup due to startup process failure

The other two look like this:

LOG: database system was shut down at 2007-09-22 05:52:26 PDT
LOG: checkpoint record is at 0/9B0B8C
LOG: redo record is at 0/9B0B8C; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 536; next OID: 17142
LOG: database system is ready
FATAL: IDENT authentication failed for user "xxx"
FATAL: IDENT authentication failed for user "yyy"

Can someone tell what is going wrong and how I can recover?

Morris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2007-09-22 19:09:06 Re: Unique is non unique; no nulls
Previous Message Razvan Costea-Barlutiu 2007-09-22 17:58:41 Unique is non unique; no nulls