Date: Fri, 29 Aug 2008 10:26:44 +1000From: [EMAIL PROTECTED]: [EMAIL
PROTECTED]: [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
