Upgrade from PostGIS 2.3 to 2.5.5 in PostgreSQL 11 error

From: <ghadeerdarwesh58(at)gmail(dot)com>
To: <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Upgrade from PostGIS 2.3 to 2.5.5 in PostgreSQL 11 error
Date: 2023-02-12 20:56:45
Message-ID: 000301d93f24$85fa3480$91ee9d80$@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear all,

I'm facing an issue while upgrading from PostGIS 2.3 to 2.5.5 in PostgreSQL
11. I used the following command to upgrade the extension:

ALTER EXTENSION postgis UPDATE;

However, after executing the command and exiting the psql terminal, the
database went down and the logs showed the following error:

The postmaster has commanded this server process to roll back the current
transaction and exit, because another server process exited abnormally and
possibly corrupted shared memory

I've tried to restore the database from a recent backup, but the issue
persists. I'm seeking help from the community to resolve this issue.

I would be grateful if someone could assist me with resolving this issue.
I'm available to provide any additional information or logs that may be
helpful.

Thank you for your time and support.

Best regards,

Ghadeer.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Wienhold 2023-02-13 01:15:28 Re: Upgrade from PostGIS 2.3 to 2.5.5 in PostgreSQL 11 error
Previous Message Jerry Sievers 2023-02-10 20:32:35 Re: UPDATE, pglogical supervisor on pg15 not taking ProcSignalBarrier