Re: ECPG Semantic Analysis

2023-06-22 Thread Michael Paquier
On Fri, Jun 23, 2023 at 12:21:48AM -0400, Juan Rodrigo Alejandro Burgos Mella wrote: > I have a modified version of ECPG, to which I gave the ability to do > semantic analysis of SQL statements. Where can you share it or with whom > can I discuss it? I cannot say what kind of problem this solves

ECPG Semantic Analysis

2023-06-22 Thread Juan Rodrigo Alejandro Burgos Mella
Hi I have a modified version of ECPG, to which I gave the ability to do semantic analysis of SQL statements. Where can you share it or with whom can I discuss it? Atte. JRBM

Re: FIPS-related Error: Password Must Be at Least 112 Bits on Postgres 14, Unlike in Postgres 11

2023-06-22 Thread Michael Paquier
On Thu, Jun 22, 2023 at 07:16:21PM +0530, Abhishek Dasgupta wrote: > I am puzzled as to why this error occurs only with PostgreSQL 14 and not > with PostgreSQL 11. This error is specific to the Postgres JDBC driver, which relies on its own application layer for FIPS and SCRAM because it speaks

2 master 3 standby replication

2023-06-22 Thread Atul Kumar
Hi, Do we have any solution to Configure an architecture of replication having 2 master nodes and 3 standby nodes replicating the data from any of the 2 master ? Please let me know if you have any link/ dedicated document. Regards, Atul

Re: a really dumb password question

2023-06-22 Thread Ron
On 6/22/23 10:05, Martin Mueller wrote: I have a very stupid password question. I don’t know whether a postgres database on my Mac has a pass word or not. I access the database via the Aqua Data Studio frontend as the user postgres. I don’t think I ever added a password, and on the

Re: a really dumb password question

2023-06-22 Thread Adrian Klaver
On 6/22/23 08:05, Martin Mueller wrote: I have a very stupid password question. I don’t know whether a postgres database on my Mac has a pass word or not. I access the database via the Aqua Data Studio frontend as the user postgres. I don’t think I ever added a password, and on the

Re: Native Logical Replication Initial Import Qs

2023-06-22 Thread Don Seiler
On Wed, Jun 7, 2023 at 4:30 PM Jeremy Schneider wrote: > On 6/7/23 2:12 PM, Don Seiler wrote: > > On the logical replication front, the concern is with the initial data > > import that happens when the subscription is created (by default). I > > know that you can tell the subscription to not

a really dumb password question

2023-06-22 Thread Martin Mueller
I have a very stupid password question. I don’t know whether a postgres database on my Mac has a pass word or not. I access the database via the Aqua Data Studio frontend as the user postgres. I don’t think I ever added a password, and on the authentication panel the password box is empty but

FIPS-related Error: Password Must Be at Least 112 Bits on Postgres 14, Unlike in Postgres 11

2023-06-22 Thread Abhishek Dasgupta
Hey PostgreSQL experts, I have encountered an issue related to FIPS mode while setting up two different configurations. The first configuration consists of PostgreSQL 11 with MD5 password encryption and FIPS mode enabled. The second configuration involves PostgreSQL 14 with scram-sha-256 password

Re: Catalog for LISTEN'ed to notification channels?

2023-06-22 Thread Dominique Devienne
On Thu, Jun 22, 2023 at 3:30 PM Tom Lane wrote: > Dominique Devienne writes: > > Can I introspect which "channel(s)" the current (or any other session) is > > LISTEN'ing to? > > The pg_listening_channels() function will show you channel names the > current session is listening to. There's no

Re: Catalog for LISTEN'ed to notification channels?

2023-06-22 Thread Tom Lane
Dominique Devienne writes: > Can I introspect which "channel(s)" the current (or any other session) is > LISTEN'ing to? The pg_listening_channels() function will show you channel names the current session is listening to. There's no way to find out about other sessions, because that state is

postgresql 16beta1-alpine3.18 : build plugin , VARSIZE_ANY_EXHDR: symbol not found

2023-06-22 Thread xxai.art
this is my dockerfile https://github.com/wactax/ops.docker/blob/main/Dockerfile/postgres/Dockerfile I build some simple plugin for postgresql when I FROM postgres:15-alpine AS pg , everything is ok when I use FROM postgres:16beta1-alpine3.18 AS pg and CREATE EXTENSION IF NOT EXISTS md5hash;

Catalog for LISTEN'ed to notification channels?

2023-06-22 Thread Dominique Devienne
Hi, I've looked in the Catalogs, the doc for LISTEN, NOTIFY, even [LibPQ Async Notif][1], and I don't see anything about that. Can I introspect which "channel(s)" the current (or any other session) is LISTEN'ing to? Any way to see pending notification(s) in that 8GB queue, from client apps?