Re: 2 master 3 standby replication

Hi, Please help me with the query I raised. Regards. On Fri, 23 Jun 2023, 00:12 Atul Kumar, wrote: > 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 kn

Re: 2 master 3 standby replication

Hi pá 23. 6. 2023 v 10:37 odesílatel Atul Kumar napsal: > Hi, > > Please help me with the query I raised. > > Currently there is not any community based multi master solution. Regards Pavel Stehule > > Regards. > > On Fri, 23 Jun 2023, 00:12 Atul Kumar, wrote: > >> Hi, >> >> Do we have any

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

On Fri, Jun 23, 2023 at 11:27 AM Abhishek Dasgupta < abhishekdasgupta...@gmail.com> wrote: > Hey Michael, > Thanks for the reply. > > This error is specific to the Postgres JDBC driver, which relies on >> its own application layer for FIPS and SCRAM because it speaks >> directly the protocol and b

synchronous_commit= remote_apply | "The transaction has already committed locally..."

Hi Team, *Context: *We have faced a network isolation and ended-up with locally committed data on the old primary database server as one of the tools that is in-place for HA decided to promote one of the SYNC standby servers. As the PostgreSQL won't provide a HA solution as in-built, I would like

Re: synchronous_commit= remote_apply | "The transaction has already committed locally..."

On Fri, 2023-06-23 at 15:05 +0530, Postgres all-rounder wrote: > Context: We have faced a network isolation and ended-up with locally > committed data on the > old primary database server as one of the tools that is in-place for HA > decided to promote > one of the SYNC standby servers. As the P

Re: synchronous_commit= remote_apply | "The transaction has already committed locally..."

Hi Laurenz, Thank you for the quick response. Could you please point me to the link where the "two-phase commit" approach is being discussed. I can track it for my reference. On Fri, Jun 23, 2023 at 3:26 PM Laurenz Albe wrote: > On Fri, 2023-06-23 at 15:05 +0530, Postgres all-rounder wrote: >

Re: ECPG Semantic Analysis

Michael Paquier writes: > 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

Fwd: Migration database from mysql to postgress

Hello Necesito mover algunas bases de datos de un servidor MySQL a Postgresql. Can anyone tell me the migration procedure, tools and recommendations? Gracias El vie, 23 jun 2023 a las 11:30, Alfredo Alcala () escribió: > Hola > > Necesito mover algunas bases de datos de un servidor MySQL a Po

move databases from a MySQL server to Postgresql.

Hello I need to move some databases from a MySQL server to Postgresql. Can someone tell me the migration procedure, tools and recommendations? Thanks

Re: synchronous_commit= remote_apply | "The transaction has already committed locally..."

On Fri, 2023-06-23 at 16:23 +0530, Postgres all-rounder wrote: > Could you please point me to the link where the "two-phase commit" approach > is being discussed. > I can track it for my reference. I looked, and didn't find it. I must have mis-remembered. There is this proposal: https://www.pos

Re: move databases from a MySQL server to Postgresql.

On 6/23/23 13:45, Alfredo Alcala wrote: > Hello > > I need to move some databases from a MySQL server to Postgresql. > > Can someone tell me the migration procedure, tools and recommendations? > I'm not an expect on this, but migrations tend to be somewhat application-specific. I'd suggest you

plan using BTree VS GIN

Hello, we faced an issue with a select query on a relatively large table on our database. The query involves one single table. The table has more than 10 million records. It's mainly composed of varchar fields, have a primary key (id) of type serial, and when records of this table are shown to u

Re: plan using BTree VS GIN

On Fri, 2023-06-23 at 12:08 +, Nicolas Seinlet wrote: > we faced an issue with a select query on a relatively large table on our > database. > The query involves one single table. The table has more than 10 million > records. > It's mainly composed of varchar fields, have a primary key (id) o

Language Pack missing from StackBuilder (EDB Windows download)

While installing a fresh copy of PostgreSQL 15.3 downloaded from EDB's website, I have discovered that the Language Pack usually present in StackBuilder is missing. Anyone here from EDB who might know if this is a temporary or a permanent change? I will try emailing EDB separately, but thought I

Re: foreign keys on multiple parent table

Thank you Les for the link, it's a very good example, unfortunately my need is more applicative (we need to store user of application, not the on pg, proces who start etc), but for sure I can take advantage of it. Il giorno mar 20 giu 2023 alle ore 23:01 Les ha scritto: > . >> > > >> From progra

Re: foreign keys on multiple parent table

ehm.. I'm not sure I understood correctly :-D in which way do you generate column? Il giorno mer 21 giu 2023 alle ore 09:47 Dominique Devienne < ddevie...@gmail.com> ha scritto: > On Tue, Jun 20, 2023 at 10:47 PM Lorusso Domenico > wrote: > >> Could work, but is there a way to set a reference ke

Why can't lseek the STDIN_FILENO?

Hi community, I am testing the lseek & write & read, and I write the code like this: /*     lseek_test.c    Test the lseek     Wen Yi */ #include

Re: Why can't lseek the STDIN_FILENO?

"=?gb18030?B?V2VuIFlp?=" <896634...@qq.com> writes: >     lseek(STDIN_FILENO, 0, SEEK_SET); If you are not checking for failure return from a system call, you are in a state of sin. > I really don't know, why the buffer's content not be "Hello world\n"? Probably because a tty input device is not

Re: Why can't lseek the STDIN_FILENO?

My best advice would be to ask a C language question on a C language forum. This forum is really only for questions about the SQL language for the PostgreSQL database. I.e. no MariaDB, MySQL, MS SQL questions. First, you didn't say what OS and she'll you're using. I an guessing BASH and Linux. Se