Are all of your database roles/permissons/search_path set on your new server?
--- On Fri, 8/29/08, Vishal Arora <[EMAIL PROTECTED]> wrote:
From: Vishal Arora <[EMAIL PROTECTED]>
Subject: Re: [ADMIN] psql data restore not working
To: "Daniel Punton" <[EMAIL PROTECTED]>
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
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 databa
