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

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

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

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

[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