I remember some old threads about a problem with corrupted databases. I've seen a couple of references to fixes in the release notes as well...
Tonight I upgraded my ASG425 to 7.305 from 7.300 and my system log has lots of entries like this:
[FONT="Courier New"]2008:12:05-02:33:20 (none) ulogd[2871]: pg1: unable to connect: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
2008:12:05-02:33:23 (none) postgres[5748]: [1-1] LOG: could not create IPv6 socket: Address family not supported by protocol
2008:12:05-02:33:23 (none) postgres[5753]: [2-1] LOG: database system was interrupted while in recovery at 2008-12-05 02:29:08 EST
2008:12:05-02:33:23 (none) postgres[5753]: [2-2] HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
2008:12:05-02:33:23 (none) postgres[5753]: [3-1] LOG: database system was not properly shut down; automatic recovery in progress
2008:12:05-02:33:23 (none) postgres[5753]: [4-1] PANIC: record with zero length at C/3E1FE690
2008:12:05-02:33:23 (none) postgres[5748]: [2-1] LOG: startup process (PID 5753) was terminated by signal 6: Aborted
2008:12:05-02:33:23 (none) postgres[5748]: [3-1] LOG: aborting startup due to startup process failure
2008:12:05-02:33:25 (none) ulogd[2871]: pg1: unable to connect: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
2008:12:05-02:33:30 (none) ulogd[2871]: pg1: unable to connect: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? [/FONT]
Is there just no way to fix this without flattening the device and starting over? None of the fixes will actually fix the problem (ie: they're just attempts to keep it from happening again?).
Thanks,
--Ernie
This thread was automatically locked due to age.