Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: trouble restoring database

Posted on 2010-08-24 20:22:37 by Tena Sakai

--_000_C8995BFDC10Btsakaigalloucsfedu_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi Everybody,

I installed a postgres 8.4.4 onto a centos 5.5 machine and attempted to res=
tore
data from a file made by pg_dumpall. It didn=92t work, it seems. What I d=
id was to
follow the instruction given in INSTALL file which comes with the source di=
stribution.
The section Getting Started gives a list and I did all but #5 (createdb tes=
tdb + psql testdb).
Instead of #5, I ran the command below:
gunzip ..../dumpall20100822.0.gz | /usr/local/pgsql/bin/psql -f =96 post=
gres
Which terminated with exit status 0.

But when I look at pg_stat_database I don=92t see the database I expected.
Can somebody please tell me why this didn=92t work? Also, what must I do t=
o successfully
restore the database?

Thank you in advance.

Regards,

Tena Sakai
tsakai@gallo.ucsf.edu

--_000_C8995BFDC10Btsakaigalloucsfedu_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html><head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252"><title>trouble restoring database</title>
</head>
<body>
<font face=3D"Calibri, Verdana, Helvetica, Arial"><span style=3D"font-size:=
11pt">Hi Everybody,<br>
<br>
I installed a postgres 8.4.4 onto a centos 5.5 machine and attempted to res=
tore<br>
data from a file made by pg_dumpall. &nbsp;It didn=92t work, it seems. &nbs=
p;What I did was to<br>
follow the instruction given in INSTALL file which comes with the source di=
stribution.<br>
The section Getting Started gives a list and I did all but #5 (createdb tes=
tdb &#43; psql testdb).<br>
Instead of #5, I ran the command below:<br>
&nbsp;&nbsp;&nbsp;gunzip ..../dumpall20100822.0.gz | /usr/local/pgsql/bin/p=
sql -f =96 postgres<br>
Which terminated with exit status 0.<br>
<br>
But when I look at pg_stat_database I don=92t see the database I expected.<=
br>
Can somebody please tell me why this didn=92t work? &nbsp;Also, what must I=
do to successfully<br>
restore the database?<br>
<br>
Thank you in advance.<br>
<br>
Regards,<br>
<br>
Tena Sakai<br>
<a href=3D"tsakai@gallo.ucsf.edu">tsakai@gallo.ucsf.edu</a></span></font>
</body>
</html>


--_000_C8995BFDC10Btsakaigalloucsfedu_--

Report this message

#2: Re: trouble restoring database

Posted on 2010-08-24 21:07:37 by Ian Lea

At a glance, you may need gunzip -c.


--
Ian.


On Tue, Aug 24, 2010 at 7:22 PM, Tena Sakai <tsakai@gallo.ucsf.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. =A0It didn=92t work, it seems. =A0Wh=
at 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:
>   =A0gunzip ..../dumpall20100822.0.gz | /usr/local/pgsql/bin/psql -f =
=96
> postgres
> Which terminated with exit status 0.
>
> But when I look at pg_stat_database I don=92t see the database I expected.
> Can somebody please tell me why this didn=92t work? =A0Also, what must I =
do to
> successfully
> restore the database?
>
> Thank you in advance.
>
> Regards,
>
> Tena Sakai
> tsakai@gallo.ucsf.edu

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Report this message

#3: Re: trouble restoring database

Posted on 2010-08-24 21:12:15 by Kevin Grittner

Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
=20
> gunzip ..../dumpall20100822.0.gz
> | /usr/local/pgsql/bin/psql -f * postgres
> Which terminated with exit status 0.
>=20
> But when I look at pg_stat_database I don*t see the database I
> expected.
=20
What database did you expect? What do you see? Is there anything
interesting in the log file?
=20
> Can somebody please tell me why this didn*t work? Also, what must
> I do to successfully restore the database?
=20
Please read this page and post again with more information:
=20
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
=20
-Kevin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Report this message