Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?

2008-01-03 Thread Fernando Hevia
> Tom Lane wrote: > > "Scott Marlowe" <[EMAIL PROTECTED]> writes: > > That doesn't get me what I need. It lets me change the alias of > > timezones, but not the start and stop of daylight savings time. I > > think for that I'd have to edit / replace the files in > > postgresql-8.2.x/src/timezo

[SQL] WAL archiving blowed.

2008-01-03 Thread Gerardo Herzig
Hi all. Im trying to set a Standby server for HA. I have set the program to copy the WAL files to the standby server, but because im so stupid, for some stupid reason i delete those files from the standby server, and now, when i set the recovery_command at the standby server, it tells me that "

Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?

2008-01-03 Thread Fernando Hevia
> Tom Lane [mailto:[EMAIL PROTECTED] wrote: > > Since the OP has apparently already managed to get updated tzdata files > installed on his system, he could just copy them into > /usr/share/postgresql/timezone --- anything using zic should be a > compatible file format. > > The lack-of-ARST-on

Re: [SQL] Argentinian timezone change at the last moment. How to change pgsql tz db?

2008-01-03 Thread Tom Lane
"Fernando Hevia" <[EMAIL PROTECTED]> writes: > With 8.2.x the ARST abbreviation was recognized after including the > following line in /usr/share/postgresql/8.2/timezonesets/Default > ARST -14400 D # Argentina Summer Time Um ... is that really offsetting in the correct direction? What I put i