On 6 Nov 2002 at 11:59, Prashanth wrote: > > Hi, > > I don't know how my database got corrupted. Whenever I try taking > pg_dump, I get the following error: > getTypes(): SELECT failed. Explanation from backend: 'ERROR: pg_user: > Table does not exist. > > There are so much amount of data. I use postgres 6.5 version. Please > tell me how to rectify this.
Restore from last backup if you have any. Corruption of pg metadata is rather rare event. Did you have disk failures or something like that? And upgrade... You are missing lot of things out there.. If you still want give it a shot. post more details to postgresql hackers mailing list. You will get better responses.. HTH Bye Shridhar -- Zall's Laws: (1) Any time you get a mouthful of hot soup, the next thing you do will be wrong. (2) How long a minute is, depends on which side of the bathroom door you're on. ------------------------------------------------------- This sf.net email is sponsored by: See the NEW Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help