Re: [GENERAL] recovery dump on database with different timezone - Mailing list 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.klaver@aklaver.com