Re: date/time compatible problems in 7.2

Thomas Lockhart wrote:

> > I has pg_dump my DB in 7.1.3 and try ro pg_restore it in 7.2
> > version.
> > psql:/.../dbdump/.dbrestore.tmp:1624094: ERROR:  copy: line 1, Bad
> > timestamp external representation 'Fri 25 Jan 23:59:59 2002 KRAT'
> > psql:/.../dbdump/.dbrestore.tmp:1624094: lost synchronization with
> > server, resetting connection
>
> Not sure why it is crashing. But "KRAT" is a time zone not recognized
by
> the PostgreSQL date/time parser. In fact it could be afaik (it is
> mentioned but commented-out in the parser) but it either had a screwy
> definition or I couldn't figure out what the definition was. It could
be
> added for 7.2.1 (and I could send a patch beforehand) if I knew the
> proper definition. Check src/backend/utils/adt/datetime.c and look for

> "krat".
   KRAT,KRAST is timezone code generated by FreeBSD automatically.   You can check up /usr/share/zoneinfo  - it have
alltimezones.   You can see timezones KRAT,KRAST in file   /usr/share/zoneinfo/Asia/Krasnoyarsk.
 
   I already break idea to pg_dump in 7.1.3 and pg_restore in 7.2 and   tried to remove ' KRAT' substring from all my
*.datfiles, created
 
by   pg_dump and change schema to fields without timezone. After I tried   pg_restore only data from dbdump-file, but
pg_restoresays, that   can't initialize header from TOC-file, but I not even touched it.   TOC - is only one binary
filein dbdump-file. I think that it also
 
have   smth like CRC code about all other files, and this is reason why
they   say that can't initialize TOC-file?
   How to patch datetime.c to 7.2 permit my 'KRAT' timezone?


   Greatly appreciate,   Ruslan A Dautkhanov