Re: trouble restoring database - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: trouble restoring database
Date
Msg-id 4C73D33F0200002500034AF1@gw.wicourts.gov
Whole thread Raw
In response to trouble restoring database  (Tena Sakai <tsakai@gallo.ucsf.edu>)
Responses Re: trouble restoring database  (Tena Sakai <tsakai@gallo.ucsf.edu>)
List pgsql-admin
Tena Sakai <tsakai@gallo.ucsf.edu> wrote:

>    gunzip ..../dumpall20100822.0.gz
>    | /usr/local/pgsql/bin/psql -f * postgres
> Which terminated with exit status 0.
>
> But when I look at pg_stat_database I don*t see the database I
> expected.

What database did you expect?  What do you see?  Is there anything
interesting in the log file?

> Can somebody please tell me why this didn*t work?  Also, what must
> I do to successfully restore the database?

Please read this page and post again with more information:

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

-Kevin

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Case Insensitive Database
Next
From: Tom Lane
Date:
Subject: Re: postgresql 8.3 logging user passwords in clear text