From: Vishal Arora <aroravishal22@hotmail.com>
To: Daniel Punton <compass2k@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: psql data restore not working
Date: Fri, 29 Aug 2008 15:42:53 +0530
Message-ID: <BLU149-W60ACB24B165FE88CC6069A9630@phx.gbl> (raw)
In-Reply-To: <e969e33c0808281726l438aa68ctfe2a540406b4d6d0@mail.gmail.com>
References: <e969e33c0808281726l438aa68ctfe2a540406b4d6d0@mail.gmail.com>
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=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aroravishal22@hotmail.com, compass2k@gmail.com
Subject: Re: psql data restore not working
In-Reply-To: <BLU149-W60ACB24B165FE88CC6069A9630@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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