Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id CEA1D64FFBC
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 29 Aug 2008 10:16:38 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 98321-02 for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 29 Aug 2008 10:16:20 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web35905.mail.mud.yahoo.com (web35905.mail.mud.yahoo.com
	[66.163.179.189])
	by postgresql.org (Postfix) with SMTP id 1CF2364FEDB
	for <pgsql-admin@postgresql.org>; Fri, 29 Aug 2008 10:16:24 -0300 (ADT)
Received: (qmail 38875 invoked by uid 60001); 29 Aug 2008 13:16:23 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=eRYGhiDC7xGNfSI01t2O77U/E+Depg/aonHD5G3WU5O+eXfsVFfEbbEmhicwVqlFqwZtw+MHuVWlsF65HT9Ry5ILlAOMpJYdIQ+CAURE/4caf0H1bFpK+FbaOXkImgZnRMEM5azgadMZ+XPH/hApHHRxtt8O0YOHcTpWbX8WXos=;
X-YMail-OSG: 
 ABfbq4UVM1n0tB1QjkZ.X_yml5j68CeOAyms5JUoK8RWh.4nyp1C8Y8YXcopvmqAXabKoVbE5fQ_JNWzQzQpADziY0EihHef2.a77yIu9R_03KmQlCJ8MF24GfibDoI-
Received: from [199.200.10.52] by web35905.mail.mud.yahoo.com via HTTP;
	Fri, 29 Aug 2008 06:16:23 PDT
X-Mailer: YahooMailWebService/0.7.218.2
Date: Fri, 29 Aug 2008 06:16:23 -0700 (PDT)
From: Rex Mabry <rexmabry@yahoo.com>
Reply-To: rexmabry@yahoo.com
Subject: Re: psql data restore not working
To: pgsql-admin@postgresql.org
In-Reply-To: <BLU149-W60ACB24B165FE88CC6069A9630@phx.gbl>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-1696081259-1220015783=:38447"
Message-ID: <441604.38447.qm@web35905.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200808/231
X-Sequence-Number: 30076

--0-1696081259-1220015783=:38447
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Are=A0all of your database roles/permissons/search_path set on your new ser=
ver?

--- On Fri, 8/29/08, Vishal Arora <aroravishal22@hotmail.com> wrote:

From: Vishal Arora <aroravishal22@hotmail.com>
Subject: Re: [ADMIN] psql data restore not working
To: "Daniel Punton" <compass2k@gmail.com>, pgsql-admin@postgresql.org
Date: Friday, August 29, 2008, 5:12 AM




#yiv312980144 .hmmessage P
{
margin:0px;padding:0px;}
#yiv312980144 {
FONT-SIZE:10pt;FONT-FAMILY:Tahoma;}







Date: Fri, 29 Aug 2008 10:26:44 +1000
From: compass2k@gmail.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] psql data restore not working


I would be glad on advice what might be the issue (or how I could narrow it=
 down)
with the non restoration of data from a postgres=A0 7.1 database to a postg=
res 8 database.

The schema was dumped with
pg_dump -O -s databasename > database_schema_file_name
The data was dumped with
pg_dump -O -a databasename > database_data_file_name

the datafile was gzipped and transferred to another server
and gunzipped

the database was successfully created
the schema was successfully generated
psql -d databasename -f database_schema_file_name
the datafile was cleaned for the carriage return/line feed issue (between p=
gsql 7-> 8)
sed 's/^M/\\r/' datafilename > datafilename
I attempted to insert the data
psql -d databasename -f database_data_file_name

Have you tried psql -U<userID> databasename < database_data_file_name
=A0
no errors but when I query the data - there is none ..

Any ideas what I might be missing or how to see any errors or warnings?

Cheers
Daniel Punton
Senior Analyst/Programmer
Transact/EForms Team CSC




Searching for weekend getaways? Try Live.com Try it! =0A=0A=0A      
--0-1696081259-1220015783=:38447
Content-Type: text/html; charset=us-ascii

<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Are&nbsp;all of your database roles/permissons/search_path set on your new server?<BR><BR>--- On <B>Fri, 8/29/08, Vishal Arora <I>&lt;aroravishal22@hotmail.com&gt;</I></B> wrote:<BR>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid">From: Vishal Arora &lt;aroravishal22@hotmail.com&gt;<BR>Subject: Re: [ADMIN] psql data restore not working<BR>To: "Daniel Punton" &lt;compass2k@gmail.com&gt;, pgsql-admin@postgresql.org<BR>Date: Friday, August 29, 2008, 5:12 AM<BR><BR>
<DIV id=yiv312980144>
<STYLE>
#yiv312980144 .hmmessage P
{
margin:0px;padding:0px;}
#yiv312980144 {
FONT-SIZE:10pt;FONT-FAMILY:Tahoma;}
</STYLE>
<BR><BR><BR><BR>
<HR id=EC_stopSpelling>
Date: Fri, 29 Aug 2008 10:26:44 +1000<BR>From: compass2k@gmail.com<BR>To: pgsql-admin@postgresql.org<BR>Subject: [ADMIN] psql data restore not working<BR><BR>
<DIV dir=ltr>I would be glad on advice what might be the issue (or how I could narrow it down)<BR>with the non restoration of data from a postgres&nbsp; 7.1 database to a postgres 8 database.<BR><BR>The schema was dumped with<BR>pg_dump -O -s databasename &gt; database_schema_file_name<BR>The data was dumped with<BR>pg_dump -O -a databasename &gt; database_data_file_name<BR><BR>the datafile was gzipped and transferred to another server<BR>and gunzipped<BR><BR>the database was successfully created<BR>the schema was successfully generated<BR>psql -d databasename -f database_schema_file_name<BR>the datafile was cleaned for the carriage return/line feed issue (between pgsql 7-&gt; 8)<BR>sed 's/^M/\\r/' datafilename &gt; datafilename<BR>I attempted to insert the data<BR>psql -d databasename -f database_data_file_name</DIV>
<DIV dir=ltr><BR><FONT color=#800000>Have you tried psql -U&lt;userID&gt; databasename &lt; database_data_file_name</FONT></DIV>
<DIV dir=ltr><FONT color=#800000></FONT>&nbsp;</DIV>
<DIV dir=ltr>no errors but when I query the data - there is none ..<BR><BR>Any ideas what I might be missing or how to see any errors or warnings?<BR><BR>Cheers<BR>Daniel Punton<BR>Senior Analyst/Programmer<BR>Transact/EForms Team CSC<BR><BR></DIV><BR>
<HR>
Searching for weekend getaways? Try Live.com <A href="http://www.live.com/?scope=video&amp;form=MICOAL" target=_blank rel=nofollow>Try it!</A> </DIV></BLOCKQUOTE></td></tr></table><br>



      
--0-1696081259-1220015783=:38447--