pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql data restore not working
3+ messages / 3 participants
[nested] [flat]
* psql data restore not working
@ 2008-08-29 00:26 Daniel Punton <compass2k@gmail.com>
2008-08-29 10:12 ` Re: psql data restore not working Vishal Arora <aroravishal22@hotmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Daniel Punton @ 2008-08-29 00:26 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql data restore not working
2008-08-29 00:26 psql data restore not working Daniel Punton <compass2k@gmail.com>
@ 2008-08-29 10:12 ` Vishal Arora <aroravishal22@hotmail.com>
2008-08-29 13:16 ` Re: psql data restore not working Rex Mabry <rexmabry@yahoo.com>
0 siblings, 1 reply; 3+ messages in thread
From: Vishal Arora @ 2008-08-29 10:12 UTC (permalink / raw)
To: Daniel Punton <compass2k@gmail.com>; pgsql-admin
Date: Fri, 29 Aug 2008 10:26:44 +1000From: compass2k@gmail.comTo: pgsql-admin@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 postgres 8 database.The schema was dumped withpg_dump -O -s databasename > database_schema_file_nameThe data was dumped withpg_dump -O -a databasename > database_data_file_namethe datafile was gzipped and transferred to another serverand gunzippedthe database was successfully createdthe schema was successfully generatedpsql -d databasename -f database_schema_file_namethe datafile was cleaned for the carriage return/line feed issue (between pgsql 7-> 8)sed 's/^M/\\r/' datafilename > datafilenameI attempted to insert the datapsql -d databasename -f database_data_file_name
Have you tried psql -U<userID> databasename < 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?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=
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql data restore not working
2008-08-29 00:26 psql data restore not working Daniel Punton <compass2k@gmail.com>
2008-08-29 10:12 ` Re: psql data restore not working Vishal Arora <aroravishal22@hotmail.com>
@ 2008-08-29 13:16 ` Rex Mabry <rexmabry@yahoo.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rex Mabry @ 2008-08-29 13:16 UTC (permalink / raw)
To: pgsql-admin
Are all of your database roles/permissons/search_path set on your new server?
--- 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 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
Have you tried psql -U<userID> databasename < 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
Searching for weekend getaways? Try Live.com Try it!
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-08-29 13:16 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-08-29 00:26 psql data restore not working Daniel Punton <compass2k@gmail.com>
2008-08-29 10:12 ` Vishal Arora <aroravishal22@hotmail.com>
2008-08-29 13:16 ` Rex Mabry <rexmabry@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox