From: | "Edwin Quijada" <listas_quijada(at)hotmail(dot)com> |
---|---|
To: | alvherre(at)dcc(dot)uchile(dot)cl |
Cc: | pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx |
Subject: | Re: [Pgsql-ayuda] Pg_dumpall problemas |
Date: | 2003-11-04 19:48:51 |
Message-ID: | BAY1-F13mSknvh7wFI100005399@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Alvaro esa vaina funciono mas bien que el diablo!!!!
Ahora si me vas a tener que decir que significaba eso??
>From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
>To: Edwin Quijada <listas_quijada(at)hotmail(dot)com>
>CC: pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
>Subject: Re: [Pgsql-ayuda] Pg_dumpall problemas
>Date: Tue, 4 Nov 2003 11:51:19 -0300
>
>On Tue, Nov 04, 2003 at 01:55:53PM +0000, Edwin Quijada wrote:
>
> > 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');
>
>Ugh...
>
>Prueba ejecutando como superusuario
>
>UPDATE pg_shadow SET valuntil=NULL where valuntil='invalid';
>
>--
>Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
>"Siempre hay que alimentar a los dioses, aunque la tierra esté seca"
>(Orual)
>_______________________________________________
>Pgsql-ayuda mailing list
>Pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx
>http://tlali.iztacala.unam.mx/mailman/listinfo/pgsql-ayuda
_________________________________________________________________
¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
From | Date | Subject | |
---|---|---|---|
Next Message | MARICELA RODRIGUEZ | 2003-11-04 20:32:06 | Re: [Pgsql-ayuda] Orden de Datos |
Previous Message | Edwin Quijada | 2003-11-04 19:40:24 | Re: [Pgsql-ayuda] Pg_dumpall problemas |