| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jose Calderon <jcalderon(at)nandk(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: database cluster missing |
| Date: | 2007-11-26 22:10:26 |
| Message-ID: | 4338.1196115026@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Jose Calderon <jcalderon(at)nandk(dot)com> writes:
> Hello I don't know where to start with this problem, so we do weekly
> backups of our computers. The hard drive of one of our computers stopped
> working so we are trying to restore it. We had an image of the hard drive
> and used the latest backups. Now I can start the database without a
> problem but it doesn't list any of the databases we had on it. Using
> SELECT datname FROM pg_database ORDER BY datname returns no entries and
> even if I connect using pgAdmin III I see no databases.
Vacuuming pg_database might help ... if so, you probably need
database-wide vacuums in all your databases.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Elvis Henríquez | 2007-11-27 03:34:09 | Case studies |
| Previous Message | David Young | 2007-11-26 21:05:17 | Is there an easy and safe way to migrate a database to a new tablespace? |