I'm encountering an issue while migrating a large amount of Oracle data to PostgreSQL using an ETL tool. The problem is that the pg_wal directory in PostgreSQL becomes full. I'm looking for solutions to resolve this issue. How can I address this problem and prevent the pg_wal directory from becoming full during the data migration process? Any help would be appreciated.
For the data migration, the following PostgreSQL parameters have been configured :
PostgreSQL 14.2
archive_mode = off
min_wal_size = 5 GB
max_wal_size = 20 GB
wal_keep_size = 10 GB
work_mem = 50MB
checkpoint_completion_target = 0.9