Received: from mail.combimatrix.com (mail.combimatrix.com [209.35.95.29]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5C02wE49539 for ; Mon, 11 Jun 2001 20:02:58 -0400 (EDT) (envelope-from tmickol@combimatrix.com) Received: from TJMICKOLCOMP [209.35.95.29] by mail.combimatrix.com (SMTPD32-6.05) id AC2C24E00F0; Mon, 11 Jun 2001 20:02:52 -0400 Reply-To: From: "Tim Mickol" To: Subject: pg_dumpall anomaly Date: Mon, 11 Jun 2001 17:10:20 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 In-Reply-To: <20010611173733.B29434@serensoft.com> Importance: Normal X-Archive-Number: 200106/395 X-Sequence-Number: 10740 Experienced some pg_dumpall weirdness this past weekend when dumping a cluster to propagate it to some other servers; here are the first 18 lines of the pg_dumpall output: -- -- pg_dumpall (7.1.2) -- \connect template1 DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database WHERE datname = 'template0'); db1|db1_dba| db2|db2_dba| db3|db3_dba| postgres|postgres| template0|postgres| template1|postgres|Default template database CREATE USER "db1_dba" WITH SYSID 10 PASSWORD 'dba_passwd1' CREATEDB CREATEUSER; CREATE USER "db1_user" WITH SYSID 11 PASSWORD 'usr_passwd1' NOCREATEDB NOCREATEUSER; CREATE USER "db2_dba" WITH SYSID 20 PASSWORD 'dba_passwd2' CREATEDB CREATEUSER; CREATE USER "db2_user" WITH SYSID 21 PASSWORD 'user_passwd2' NOCREATEDB NOCREATEUSER; CREATE USER "db3_dba" WITH SYSID 30 PASSWORD 'dba_passwd3' CREATEDB CREATEUSER; CREATE USER "db3_usr" WITH SYSID 31 PASSWORD 'usr_passwd3' NOCREATEDB NOCREATEUSER; psql -f pg_cluster_dump.sql template1; systax error on line 13 near "db1" what are the: || directives all about? They are obviously(?) causing a syntax error in the CREATE USER line that follows them - user "db1_dba" was not being created. A kludgely solution was to simply duplicate the line. The question is, why did those lines get inserted? I did successfully propagate the cluster and found that all subsequent pg_dumpall executions were fine; in other words I (fortunately) could not repro the problem. Any obvious explanations? tjm "All usernames and passwds in this program have been changed to protect the innocent"