Superuser lost access to particular database

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Superuser lost access to particular database
Date: 2006-09-12 02:02:12
Message-ID: cone.1158026532.359948.40210.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have one database owned by "user1" which as of 4 days ago the superuser,
pgsql, can't see any tables.

I noticed I had pg_dumpalls from 4 days ago.. stuck.. upon research I
discovered that if I login as the superuser to the problem database that it
can not see any of the tables owned by the regular user. The superuser is
able to see system tables with \dS, but none of the regular ones with \d

If I login as 'user1' all the tables are there.

I tried "grant all on pgsql to database <mydb>", but that did not help.
Also tried to do a grant for particular table, but got error that it was not
found.

Tried a pg_dump as the database owner, but it didn't work.

Basically I have this database that only the DB owner can use.. and the
postgresql superuser can't see any tables and it is freezing the pg_dumpall
process.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon_Kelly 2006-09-12 02:22:23 Re: Superuser lost access to particular database
Previous Message Simon_Kelly 2006-09-11 21:51:20 Issue with order by for type varchar