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
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 |