pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dumpall anomaly
3+ messages / 2 participants
[nested] [flat]
* pg_dumpall anomaly
@ 2001-06-12 00:10 Tim Mickol <tmickol@combimatrix.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tim Mickol @ 2001-06-12 00:10 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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: <schema_name>|<schema_owner>| 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"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_dumpall anomaly
@ 2001-06-12 07:10 Tom Lane <tgl@sss.pgh.pa.us>
parent: Tim Mickol <tmickol@combimatrix.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2001-06-12 07:10 UTC (permalink / raw)
To: tmickol@combimatrix.com; +Cc: pgsql-general@postgresql.org
"Tim Mickol" <tmickol@combimatrix.com> writes:
> what are the: <schema_name>|<schema_owner>| directives all about?
Good question. They look like an abbreviated select from pg_database,
but pg_dumpall shouldn't be doing any such thing. Is it possible you've
got a locally modified pg_dumpall script?
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: pg_dumpall anomaly
@ 2001-06-12 19:24 Tim Mickol <tmickol@combimatrix.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tim Mickol @ 2001-06-12 19:24 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-general@postgresql.org
no possibility that it was a locally modified script. pg_dumpall came
straight out of the 7.1.2-2 PGDG binary rpm
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Tom Lane
Sent: Tuesday, June 12, 2001 12:11 AM
To: tmickol@combimatrix.com
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg_dumpall anomaly
"Tim Mickol" <tmickol@combimatrix.com> writes:
> what are the: <schema_name>|<schema_owner>| directives all about?
Good question. They look like an abbreviated select from pg_database,
but pg_dumpall shouldn't be doing any such thing. Is it possible you've
got a locally modified pg_dumpall script?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-06-12 19:24 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-12 00:10 pg_dumpall anomaly Tim Mickol <tmickol@combimatrix.com>
2001-06-12 07:10 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-06-12 19:24 ` Tim Mickol <tmickol@combimatrix.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox