StarQuest Technical Documents

SQDR: Postgres Tips

Last Update: 05 January 2021
Product: SQDR & SQDR Plus
Version: 4.50 and later
Article ID: SQV00PL053

Abstract

This technical document contains tips and troubleshooting hints when using SQDR for replication to Postgres.

Contents:

Memory exhaustion on Postgres destination

Symptom:
While performing baselines of large tables to an EDB Advanced Postgres destination, the RAM usage of the postgres process on the destination system continued increasing until it reached a limit and the process aborted.

Solution:
It was discovered that auditing was enabled. Disable auditing by setting edb_audit = 'none' in the postgresql.conf file. This option is available only in EDB Postgres versions.

 

 



DISCLAIMER

The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.