Re: psql \l problem - Mailing list pgsql-admin

From Joe DeBrunner
Subject Re: psql \l problem
Date
Msg-id 9qdh7s$1khr$1@news.tht.net
Whole thread Raw
In response to Re: psql \l problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: psql \l problem
List pgsql-admin
Tom,

Thanks for the reply.

I checked the pg_shadow table and all of the users I have added are still
there. Can't tell if the usesysid for each of them has changed or not. Is
there any way to determine the database owners id as listed in pg_database?
I've tried using the postgres id and granting superuser to one of the ids
but still can't list anything on the other databases. Other than being able
to connect to them there is nothing to indicate they exist anywhere.

I have also used phpPgAdmin to try to find some trace of the databases. No
luck unless I manually type the database in the URL. Then it lists all of
the details. For example, if I use type in db_details.php?server=1&db=horde
I can see details of the database. It lists postgres as the owner, but
postgres can't see it in a normal psql session or in a normal phpPgAdmin
view. Also, it says the database has no tables.

Another example, I can "\c states" to connect to an unlisted database and
then "select * from statename" to list the contents of the table, but it
won't list the table using \dt or using phpPgAdmin.

Can't think of any reason the ids would have changed or been deleted and
then readded.

I just hand entered the missing databases into pg_database and can now see
the databases, but they don't have any tables. Very confusing!

Joe

"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:1218.1002916236@sss.pgh.pa.us...
> "Joe DeBrunner" <jdebrunner@NO_SPAMyahoo.com> writes:
> > For some reason I can no longer see all of the databases in Postgresql.
When
> > I am in psql and type \l  I only see template1. I can \c to connect to
the
> > databases but they will not list. Same thing with tables. The tables are
> > there, but I cannot \dt to list them.
> > Any idea what might cause this?
>
> You probably deleted the pg_shadow entries for the other databases'
> owners.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



pgsql-admin by date:

Previous
From: Stuart Bishop
Date:
Subject: Re: Permission Denied When i am Trying to take Backup
Next
From: Chris Pesko
Date:
Subject: How do you manage WAL logs......