Re: RHEL repo package crc mismatches

2023-05-03 Thread Brainmue
Hello Evan, we have exactly the same problem and don't feel comfortable with it at the moment either. We even synchronise several versions and this problem occurs with all of them. Can anyone confirm that the packages have not been changed inadvertently but only the metadata is wrong? Here are t

Re: RHEL repo package crc mismatches

2023-05-03 Thread Brainmue
> On Wed, May 3, 2023 at 07:33:02AM +, Brainmue wrote: > >> Hello Evan, >> >> we have exactly the same problem and don't feel comfortable with it at the >> moment either. >> We even synchronise several versions and this problem occurs with all of &g

Re: RHEL repo package crc mismatches

2023-05-03 Thread Brainmue
Hello Devrim, The problem is fixed in most of the repositories I synchronise, but in one I now have a new one. With the package: postgresql13-odbc-13.00.-1PGDG.rhel7.x86_64.rpm For the pgdg13 RHEL 7 repository: [MIRROR] postgresql13-odbc-13.00.-1PGDG.rhel7.x86_64.rpm: Downloading succ

Re: RHEL repo package crc mismatches

2023-05-04 Thread Brainmue
Hello Devrim, You were absolutely right. Resynchronising solved the problem. Now everything is OK again. Thanks for the quick help. Greetings Michael 4. Mai 2023 20:43, "Devrim Gündüz" schrieb: > Hi Michael, > > On Thu, 2023-05-04 at 04:46 +, Brainmue wrote: &

Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
Hello all, I am currently looking for a solution similar to Oracle Listener. Current situation: I have a system with multiple PostgreSQL clusters for different databases. Each cluster is running on the same physical machine and is accessed through its own DNS alias and corresponding port. I onl

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 12:04, "Thomas Markus" schrieb: > Hi > > Am 16.06.23 um 11:40 schrieb Brainmue: > >> Hello all, >> >> I am currently looking for a solution similar to Oracle Listener. >> >> Current situation: >> I have a system with mul

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 14:13, "Laurenz Albe" schrieb: > On Fri, 2023-06-16 at 09:40 +0000, Brainmue wrote: > >> I am currently looking for a solution similar to Oracle Listener. > > Can you explain why? Perhaps there exists a good solution for the > underlying prob

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 14:50, "Laurenz Albe" schrieb: > On Fri, 2023-06-16 at 12:35 +0000, Brainmue wrote: > >> We want to minimise dependencies between the application and the associated >> PostgreSQL DB. >> The idea is that the application gets its DB alias and thi

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 17:18, "Laurenz Albe" schrieb: > On Fri, 2023-06-16 at 14:49 +0000, Brainmue wrote: > >> 16. Juni 2023 14:50, "Laurenz Albe" schrieb: >> >> On Fri, 2023-06-16 at 12:35 +, Brainmue wrote: >> >>> We want to minim

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 17:41, "Ron" schrieb: > On 6/16/23 10:18, Laurenz Albe wrote: > >> On Fri, 2023-06-16 at 14:49 +, Brainmue wrote: > > 16. Juni 2023 14:50, "Laurenz Albe" schrieb: >> On Fri, 2023-06-16 at 12:35 +, Brainmue wrote: >>

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 17:59, "Ron" schrieb: > On 6/16/23 10:54, Brainmue wrote: > >> 16. Juni 2023 17:41, "Ron" schrieb: > > On 6/16/23 10:18, Laurenz Albe wrote: >> On Fri, 2023-06-16 at 14:49 +, Brainmue wrote: > > 16. Juni 2023 14:50, "

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 18:19, "Jeff Ross" schrieb: >> We have already looked at pgbouncer and it works with that but unfortunately >> you have to do the >> authentication in pgbouncer. Which we don't like so much. >> Regards, >> Michael > You can set up pgbouncer to authenticate in postgres: > > https:/

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 18:56, "Ron" schrieb: > On 6/16/23 11:05, Brainmue wrote: > >> 16. Juni 2023 17:59, "Ron" schrieb: > > [snip] > >> There's always The Cloud... spinning up a new AWS RDS Postgresql is fast and >> simple. (Costly, >

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-16 Thread Brainmue
16. Juni 2023 21:54, "Francisco Olarte" schrieb: > Michael: > > On Fri, 16. Juni 2023 at 13:53, brainmue wrote: > >> Because with iptables or netfilter I can't forward TCP packets based on the >> DNS alias name. Or is >> that possible? > >

Re: Question: Multiple pg clusters on one server can be reached with the standard port.

2023-06-19 Thread Brainmue
19. Juni 2023 13:17, "Dominique Devienne" schrieb: > On Mon, Jun 19, 2023 at 1:01 PM Thomas Markus wrote: > >> Am 19.06.23 um 12:33 schrieb Peter J. Holzer: >>> As Francisco already pointed out, this can't work with nginx either. >> anyway, fw or nginx cant look into tcp streams > Traefik can p