Re: [ADMIN] psql data restore not working

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 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!