pg_restore & pg_database - 01-24-2005 , 06:51 PM
I am trying to restore a dump from 7.4.1 to 8.0.
I am using the pg_dump in 8.0 to dump the database. I am getting the
following error message.
I looked up the pg_database table in 8.0 and there is not column named
datpath it is in 7.4.1.
When I am using the pg_restore in 8.0 it shouldn't it be knowing that the
datpath does not exist??
Actual Error Message:
pg_restore: [archiver (db)] could not execute query: ERROR: column
d.datpath does not exist
Command was: CREATE VIEW pgadmin_databases AS
SELECT d.oid AS database_oid, d.datname AS database_name, d.datpath AS
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"public.pgadmin_databases" does not exist
Command was: ALTER TABLE public.pgadmin_databases OWNER TO postgres;
Re: pg_restore & pg_database - 01-25-2005 , 04:05 AM
On Mon, 24 Jan 2005 18:51:44 -0600, Prasanth wrote:
then pg_restore from v8.0 to restore it?