Sorry, the ALTER USER command is working fine, it only gives me a NOTICE and not an ERROR. Even without the schema the ALTER worked right! Thanks! -----Mensagem original----- De: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]Em nome de carlosreimer@xxxxxxxxxxxx Enviada em: quinta-feira, 4 de maio de 2006 00:52 Para: pgsql-general@xxxxxxxxxxxxxx Assunto: [GENERAL] pg_dumpall error 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; ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
