Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"

From: liam saffioti <liam(dot)saffiotti(at)gmail(dot)com>
To: "Yoong S(dot) Chow" <chowy1026(at)gmail(dot)com>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Date: 2022-02-20 11:49:09
Message-ID: CAGHjuab=qHi_dOk7N9OcOtARAXgU6gdD26ng+SoVgXMA7Wk+RA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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 <chowy1026(at)gmail(dot)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(dot)janes(at)gmail(dot)com> wrote:
>
>>
>>
>> On Fri, Feb 18, 2022 at 8:35 AM Yoong S. Chow <chowy1026(at)gmail(dot)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
>>
>>>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message liam saffioti 2022-02-20 11:52:08 Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Previous Message Yoong S. Chow 2022-02-19 06:54:41 Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"

Browse pgsql-general by date

  From Date Subject
Next Message liam saffioti 2022-02-20 11:52:08 Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Previous Message Markur Sens 2022-02-20 11:26:15 Re: Additional accessors via the Extension API ?