| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Henrik Farre <look(at)my(dot)signature(dot)txt> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dumpall dies |
| Date: | 2004-02-21 04:55:33 |
| Message-ID: | 9238.1077339333@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Henrik Farre <look(at)my(dot)signature(dot)txt> writes:
> I just been choosen as sys adm on a small network. We have a old Sun Ultra
> 1 running postgresql 7.1.3. I would like to migrate the database to a new
> machine and a newer version of postgresql. But when I run the pg_dumpall
> command I get the followering error, after a while:
> WARNING: owner of type 'counter' appears to be invalid
> dumpRules(): SELECT failed for rules associated with table "counter".
> Explanation from backend: 'pqReadData() -- backend closed the channel unexpectedly.
It sounds like you have a badly corrupted database :-(. However, the
pg_dump message is of little help in delving further than that. What
shows up in the postmaster log? If the backend is dumping core, can
you get a stack trace?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | V i s h a l Kashyap @ [Sai Hertz And Control Systems] | 2004-02-21 06:56:47 | Re: embeding postgre |
| Previous Message | Christopher Browne | 2004-02-21 02:15:43 | Re: embeding postgre |