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