pg_dumpall error
От | |
---|---|
Тема | pg_dumpall error |
Дата | |
Msg-id | PEEPKDFEHHEMKBBFPOOKKEAJCIAA.carlosreimer@terra.com.br обсуждение исходный текст |
Ответы |
RES: pg_dumpall error
|
Список | pgsql-general |
Hello, I´m trying to recreate my cluster using a restore a dump created by pg_dumpall 8.0.3 but it´s not working. The problem is that just after the connection to template1 the script is trying to use a schema that doesn´t exist yet. The creation of the schema exist, but is far after. Is this the best approach to recreate a cluster using a dump? Maybe it would be better to dump thinks in parts, like: a) global objects, b) each database, and then restore the whole cluster. Thanks in advance! Reimer Here is the beginning of the script: -- PostgreSQL database cluster dump -- \connect "template1" -- -- Users -- CREATE USER "LIEGE" WITH SYSID 122 PASSWORD 'md585edf4f3a0536dfb4aab88b0dcc4a15b' CREATEDB CREATEUSER; ALTER USER "LIEGE" SET search_path TO public, "TOTALL", pg_catalog;
В списке pgsql-general по дате отправления: