psql data restore not working

------=_Part_14892_21391696.1219969604837
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 postgres
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
pgsql 7-> 8)
sed 's/^M/\\r/' datafilename > datafilename
I attempted to insert the data
psql -d databasename -f database_data_file_name
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

------=_Part_14892_21391696.1219969604837
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Re: psql data restore not working

--_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 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

Re: psql data restore not working

--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 wrote:

From: Vishal Arora
Subject: Re: [ADMIN] psql data restore not working
To: "Daniel Punton" , 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 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
--0-1696081259-1220015783=:38447
Content-Type: text/html; charset=us-ascii