pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: s.chava@wcom.com
To: pgsql-admin@postgresql.org
Subject: problem with pg_restore
Date: 29 Jan 2002 13:58:06 -0800
Message-ID: <66d229f1.0201291358.2292b7c9@posting.google.com> (raw)

Hi,
I have a problem with pg_restore. I have a database,  named DEPG. I
have taken backup with pg_dump and -Ft options. I created  another
database, named test. After this , I used the pg_restore command  to
restore the DEPG backup into test database. Then it is restoring upto
some point and failing giving the following error.

Below is the complete output:

$ pg_restore -v -Ft -d test 15:05-postgresql_database-DEPG-backup

Connecting to database for restore
Connecting to test as pgsql
Creating TABLE pgadmin_desc
Connecting to test as develop
Creating TABLE announce
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
'announce_pkey' for table 'announce'
Creating ACL announce
Connecting to test as pgsql
Creating TABLE pgadmin_param
Creating ACL pgadmin_param
Creating TABLE pgadmin_rev_log
Creating ACL pgadmin_rev_log
Creating TABLE pgadmin_seq_cache
Creating ACL pgadmin_seq_cache
Creating TABLE pgadmin_table_cache
Creating ACL pgadmin_table_cache
Creating FUNCTION "pgadmin_get_desc" (oid)
Creating FUNCTION "pgadmin_get_pgdesc" (oid)
Creating FUNCTION "pgadmin_get_col_def" (oid,integer)
Creating FUNCTION "pgadmin_get_handler" (oid)
Creating FUNCTION "pgadmin_get_type" (oid)
Creating FUNCTION "pgadmin_get_rows" (oid)
Creating FUNCTION "pgadmin_get_sequence" (oid)
Creating ACL pgadmin_databases

Archiver(db): Could not execute query. Code = 7. Explanation from
backend: 'ERROR:  Relation 'pgadmin_databases' does not exist
'.


Actually, there is pgadmin_databases view in DEPG database and I took
the backup from it. Why it is giving this error and terminating the
restore operation, when i use pg_restore.

Any help is appreciated and thanks in advance.



view thread (6+ messages)  latest in thread

Message-ID: <66d229f1.0201291358.2292b7c9@posting.google.com>
Permalink:  ../66d229f1.0201291358.2292b7c9@posting.google.com/
Also on:    postgresql.org/message-id/66d229f1.0201291358.2292b7c9@posting.google.com

 · 

reply

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: s.chava@wcom.com
  Subject: Re: problem with pg_restore
  In-Reply-To: <66d229f1.0201291358.2292b7c9@posting.google.com>

* 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