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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general