Re: AW: ldap connection parameter lookup

On 2021-01-22 10:22, Zwettler Markus (OIZ) wrote: >> >> On Fri, 2021-01-15 at 14:09 +, Zwettler Markus (OIZ) wrote: >>> I want to use ldap to lookup the connection parameters: >>> https://www.postgresql.org/docs/12/libpq-ldap.html >>> >>> or is there also some kind of generic variant like this

Re: How to post to this mailing list from a web based interface

On 2021-02-14 22:44, Thomas Munro wrote: > On Fri, Jan 29, 2021 at 4:27 AM Alvaro Herrera > wrote: > > While catching up with some interesting new threads just now I was > quite confused by the opening sentence of this message (which also > arrived in my mailbox): > > https://www.postgresql.org

Re: How to post to this mailing list from a web based interface

On 2021-02-15 12:30, Adrian Klaver wrote: > On 2/15/21 9:24 AM, Thomas Guyot wrote: > >> The "download mbox" option doesn't work, I get asked for a user/password >> every time (I would've downloaded archives for the lats two months to >> get continuat

Re: PostgreSQL Replication

On 2021-02-16 09:28, Raul Giucich wrote: > This article will help you > https://wiki.postgresql.org/wiki/Multimaster > .  > > El mar., 16 feb. 2021 10:56, Mutuku Ndeti > escribió: > > Hi, > > Need some advice here.

Re: PostgreSQL Replication

On 2021-02-17 04:22, Mutuku Ndeti wrote: > Thank you.  > > I agree with you. Single master, with a standby replica, seems easier to > manage. Is there a way to automatically promote the standby, when the > active master fails? Is it feasible to have 2 instances of the > application, writing onto t

Re: Is Client connections via ca.crt only possible?

On 2022-08-01 04:12, Rejo Oommen wrote: Requirement is to use only ca.crt and connect to postgres Server.crt, Server.key and ca.crt are configured at the postgres server for tls connection. Connection successful while using psql ‘host=172.29.21.222 dbname=test user=postgres sslmode=verify-ca

Re: Is Client connections via ca.crt only possible?

On 2022-08-03 21:37, Rejo Oommen wrote: Thank you for the reply Thomas. I agree with you on the mutual TLS that you mentioned. Here is what I was looking at. The configurations at the server end will be with auth-method as md5 and auth-option as clientcert=verify-ca. There's your issue. I

Re: High CPU usage

On 2022-10-20 15:59, ertan.kucuko...@1nar.com.tr wrote: Hello, I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very high CPU usage on my Linux system as below PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND 2357756 postgres 20 0 2441032

Re: How do the Linux distributions create the Linux user/group "postgres"?

On 2023-01-09 07:41, Matthias Apitz wrote: Hello, Please note: I'm talking about the user and group "postgres" in the Linux OS and not in the PostgreSQL server. We're compiling PostgreSQL from source (actually 14.1) and distribute that to our customers. They're asked to setup user and group "po

Re: PostgreSQL vs MariaDB

On 2023-03-24 07:07, Inzamam Shafiq wrote: Hi Team, Hope you are doing well. Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)? Hi Inzamam, I will have my take as well

Re: Death postgres

On 2023-05-05 21:14, Marc Millas wrote: Hi, postgres 14.2 on Linux redhat temp_file_limit set around 210 GB. a select request with 2 left join have crashed the server (oom killer) after the postgres disk occupation did grow from 15TB to 16 TB. What are the cases where postgres may grow with