Skip site navigation (1) Skip section navigation (2)

PostgreSQL 8.0 pg_dump

From: "Prasanth" <dbadmin(at)nqadmin(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: PostgreSQL 8.0 pg_dump
Date: 2005-01-27 20:44:21
Message-ID: LGEKIACNKCMPMALCJMLOAEHOEBAA.dbadmin@nqadmin.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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 no column named
datpath it is in 7.4.1. When I am using the pg_restore in 8.0 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
database_path, p...
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;

Thanks,
-Prasanth.



pgsql-bugs by date

Next:From: Michael FuhrDate: 2005-01-27 21:33:05
Subject: Re: 8.0.0 make check fails on Solaris 9 (sparc)
Previous:From: Tom LaneDate: 2005-01-27 20:37:42
Subject: Re: [BUGS] My postmaster just crashed !

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group