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?
On Sun, Jan 16, 2011 at 11:06 AM, Denish Patel <denish(at)omniti(dot)com> wrote:
> 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';
> ALTER USER postgres SET TIMEZONE TO 'UTC';
> Hope , it will help.
In response to
pgsql-bugs by date
|Next:||From: Daniel Popowich||Date: 2011-01-18 16:30:04|
|Subject: BUG #5842: Memory leak in PL/Python when taking slices of results|
|Previous:||From: Dave Page||Date: 2011-01-18 15:11:06|
|Subject: Re: BUG #5791: Tables are not viewing through pgadmin|