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 Yoong S. Chow <chowy1...@gmail.com>, 19 Şub 2022 Cmt, 19:02 tarihinde şunu yazdı: > 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 > > > On Sat, Feb 19, 2022 at 12:07 AM Jeff Janes <jeff.ja...@gmail.com> wrote: > >> >> >> On Fri, Feb 18, 2022 at 8:35 AM Yoong S. Chow <chowy1...@gmail.com> >> wrote: >> >>> >>> Here are the logs: pg_upgrade_server.log <https://pastebin.com/ePDpmheE> >>> , pg_upgrade_dump_13427.log <https://pastebin.com/YTsU4hYh> and >>> tail_postgresql-12-2022-02-16_190344.log <https://pastebin.com/KP8ePVct> >>> . >>> >> >> From that last log file we have: >> >> >> 1. 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] >> 2. free(): invalid pointer >> >> >> and then a little later: >> >> >> 1. 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 >> >>>
