[ADMIN] DB Structure Recovery
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/6C20 LOG: redo record is at 3E/6C20; undo record is at 3E/6C20; 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/6C68 LOG: redo is not required FATAL: could not access status of transaction 6643 DETAIL: Could not read from file "pg_multixact/offsets/" 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? HELP!!! -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] DB Structure Recovery
2008/3/19, Achilleas Mantzios <[EMAIL PROTECTED]>: > Στις Wednesday 19 March 2008 16:56:19 ο/η veejar έγραψε: > > > 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/6C20 > > LOG: redo record is at 3E/6C20; undo record is at 3E/6C20; > > 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/6C68 > > LOG: redo is not required > > FATAL: could not access status of transaction 6643 > > DETAIL: Could not read from file "pg_multixact/offsets/" 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? > > HELP!!! > > > > > maybe take a look at your lost_found dir under the fs in question. > > > -- > Achilleas Mantzios > > KOSOVO IS SERBIA FOR EVER > I had error about no space in lost+found folder. That's why I cant found losed files in this folder. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Reading information from crashed PGDATA
This information I have found in PostgreSQL docs: Table 52-1. Contents of PGDATA PG_VERSION A file containing the major version number of PostgreSQL baseSubdirectory containing per-database subdirectories global Subdirectory containing cluster-wide tables, such as pg_database pg_clog Subdirectory containing transaction commit status data pg_multixactSubdirectory containing multitransaction status data (used for shared row locks) pg_subtrans Subdirectory containing subtransaction status data pg_tblspc Subdirectory containing symbolic links to tablespaces pg_twophase Subdirectory containing state files for prepared transactions pg_xlog Subdirectory containing WAL (Write Ahead Log) files postmaster.opts A file recording the command-line options the server was last started with postmaster.pid A lock file recording the current server PID and shared memory segment ID (not present after server shutdown) When I have only folder base or base+global, can I read tables data from databases in such PGDATA via any tools or methods? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Database file names
Hello! We have database PostgreSQL 8.2.3 on FreeBSD 6.0. After reboot & fsck we have lost many files from base folder in PostgreSQL PGDATA Data Recovery Company can only restore files, but without file names. Is it possible to restore filename by file content or another method? - Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Retrievig text information from damaged DataBase
Hello! My PostgreSQL DB was damaged, some files were removed and now I have such loss: global/pg_auth global/pg_database global/pgstat.stat fast all files in folder "pg_clog" pg_subtrans/527E all files in folder "pg_xlog" And some small files in folder of my database. Is it possible corrent database structure files and start pgsql server or retrieve text information from database? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
