Re: [GENERAL] Postgresql 9.0.1 Corrupted

2011-07-18 Thread Craig Ringer
Please reply to the mailing list, not just to me. Use the "reply all" button if your email program doesn't support reply-to-list. > Yes I have the backup of the point where the db was corrupted. But no > backup. Ouch. I hope your data isn't too important to you. If your data is vital to you, you

Re: [GENERAL] Postgresql 9.0.1 Corrupted

2011-07-18 Thread Craig Ringer
On 18/07/11 12:36, AI Rumman wrote: > At first, when I tried to start the server after CENTOS repair What is "CENTOS repair" ? Do you mean that you ran a file system check (fsck) and told it to repair file system damage? If so, you probably had file system corruption that damaged your data. Che

Re: [GENERAL] Postgresql 9.0.1 Corrupted

2011-07-17 Thread Steve Atkins
On Jul 17, 2011, at 9:36 PM, AI Rumman wrote: > Database Version: Postgresql 9.0.1 > OS: Linux rumman.dhaka 2.6.18-92.el5xen #1 SMP Tue Jun 10 19:55:54 EDT 2008 > i686 i686 i386 GNU/Linux > Installed from: Source configure > Problem: > When I try to connect to postgres, I got - > psql: FATAL: r