pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_dumpall + psql -e template1
4+ messages / 4 participants
[nested] [flat]
* pg_dumpall + psql -e template1
@ 1999-09-24 21:47 Clayton Cottingham <drfrog@smartt.com>
0 siblings, 1 reply; 4+ messages in thread
From: Clayton Cottingham @ 1999-09-24 21:47 UTC (permalink / raw)
To: pgsql-sql
when i dump out all dbspg_dumpall>dbs.out and try to put into a new
installation psql -e template1 <dbs.out it always fails when trying to
copy the actual data
usually producing errors that result in the \? listings and then a seq
fault
has anyone experienced this?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] pg_dumpall + psql -e template1
@ 1999-09-24 22:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: Clayton Cottingham <drfrog@smartt.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 1999-09-24 22:42 UTC (permalink / raw)
To: Clayton Cottingham <drfrog@smartt.com>; +Cc: pgsql-sql
Clayton Cottingham <drfrog@smartt.com> writes:
> when i dump out all dbspg_dumpall>dbs.out and try to put into a new
> installation psql -e template1 <dbs.out it always fails when trying to
> copy the actual data
> usually producing errors that result in the \? listings and then a seq
> fault
There have been some reports that COPY in/out is not careful enough
about quoting control characters and so forth, so if you have text
fields containing control characters you might run into a problem
like the above.
As a quick workaround, try the pg_dump switch to dump data as INSERT
statements instead of with COPY. It'll be a lot slower to load :(
but if it avoids the problem then this is probably the correct
diagnosis.
If you can track down exactly what data is making COPY misbehave,
we'd have a better shot at fixing the bug.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] pg_dumpall + psql -e template1
@ 1999-09-28 08:55 Sebestyen Zoltan <szoli@netvisor.hu>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Sebestyen Zoltan @ 1999-09-28 08:55 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
A question: does pg_dumpall save all the information of the database - I
think of grant rights, etc - or shall I restore them manually?
--------------------------------------------------------------------------------
Sebestyén Zoltán <szoli@netvisor.hu> I'm believing that the Holy Spirit is
gonna allow the hand, and the foot, and
MAKE INSTALL NOT WAR the mouth, just to begin to speak, and
to minister, and to heal coordinated by
the head.
I use UNIX because reboots are for hardware upgrades.
Kick me! Whip me!! Make me develop on AIX!!!
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [SQL] pg_dumpall + psql -e template1
@ 1999-09-28 12:55 Bruce Momjian <maillist@candle.pha.pa.us>
parent: Sebestyen Zoltan <szoli@netvisor.hu>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 1999-09-28 12:55 UTC (permalink / raw)
To: Sebestyen Zoltan <szoli@netvisor.hu>; +Cc: pgsql-sql
[Charset iso-8859-2 unsupported, filtering to ASCII...]
> A question: does pg_dumpall save all the information of the database - I
> think of grant rights, etc - or shall I restore them manually?
Saves them by running pg_dump. In 6.5.*, no -z is needed. In earlier
releases, you needed add -z option to save grants.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-09-28 12:55 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-24 21:47 pg_dumpall + psql -e template1 Clayton Cottingham <drfrog@smartt.com>
1999-09-24 22:42 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-09-28 08:55 ` Sebestyen Zoltan <szoli@netvisor.hu>
1999-09-28 12:55 ` Bruce Momjian <maillist@candle.pha.pa.us>
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