RE: pg_dump not working
От | Chris Knight |
---|---|
Тема | RE: pg_dump not working |
Дата | |
Msg-id | 000f01bffacc$1c40e2b0$020aa8c0@aims.private обсуждение исходный текст |
Ответ на | Re: pg_dump not working (Philip Warner <pjw@rhyme.com.au>) |
Список | pgsql-general |
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 |/ >
В списке pgsql-general по дате отправления: