[ADMIN] Recover with main/base files
Hello, I use postgresql 8.1 on a debian server with a /var JFS filesystem. After a crash of this FS (due to hardware instability: PSU), the /var/lib/postgresql/8.1/main folder was missing and its files were found under /var/lost+found. We have a full daily backup of this DB but I try to recover data from the morning it crashed. This is what I was able to recover : - main/base apparently without missing files ! - main/pg_xlog : I don't have these files names (but I can guess it from PG start errors) and I don't know in which order I've have to name them - main/pg_clog files and 0001 but not 0003 which I replaced with a zero padded file - main/pg_multixact - main/global/pg_control But the global folder content was not found. I probably have piece of it but I wasn't able to identify them except for pg_control. I tried to restore all the files over a base debian installation and then inserting a record in pg_database table like that : insert into pg_database (datname, datdba, encoding, datistemplate, datallowconn, datconnlimit, datlastsysoid, datvacuumxid, datfrozenxid, dattablespace) VALUES ( 'ex1', 10, 8, 'f', 't', -1, 10792, 499, 499, 1663); PG started without error and I can connect to the DB created but \dt show me nothing. Do you have alternatives to restore a db from main/base files ? If you have a method to reorder pg_xlog files, it interest me too. Thank you -- 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] Totally inappropriate by-line for a major representative of this organization
I think you should read this and especially article 18 and 19 of this : http://www.un.org/Overview/rights.html But yes you can argue that it was inspired by a previous declaration of a silly group of frenchs :-). On Mon, Feb 2, 2009 at 10:57 PM, Scott Runnion wrote: > As a subscriber to many postgresql mailing lists, I received one today in > which Bruce Momjian was respondind to a query from Stefano Nichele regarding > the last_autovacuum field. As always, Bruce's response was cogent and > undoubtedly accurate. What astounded and dismayed me, however, was his > signature byline, which reads: > > - Bruce Momjian http://momjian.us > EnterpriseDB http://enterprisedb.com > > + If your life is a hard drive, Christ can be your backup. + > > > Surely, given the multi-cultural/multi-national/multi-theological > users/supporters/advocates of the postgresql and EnterpriseDB developments > and distributions, the inappropriateness of this declaration by Mr. Momjian > _as a representative of EnterpriseDB_ is inexcusable, unless EnterpriseDB > itself is positing itself as a secularly-biased organization. > Regardless, please terminate all further communications from all postgresql > and EnterpriseDB mail lists until such time as this situation can be > corrected. > > Scott Runnion > srunn...@mac.com > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >
