Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id D3058650054
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 29 Aug 2008 07:13:05 -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 18535-01 for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 29 Aug 2008 07:12:52 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from blu0-omc2-s17.blu0.hotmail.com (blu0-omc2-s17.blu0.hotmail.com
	[65.55.111.92]) by postgresql.org (Postfix) with ESMTP id 0F67764FEE1
	for <pgsql-admin@postgresql.org>; Fri, 29 Aug 2008 07:12:55 -0300 (ADT)
Received: from BLU149-W6 ([65.55.111.73]) by blu0-omc2-s17.blu0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Fri, 29 Aug 2008 03:12:53 -0700
Message-ID: <BLU149-W60ACB24B165FE88CC6069A9630@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_44d393ca-4a6b-4118-a8fc-4317b1632845_"
X-Originating-IP: [59.160.193.34]
From: Vishal Arora <aroravishal22@hotmail.com>
To: Daniel Punton <compass2k@gmail.com>, <pgsql-admin@postgresql.org>
Subject: Re: psql data restore not working
Date: Fri, 29 Aug 2008 15:42:53 +0530
Importance: Normal
In-Reply-To: <e969e33c0808281726l438aa68ctfe2a540406b4d6d0@mail.gmail.com>
References: <e969e33c0808281726l438aa68ctfe2a540406b4d6d0@mail.gmail.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 29 Aug 2008 10:12:53.0442 (UTC)
	FILETIME=[CCB27220:01C909BF]
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/229
X-Sequence-Number: 30074

--_44d393ca-4a6b-4118-a8fc-4317b1632845_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Date: Fri=2C 29 Aug 2008 10:26:44 +1000From: compass2k@gmail.comTo: pgsql-a=
dmin@postgresql.orgSubject: [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  7.1 database to a p=
ostgres 8 database.The schema was dumped withpg_dump -O -s databasename > d=
atabase_schema_file_nameThe data was dumped withpg_dump -O -a databasename =
> database_data_file_namethe datafile was gzipped and transferred to anothe=
r serverand gunzippedthe database was successfully createdthe schema was su=
ccessfully generatedpsql -d databasename -f database_schema_file_namethe da=
tafile was cleaned for the carriage return/line feed issue (between pgsql 7=
-> 8)sed 's/^M/\\r/' datafilename > datafilenameI attempted to insert the d=
atapsql -d databasename -f database_data_file_name
Have you tried psql -U<userID> databasename < database_data_file_name
=20
no errors but when I query the data - there is none ..Any ideas what I migh=
t be missing or how to see any errors or warnings?CheersDaniel PuntonSenior=
 Analyst/ProgrammerTransact/EForms Team CSC
_________________________________________________________________
Searching for the best deals on travel? Visit MSN Travel.
http://msn.coxandkings.co.in/cnk/cnk.do=

--_44d393ca-4a6b-4118-a8fc-4317b1632845_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt=3B
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class=3D'hmmessage'><BR><BR><BR><BR>
<HR id=3DEC_stopSpelling>
Date: Fri=2C 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 worki=
ng<BR><BR>
<DIV dir=3Dltr>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&n=
bsp=3B 7.1 database to a postgres 8 database.<BR><BR>The schema was dumped =
with<BR>pg_dump -O -s databasename &gt=3B database_schema_file_name<BR>The =
data was dumped with<BR>pg_dump -O -a databasename &gt=3B database_data_fil=
e_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 w=
as successfully generated<BR>psql -d databasename -f database_schema_file_n=
ame<BR>the datafile was cleaned for the carriage return/line feed issue (be=
tween pgsql 7-&gt=3B 8)<BR>sed 's/^M/\\r/' datafilename &gt=3B datafilename=
<BR>I attempted to insert the data<BR>psql -d databasename -f database_data=
_file_name</DIV>
<DIV dir=3Dltr><BR><FONT color=3D#800000>Have you tried psql -U&lt=3BuserID=
&gt=3B databasename &lt=3B database_data_file_name</FONT></DIV>
<DIV dir=3Dltr><FONT color=3D#800000></FONT>&nbsp=3B</DIV>
<DIV dir=3Dltr>no errors but when I query the data - there is none ..<BR><B=
R>Any ideas what I might be missing or how to see any errors or warnings?<B=
R><BR>Cheers<BR>Daniel Punton<BR>Senior Analyst/Programmer<BR>Transact/EFor=
ms Team CSC<BR><BR></DIV><br /><hr />Searching for weekend getaways? Try Li=
ve.com <a href=3D'http://www.live.com/?scope=3Dvideo&form=3DMICOAL' target=
=3D'_new'>Try it!</a></body>
</html>=

--_44d393ca-4a6b-4118-a8fc-4317b1632845_--