Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
It seems like PG_INITIAL_COMMAND is ignored when using -t TEST_DATA to do data verification between Oracle and PostgreSQL
Added the following to ora2pg.conf:
PG_INITIAL_COMMAND set timezone to 'Europe/Oslo'
Initially the log says:
[2023-05-02 13:58:54] DEBUG: executing initial command to PostgreSQL: set timezone to 'Europe/Oslo'
But data verification fails with rows showing UTC timezone like 2020-09-18 12:17:42+00
It seems like PG_INITIAL_COMMAND is ignored when using -t TEST_DATA to do data verification between Oracle and PostgreSQL
Added the following to
ora2pg.conf
:PG_INITIAL_COMMAND set timezone to 'Europe/Oslo'
Initially the log says:
[2023-05-02 13:58:54] DEBUG: executing initial command to PostgreSQL: set timezone to 'Europe/Oslo'
But data verification fails with rows showing UTC timezone like2020-09-18 12:17:42+00