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

Поиск
Список
Период
Сортировка
От liam saffioti
Тема Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"
Дата
Msg-id CAGHjuab=qHi_dOk7N9OcOtARAXgU6gdD26ng+SoVgXMA7Wk+RA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_upgrade from Postgresql-12 to Postgresql-13 fails with "Creating dump of database schemas postgres *failure*"  ("Yoong S. Chow" <chowy1026@gmail.com>)
Список 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@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.janes@gmail.com> wrote:


On Fri, Feb 18, 2022 at 8:35 AM Yoong S. Chow <chowy1026@gmail.com> wrote:

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Markur Sens
Дата:
Сообщение: Re: Additional accessors via the Extension API ?
Следующее
От: Carsten Klein
Дата:
Сообщение: Re: Strange results when casting string to double