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

Re: psql data restore not working

From: Vishal Arora <aroravishal22(at)hotmail(dot)com>
To: Daniel Punton <compass2k(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: psql data restore not working
Date: 2008-08-29 10:12:53
Message-ID: BLU149-W60ACB24B165FE88CC6069A9630@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-admin

Date: Fri, 29 Aug 2008 10:26:44 +1000From: compass2k(at)gmail(dot)comTo: pgsql-admin(at)postgresql(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Brandon DybalaDate: 2008-08-29 12:52:42
Subject: Re: Installing PostgreSQL 8.3.3. on Vista
Previous:From: Phoenix KiulaDate: 2008-08-29 05:53:28
Subject: Re: Dumping/Restoring with constraints?

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