From: | Carlos Henrique Reimer <carlosreimer(at)yahoo(dot)com(dot)br> |
---|---|
To: | Postgresql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Error during restore |
Date: | 2005-02-18 17:47:32 |
Message-ID: | 20050218174732.66714.qmail@web53207.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I´m trying to restore a client cluster in my Linux box but during the restore the following error is reported:
__________________________________________________________
DELETE 0
CREATE USER
'
\set ON_ERROR_STOP 'true'
--
-- PostgreSQL database cluster dump
--
\connect "template1"
You are now connected to database "template1".
--
-- Users
--
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0');
CREATE USER "TOTALL" WITH SYSID 100 PASSWORD 'md5fa2b2cda5e1d8577a287f118620a4d58' CREATEDB CREATEUSER;
ALTER USER "BENK" SET search_path TO '"BENK", public, pg_catalog';
psql:dumpall7.4.6_0902:14: ERROR: schema ""BENK", public, pg_catalog" does not exist
__________________________________________________________
The schema is only created somewhere after this commands. It´s like the execution order is wrong.
I used pg_dumpall withou any options to create the dump.
What could be wrong?
Reimer
---------------------------------
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador do Yahoo! agora.
From | Date | Subject | |
---|---|---|---|
Next Message | Ed L. | 2005-02-18 18:01:48 | Re: hung postmaster? |
Previous Message | S.D. | 2005-02-18 17:32:47 | PGSQL 8.0.1 Win 2K Installation Problem |