Re: recovery dump on database with different timezone

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Edmundo Robles <edmundo(at)sw-argos(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: recovery dump on database with different timezone
Date: 2017-01-24 00:59:27
Message-ID: dadf1b48-b9b8-08ef-d594-6e44d475a255@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/23/2017 04:30 PM, Edmundo Robles wrote:
>
>

>
>
> * at last, i did 'pg_restore -l backup.dmp| sed "s:+00:-06:g"|psql
>
>
> The above is not the complete command, correct?
>
> the complete command is:
> pg_restore backup.dmp| sed "s:+00:-06:g"|psql database
>

Another thought, do you have a .psqlrc file that is changing the timezone?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-01-24 01:01:38 Re: recovery dump on database with different timezone
Previous Message David G. Johnston 2017-01-24 00:58:36 Re: recovery dump on database with different timezone