From: | Ian Lea <ian(dot)lea(at)gmail(dot)com> |
---|---|
To: | Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: trouble restoring database |
Date: | 2010-08-24 19:07:37 |
Message-ID: | AANLkTi=6+zT3rfzZ0AghGKS83wpu=Y-=++=eJEH+UoWt@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
At a glance, you may need gunzip -c.
--
Ian.
On Tue, Aug 24, 2010 at 7:22 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> Hi Everybody,
>
> I installed a postgres 8.4.4 onto a centos 5.5 machine and attempted to
> restore
> data from a file made by pg_dumpall. It didn’t work, it seems. What I did
> was to
> follow the instruction given in INSTALL file which comes with the source
> distribution.
> The section Getting Started gives a list and I did all but #5 (createdb
> testdb + psql testdb).
> Instead of #5, I ran the command below:
> 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.
> Can somebody please tell me why this didn’t work? Also, what must I do to
> successfully
> restore the database?
>
> Thank you in advance.
>
> Regards,
>
> Tena Sakai
> tsakai(at)gallo(dot)ucsf(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-08-24 19:10:31 | Re: Case Insensitive Database |
Previous Message | Scott Marlowe | 2010-08-24 19:01:51 | Re: postgresql 8.3 logging user passwords in clear text |