Postgres Pro
Downloads
Home   >   mailing lists

pg_dumpall: query failed: - Mailing list pgsql-general

From gnotari@linkgroup.it
Subject pg_dumpall: query failed:
Date
Msg-id OFD3E96C42.E3B0BBFA-ONC1256D72.002CE564@linkgroup.it
Whole thread Raw
Responses Re: pg_dumpall: query failed:  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I have this problem with a nightly script that dumps the db:

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');

Postgres version is 7.3.2.

Any hints?

ciao
Guido

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: CREATE TABLE with REFERENCE
Next
From: gnotari@linkgroup.it
Date:
Subject: Batch processing