Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0TLxRl56348 for ; Tue, 29 Jan 2002 16:59:28 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id g0TLwCM20002 for pgsql-admin@postgresql.org; Tue, 29 Jan 2002 16:58:12 -0500 (EST) (envelope-from news) From: s.chava@wcom.com (Srinivasa Rao Chava) X-Newsgroups: comp.databases.postgresql.admin Subject: problem with pg_restore Date: 29 Jan 2002 13:58:06 -0800 Organization: http://groups.google.com/ Lines: 47 Message-ID: <66d229f1.0201291358.2292b7c9@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-admin@postgresql.org X-Archive-Number: 200201/248 X-Sequence-Number: 3129 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.