Search Postgresql Archives

Database recovery

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello!

My filesystem (UFS-FreeBSD) was crashed and I have lost files from
PGSQL DATA DIR FOLDER after fsck-utility.

I have lost files from directory "pg_xlog"
I reset my pg_xlog.

And now have such error by starting pgsql-server:

LOG:  database system was interrupted at 2008-03-18 22:29:48 EET
LOG:  checkpoint record is at 3E/6C000020
LOG:  redo record is at 3E/6C000020; undo record is at 3E/6C000020;
shutdown TRUE
LOG:  next transaction ID: 0/1624775486; next OID: 9528514
LOG:  next MultiXactId: 6643; next MultiXactOffset: 13690
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 3E/6C000068
LOG:  redo is not required
FATAL:  could not access status of transaction 6643
DETAIL:  Could not read from file "pg_multixact/offsets/0000" at
offset 24576: Success.
LOG:  startup process (PID 6267) exited with exit code 1
LOG:  aborting startup due to startup process failure
LOG:  logger shutting down

Is it possible to lose this problem?

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux