Skip site navigation (1) Skip section navigation (2)

Re: psql data restore not working

From: Rex Mabry <rexmabry(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql data restore not working
Date: 2008-08-29 13:16:23
Message-ID: 441604.38447.qm@web35905.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Are all of your database roles/permissons/search_path set on your new server?

--- On Fri, 8/29/08, Vishal Arora <aroravishal22(at)hotmail(dot)com> wrote:

From: Vishal Arora <aroravishal22(at)hotmail(dot)com>
Subject: Re: [ADMIN] psql data restore not working
To: "Daniel Punton" <compass2k(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)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(at)gmail(dot)com
To: pgsql-admin(at)postgresql(dot)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! 


      

In response to

pgsql-admin by date

Next:From: Andrew SullivanDate: 2008-08-29 13:34:36
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Brandon DybalaDate: 2008-08-29 12:52:42
Subject: Re: Installing PostgreSQL 8.3.3. on Vista

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group