Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: [ADMIN] bugs?



Check you pg_user vs your pg_class if there are tables whose owner
(pg_class.relowner) has no corresponding user entry (pg_user.usesysid).

On 2000-01-11, ZioBudda mentioned:

> Hi, for my error I have delete the file pg_log from pgsql/ and now my
> database do not works anymore. I can enter in the database but if I make 
> db1=> \dt
> 
> I get:
> Couldn't find any tables!
> 
> why it? How can I rescue all my data?
> If there is no way I think that postgresql is not good for massice
> application
> 
> 
> tnx
> ciaoz
> 
> Ho sentito urla di sudore... che schifo...
> --
> Michel <ZioBudda> Morelli		  michel(at)enter(dot)it
> 					http://www.ziobudda.net
> Italian Linux FAQ                  http://faq.ziobudda.net/
> Italian Linux Press                http://www.ziobudda.net/ILP/
> 
> 
> 
> ************
> 
> 

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e(at)gmx(dot)net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



  • References:

Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group