Can one user login in multile machine?

2023-05-02 Thread Wen Yi
Hi team, can I use same user's information login in multile machines when connect to the postgres? Thanks in advance! Yours, Wen Yi.

RHEL repo package crc mismatches

2023-05-02 Thread Evan Rempel
At our site we use reposync to copy the postgresql repositories to a local repository. When doing this on April 28 (and since) I exprience the following package checksum matching errors. For the pgdg13 RHEL 8 repository [MIRROR] pg_auto_failover_13-1.6.3-1.rhel8.x86_64.rpm: Downloading succ

Re: Regarding SSL Enablement in PostgreSQL Database on different port

2023-05-02 Thread Christophe Pettus
> On May 2, 2023, at 12:15, Tomas Pospisek wrote: > > Oh, I think your idea to use pgbouncer to take care of the SSL termination is > elegant. I don't think me I'd characterize it as a hack if properly set up. > Why do you consider it a hack? It's really only a hack in the sense that pgboun

Re: Regarding SSL Enablement in PostgreSQL Database on different port

2023-05-02 Thread Rob Sargent
On 5/2/23 13:15, Tomas Pospisek wrote: Oh, I think your idea to use pgbouncer to take care of the SSL termination is elegant. I don't think me I'd characterize it as a hack if properly set up. Why do you consider it a hack? *t Let me guess:  postgres IS NOT listening on the other port, pgb

Re: Regarding SSL Enablement in PostgreSQL Database on different port

2023-05-02 Thread Tomas Pospisek
On 02.05.23 12:13, Magnus Hagander wrote: On Tue, May 2, 2023 at 11:43 AM sujay kadam wrote: Hi PostgreSQL Team, I want to enable SSL in PostgreSQL Database on a new port. I don’t want the default port that is 5432 SSL enabled, but I want to configure another port to enable SSL on it. As

Re: libpq and multi-threading

2023-05-02 Thread Peter J. Holzer
On 2023-05-02 17:43:06 +0200, Michael J. Baars wrote: > I don't think it is, but let me shed some more light on it. One possibly quite important information you haven't told us yet is which OS you use. Or how you create the threads, how you pass the results around, what else you are possibly doin

Re: libpq and multi-threading

2023-05-02 Thread Michael J. Baars
Hi David, My mistake. Too much fiddling around, but better than no fiddling around. It appears both sides make mistakes, or does your freely passing around work better than mine? On Tue, 2 May 2023, 17:57 David G. Johnston, wrote: > On Tue, May 2, 2023 at 2:38 AM Michael J. Baars < > mjbaars197

Re: libpq and multi-threading

2023-05-02 Thread David G. Johnston
On Tue, May 2, 2023 at 2:38 AM Michael J. Baars < mjbaars1977.pgsql.hack...@gmail.com> wrote: > I have already tried to set the PostgreSQL 'dynamic_shared_memory_type' > configuration option to 'mmap', but this does not help. > > Of course it doesn't, that is a server-side configuration. "Specifi

Re: libpq and multi-threading

2023-05-02 Thread Michael J. Baars
Hello Laurenz, I don't think it is, but let me shed some more light on it. After playing around a little with threads and memory, I now know that the PGresult is not read-only, it is read-once. The child can only read that portion of parent memory, that was written before the thread started. Read

Re: libpq and multi-threading

2023-05-02 Thread Laurenz Albe
On Tue, 2023-05-02 at 11:38 +0200, Michael J. Baars wrote: > I have a question about libpq and multi-threading. > > In the PostgreSQL documentation > (https://www.postgresql.org/docs/15/libpq-threading.html) > it says that results can be passed around freely between threads. However, > when I tr

Re: postgresql15-contrib installation on Amazon Linux 2 fails on Python shared lib dependency

2023-05-02 Thread Magnus Hagander
On Thu, Apr 27, 2023 at 8:51 AM Max Kremer wrote: > > > > I'm using an EC2 on AWS running Amazon Linux 2. I'm trying to install > Postgresql version 15 server along with the contrib libraries for various > extension. > > This is how I installed Posgres15 > > sudo rpm --import https://yum.postgres

Re: Regarding SSL Enablement in PostgreSQL Database on different port

2023-05-02 Thread Magnus Hagander
On Tue, May 2, 2023 at 11:43 AM sujay kadam wrote: > > Hi PostgreSQL Team, > > > I want to enable SSL in PostgreSQL Database on a new port. > > I don’t want the default port that is 5432 SSL enabled, but I want to > configure another port to enable SSL on it. > > As per my requirement, I cannot u

Regarding SSL Enablement in PostgreSQL Database on different port

2023-05-02 Thread sujay kadam
Hi PostgreSQL Team, I want to enable SSL in PostgreSQL Database on a new port. I don’t want the default port that is 5432 SSL enabled, but I want to configure another port to enable SSL on it. As per my requirement, I cannot use the same port for normal connection and SSL connection. Hence, we

libpq and multi-threading

2023-05-02 Thread Michael J. Baars
Hi All, I have a question about libpq and multi-threading. In the PostgreSQL documentation ( https://www.postgresql.org/docs/15/libpq-threading.html) it says that results can be passed around freely between threads. However, when I try to read the result from the parent thread, the program crashe

Re: Compiling postgres for windows with src/tools/msvc.build.bat

2023-05-02 Thread Magnus Hagander
On Tue, May 2, 2023 at 12:47 AM Celso Lorenzetti wrote: > Hi, how do I set --prefix when compiling postgres for windows using > /src/tools/msvc/build.bat? > > > > I created the /src/tools/msvc/config.pl file with $config->{prefix} = > 'MyPostgreSQL'; > > > > But the .exe and .dll are generated in