Known Issues

These are the currently known issues and limitations identified in the WarehousePG Copy release. Where applicable, we have included workarounds to help you mitigate the impact of these issues. These issues are actively tracked and are planned for resolution in a future release.

• Support for password authentication: whpg-copy currently only supports password authentication through a password file. Use .pgpass or the PGPASSFILE environment variable to set a password for the connection. If you specify a password with the whpg-copy command or in the TOML-based configuration file, it will be ignored.
• Views and materialized views: whpg-copy supports the creation of both regular views and materialized views on the destination cluster. However, it does not perform a refresh of materialized views after the copy operation. You must manually execute REFRESH MATERIALIZED VIEW on the destination if you need the data to be up-to-date.
• Version compatibility: Migration is supported between clusters of the same version or when upgrading from WarehousePG 6.x to WarehousePG 7.x. However, downward migration from version 7.x to 6.x is not supported.