[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    RE: [GENERAL] pg_dump not working
From:       "Chris Knight" <chris () aims ! com ! au>
Date:       2000-07-31 8:48:33
[Download RAW message or body]

Howdy,

Doesn't matter - I did a COPY TO on all the tables, dropped and recreated
the database from my initial SQL scripts, and did a COPY FROM to restore the
data. I'm finding a heap of duplicate key errors on my unique indexes and
referential integrity violation on foreign keyed columns. Anyone know of a
quick way to get the index definitions for all tables, drop and recreate
them?

Thanks in advance for any help.

Regards,
Chris Knight
Systems Administrator
AIMS Independent Computer Professionals
Tel: +61 3 6334 6664  Fax: +61 3 6331 7032  Mob: +61 419 528 795
Web: http://www.aims.com.au



> -----Original Message-----
> From: Philip Warner [mailto:pjw@rhyme.com.au]
> Sent: Monday, 31 July 2000 17:38
> To: chris@aims.com.au; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] pg_dump not working
>
>
> At 17:00 31/07/00 +1000, Chris Knight wrote:
> >Howdy,
> >
> >I've come back from a two week holiday to find that pg_dump
> isn't working.
> >I'm running Postgresql 7.0.2 on FreeBSD 2.2.8.
> >I've stopped the postmaster, backed up the database
> directory using tar for
> >safety, and performed a successful vacuum analyze.
> >The error I'm getting is:
> >
> >PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
> >Segmentation fault (core dumped)
>
> To track this down, it might help to see the command you are
> using and the
> output using the '-v' option on pg_dump.
>
>
> ----------------------------------------------------------------
> Philip Warner                    |     __---_____
> Albatross Consulting Pty. Ltd.   |----/       -  \
> (A.C.N. 008 659 498)             |          /(@)   ______---_
> Tel: (+61) 0500 83 82 81         |                 _________  \
> Fax: (+61) 0500 83 82 82         |                 ___________ |
> Http://www.rhyme.com.au          |                /           \|
>                                  |    --________--
> PGP key available upon request,  |  /
> and from pgp5.ai.mit.edu:11371   |/
>

[prev in list] [next in list] [prev in thread] [next in thread]