Re: trouble restoring database

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: trouble restoring database
Date: 2010-08-24 19:12:15
Message-ID: 4C73D33F0200002500034AF1@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-08-24 19:40:35 Re: postgresql 8.3 logging user passwords in clear text
Previous Message Scott Marlowe 2010-08-24 19:10:31 Re: Case Insensitive Database