Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9Q13PP38759 for ; Thu, 25 Oct 2001 21:03:25 -0400 (EDT) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 357 for ; Thu, 25 Oct 2001 18:53:22 -0600 Message-ID: <3BD8BADA.143F4B80@waterford.org> Date: Thu, 25 Oct 2001 19:22:34 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Postgres SQL Mailing List Subject: URGENT: restoring a database Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/365 X-Sequence-Number: 5318 Hi, I think I got a problem here. I tried to restore my database from dump.bac file, which was created with pg_dumpall -o > dump.bac This is what I did: > createdb replica > psql -d replica -f dump.bac Notice that I have two different databases stored in this file. This is what I got: You are now connected to database template1. DELETE 3 psql:db_10_22_01.bac:7: ERROR: CREATE USER: permission denied psql:db_10_22_01.bac:8: ERROR: CREATE USER: permission denied psql:db_10_22_01.bac:9: ERROR: CREATE USER: permission denied psql:db_10_22_01.bac:11: ERROR: pg_aclcheck: invalid user id 503 You are now connected to database template1 as user postgres. psql:db_10_22_01.bac:18: ERROR: CREATE DATABASE: database "webspectest" already exists You are now connected to database webspectest as user postgres. CREATE DROP You are now connected as new user postgres. psql:db_10_22_01.bac:48: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'activitytype_pkey' for table 'activitytype' psql:db_10_22_01.bac:48: ERROR: Relation 'activitytype' already exists psql:db_10_22_01.bac:65: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'dcr_pkey' for table 'dcr' Obviously, no database was created. Moreover, I can not access my neither of my existing databases anymore. When I try: > psql webspectest I get an error: psql: FATAL 1: user "olebedev" does not exist At this point I am completely stuck. Please help. thanks, Oleg