Re: Different releases in the same server

2023-08-02 Thread Ron
When I want to run a specific version of psql, pg_dump. pg_basebackup, etc I explicitly use fully-qualified file names. Environment variables make that easy.  Ditto with having a different port number for each instance. (And even though it's too late for you regarding that, I *always* install

Re: Different releases in the same server

2023-08-02 Thread marco . ptz
Hi Christoph, thank you very much for your time. We know the 2 releases are old, unfortunately we cannot change requirement, we got this server under our management 3 weeks ago, and customer asked to upgrade urgently to 12. It's a governement agency, and the limit is due to certification matr

Re: Different releases in the same server

2023-08-02 Thread Christoph Moench-Tegeder
## marco@tiscali.it (marco@tiscali.it): > we have recently started to manage a production server > running a 9.6 postgres. Which is EOL for nearly two years now: https://www.postgresql.org/support/versioning/ > We > have to upgrade to postgres 12.x Which is going EOL in little over one

Different releases in the same server

2023-08-02 Thread marco . ptz
Hi all, we have recently started to manage a production server running a 9.6 postgres. [root@xx ~]# cat /etc/os-release NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7

Re: Sample pg_hba.conf allows local users to access all databases

2023-08-02 Thread William Edwards
Hi David, David G. Johnston schreef op 2023-08-01 19:35: On Tue, Aug 1, 2023 at 10:13 AM William Edwards wrote: This allows all local users connecting over TCP to access all databases, not only the databases that the user is a member of as one might expect. Proof that user is able to access