RE: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Ian Dauncey
/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 s390x [installed] postgresql-12/focal 12.2-4 s390x Regards Ian From: Ray O'Donnell Sent: Wednesday, 15 June 2022 10:12 To: Ian Dauncey ; pgsql-general@lists.postgresql.org Subject: Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390 Ext

PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Ian Dauncey
Morning all Currently we are running PostgreSQL 12.2 on Ubuntu 20.04.1 LTS (Kernel: Linux 5.4.0-42-generic - Architecture: s390x). We are looking at upgrading to a later version of PostgreSQL My question is :- What is the latest available version of PostgreSQL that will run on the above Archit

Postgres query

2022-03-11 Thread Ian Dauncey
Hi All Can anyone assist in shedding some light here. We getting this query popping up in our postgresql log file at the same time as the connections to the databases starts increasing. Not sure what is initiating this query, but we get around a hundred per second until we restart our applicati

RE: vacuum full

2021-09-05 Thread Ian Dauncey
Morning. Thanks for all the replies. What I did to remove these files was to backup of the DB, drop the DB and then I restored the DB. Regards Ian From: Vijaykumar Jain Sent: Monday, 30 August 2021 20:06 To: pgsql-general Subject: Re: vacuum full External email - treat with caution On Mon,

FW: vacuumlo

2021-08-30 Thread Ian Dauncey
Hi Reposting my query here Regards Ian From: Ian Dauncey Sent: Monday, 30 August 2021 17:09 To: pgsql-ad...@lists.postgresql.org Subject: RE: vacuumlo External email - treat with caution Hi, Just an update on my vacuumlo issue. I did run the vacuumlo against the pg_largeobject table