Thanks, that is helpful. There was a separate reason it didn't appear
to be happening before the 8.4 upgrade.
I couldn't find this mentioned in the documentation anywhere. Should
it be included in the pg_restore section?
-Anthony
On Sun, Jan 16, 2011 at 11:06 AM, Denish Patel <denish(at)omniti(dot)com> wrote:
> Anthony,
> As per my knowledge, this can't work on pg84 dump/restore too. You should
> match timezone on restoring database with the dump database to load it
> successfully. You can set at user level or database level.
> On restoring database:
> ALTER DATABASE test_db_2 SET TIMEZONE TO 'UTC';
> OR
> ALTER USER postgres SET TIMEZONE TO 'UTC';
> Hope , it will help.