pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_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