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 <[email protected]> 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. -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
