Thread: Problem with Pg_dumpall

Hi!
I am trying to do a dump all and when I do this I get this error

pg_dumpall: query failed: ERROR:  Unable to convert abstime 'invalid' to
timestamp
pg_dumpall: query was: SELECT usename, usesysid, passwd, usecreatedb,
usesuper, CAST(valuntil AS timestamp) FROM pg_shadow WHERE usesysid <>
(SELECT datdba FROM pg_database WHERE datname = 'template0');

What is my problem???

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/

"Edwin Quijada" <listas_quijada@hotmail.com> writes:
> I am trying to do a dump all and when I do this I get this error

> pg_dumpall: query failed: ERROR:  Unable to convert abstime 'invalid' to
> timestamp

IIRC it is possible to get this error in some upgrade scenarios if you
have pg_shadow rows whose "valuntil" field is "invalid".  Set those
entries to something else (NULL, perhaps) and you should be okay.

            regards, tom lane