Hi Liam,
Here are the answers:
- on my Postgresql-12, the default version of pgaudit is 1.4.2 but the installed version is 1.4.1. Is this causing a problem?
- for postgis: both default and installed versions are 3.2.1; so are postgis_raster.
- The postgis and postgis_raster extensions are installed in all other user databases except for postgres, postgis_raster and template1
- TIL about postgresql.auto.conf. Didn't know this file existed. Attached.
Thanks a lot for your help.
Best,
Yoong Shin
Hi Chow,
Can you answer the below questions, please?
- What is the pgaudit extension version?
- What is the PostGIS and postgis_raster extensions version?
- In which databases are PostGIS or postgis_raster extensions installed?
- Can you add postgresql.auto.conf file?
I suppose that the problem is caused by the extensions bugs.
Best,
Liam
Hi Jeff,
Could you please clarify what core files are? I am truly a newbie to postgresql.
The pg_dump on both `postgres` and `postgis_raster` databases ran without error. Attached is the posgtresql log.
Thank you,
Chow
From that last log file we have:
2022-02-16 19:04:35 +08 [303982]: [4957-1] session=620cda42.4a36e,user=postgres,db=postgis_raster,app=pg_dump,client=[local] | LOG: disconnection: session time: 0:00:01.101 user=postgres database=postgis_raster host=[local]
free(): invalid pointer
and then a little later:
2022-02-16 19:04:35 +08 [303791]: [7-1] session=620cda0f.4a2af,user=,db=,app=,client= | LOG: server process (PID 303982) was terminated by signal 6: Aborted
Do you get any core files for 303982? Do you have core dumps enabled? What do you get if you run a manual pg_dump -s on db postgis_raster?
Cheers,
Jeff