DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type;
	b=Va3yWxTvEaVpSwPOA/7wc/wcwtC32wZSu3nxs+Fh8wf9YEe/KuICJX4dZkXEJs94khu0rwZPTXtOYGmhELHiUa1n0WWy4IQ3nDd4nFUpYuQg9YOqVYRuCiPlW1I6cRvz7sCG0dPq1ig88RYVIEEfxTgtq/qgxj0+MvSvnVvpjsg=;
Message-ID: <384163.64826.qm@web51901.mail.re2.yahoo.com>
Date: Tue, 18 May 2010 16:14:49 -0700 (PDT)
From: Tena Sakai <sakaitena@yahoo.com>
Subject: troubled by pg_dump and pg_restore
To: pgsql-admin@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-78956169-1274224489=:64826"

--0-78956169-1274224489=:64826
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi Everybody,

I am a bit troubled by pg_dump and pg_restore.=A0 My platform is
redhat linux, Del 64 bit hardware, running postgres 8.3.7.
I have a database named canon and I want to move a schema full of
tables from canon to a new database named musket.=A0 The schema I
am interested in is called tsakai.=A0 Here's what I have done:

=A0 $ env | grep PG
=A0 PGUSER=3Dpostgres
=A0 PGDATABASE=3Dcanon
=A0 PGHOST=3Dlocalhost
=A0 PGDATA=3D/usr/local/pgsql/data
=A0 $
=A0 $ pg_dump -n tsakai > canon_tsakai.sql
=A0 $
=A0 $ echo $?
=A0 0
=A0 $
=A0 $ pg_restore -l canon_tsakai.sql
=A0 pg_restore: [archiver] input file does not appear to be a valid archive
=A0 $=20
=A0 $ pg_restore -d musket canon_tsakai.sql
=A0 pg_restore: [archiver] input file does not appear to be a valid archive

Can someone please tell me (1) if there is anything wrong with my invocatio=
n
of pd_dump?=A0 (I want to generate a file pd_restore can use to feed to
musket database.)=A0 (2) Why pg_restore wouldn't give me listing?=A0 And (3=
)
why the second pg_restore command is upset?

Thank you.

Regards,

Tena sakai
--0-78956169-1274224489=:64826
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<table cellspacing=3D"0" cellpadding=3D"0" border=3D"0" ><tr><td valign=3D"=
top" style=3D"font: inherit;">Hi Everybody,<br><br>I am a bit troubled by p=
g_dump and pg_restore.&nbsp; My platform is<br>redhat linux, Del 64 bit har=
dware, running postgres 8.3.7.<br>I have a database named canon and I want =
to move a schema full of<br>tables from canon to a new database named muske=
t.&nbsp; The schema I<br>am interested in is called tsakai.&nbsp; Here's wh=
at I have done:<br><br>&nbsp; $ env | grep PG<br>&nbsp; PGUSER=3Dpostgres<b=
r>&nbsp; PGDATABASE=3Dcanon<br>&nbsp; PGHOST=3Dlocalhost<br>&nbsp; PGDATA=
=3D/usr/local/pgsql/data<br>&nbsp; $<br>&nbsp; $ pg_dump -n tsakai &gt; can=
on_tsakai.sql<br>&nbsp; $<br>&nbsp; $ echo $?<br>&nbsp; 0<br>&nbsp; $<br>&n=
bsp; $ pg_restore -l canon_tsakai.sql<br>&nbsp; pg_restore: [archiver] inpu=
t file does not appear to be a valid archive<br>&nbsp; $ <br>&nbsp; $ pg_re=
store -d musket canon_tsakai.sql<br>&nbsp; pg_restore: [archiver] input fil=
e does not
 appear to be a valid archive<br><br>Can someone please tell me (1) if ther=
e is anything wrong with my invocation<br>of pd_dump?&nbsp; (I want to gene=
rate a file pd_restore can use to feed to<br>musket database.)&nbsp; (2) Wh=
y pg_restore wouldn't give me listing?&nbsp; And (3)<br>why the second pg_r=
estore command is upset?<br><br>Thank you.<br><br>Regards,<br><br>Tena saka=
i</td></tr></table>
--0-78956169-1274224489=:64826--