Re: Postgresql python in upgraded version 16.2

Hello, I get the install packages from this repository: https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8.9-ppc64le/ Michal Od: Adrian Klaver Odesláno: čtvrtek 20. června 2024 17:03 Komu: Šika Michal ; pgsql-gene...@postgresql.org Předmět: Re

Postgresql python in upgraded version 16.2

5.0 20210514 (Red Hat 8.5.0-20)] (1 row) database=# It seems python was not upgraded when I upgrade PostgreSQL. Is possible upgrade the python to actual version 3.9.x installed on RedHat 8.5 ? Thanks Michal TLP:AMBER

Re: Upgrading from 9.2.15 to 9.4.20

Is anywhere where IP adress of the server must be set? Because im doing upgrade on test and this is copy of the VM of production (upgrading Jira PostgreSQL)...Checks when Postgres 9.2.15 running gives me ok when i stop both instances and try to upgrade i have error what i writed. Can you be pleas

Upgrading from 9.2.15 to 9.4.20

Im trying to upgrade PostgreSQL from 9.2.15 to 9.4.20 with this : /usr/pgsql-9.4/bin/pg_upgrade --old-bindir=/usr/bin --new-bindir=/usr/pgsql-9.4/bin --old-datadir=/var/lib/pgsql/ data --new-datadir=/var/lib/pgsql/9.4/data Can anybody help me with this? I also try -p port parameter not helped. B

Deadlock while doing VACUUM and DROP

t be canceled due to collision with autovaccum? Regards, Michal Merta

Re: Immutable function WAY slower than Stable function?

On 2018.08.07 18:10, Tom Lane wrote: I've had a to-do item to rewrite and improve the SQL function cache mechanism for a long time, but I hadn't thought it was high priority. Maybe it should be. In the meantime, I think you could dodge the issue by converting either level of function into plpgsq