PostgreSQL HA

Hi Team, Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions. My Team is thinking about implementing active-active replacing master-slave. Regards, Venkat

Re: PostgreSQL HA

You can go for BDR from 2nd Quadrant. On Sat, 26 Dec 2020, 4:17 pm venkata786 k, wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing > master-slave. > > Reg

Postgres read jsonb content from stdin

Hello, I'm trying to build a few data pipelines with Unix tools but can't figure out how to insert in a slurp mode (e.g. not COPY line by line) content inside a variable. Consider the following script (using a heredoc) json_url="https://file.json"; local_file="/tmp/a.json" curl -s -m 10 -A

Re: PostgreSQL HA

Use xdb, simpler and better On Saturday, December 26, 2020, venkata786 k wrote: > Hi Team, > > Could you please share postgresql's best active(R/W)-active(R/W) (multi > master replication) solutions. > My Team is thinking about implementing active-active replacing > master-slave. > > Regards, >

Re: Postgres read jsonb content from stdin

2020年12月26日(土) 20:19 Markur Sens : > > Hello, > > I'm trying to build a few data pipelines with Unix tools but can't figure out > how to insert in a slurp mode (e.g. not COPY line by line) content inside a > variable. > > Consider the following script (using a heredoc) > > json_url="https://f

Re: Postgres read jsonb content from stdin

Hello, Hadn't really thought of using a foreign table up at this point... thanks for that. Will the first solution handle formatting issues (e.g. single quotes) gracefully? I think I'd tried it in the past and it didn't work. PD: I have such a script that handle's the intricacies but it'd still

Re: PostgreSQL HA

Hi Ganesh, BDR supports postgres 12 & 13 versions ?? I think we have BDR compatible for 9.4 postgres. Could you plz confirm. On Sat, 26 Dec 2020 at 16:22, Ganesh Korde wrote: > You can go for BDR from 2nd Quadrant. > > On Sat, 26 Dec 2020, 4:17 pm venkata786 k, wrote: > >> Hi Team, >> >> Coul

Re: PostgreSQL HA

Hi Ganesh, I saw symmetric DS in Google. Are there any disadvantages with symmetric DS? Virus-free. www.avast.com

Multi-column index vs index on individual columns

Hi, I was going through Postgres documentation on multi-column indexes and came across the recommendation at the bottom states: "Multicolumn indexes should be used sparingly. In most situations, an index on a single column is sufficient and saves space and time".  In my experience typical webapp

Re: Problem with ssl and psql in Postgresql 13

I wrote: > So this directly explains the original report: if the only applicable > pg_hba.conf entry is "hostssl", right here is where libpq will see > that error, and it will go around and fail again because the next > try uses neither GSS nor SSL. > However, in the tests Mikael ran after backing

Re: Problem with ssl and psql in Postgresql 13

Here's a draft patch for the libpq-side issues. The core of the fix is to get rid of pqsecure_open_gss's clearing of allow_ssl_try, and instead check whether GSS encryption is already enabled before we try to enable SSL. While I was at it I also fixed the places where we drop an attempted GSS con

Re: Multi-column index vs index on individual columns

In a typical web storefront or catalog app, there are a fairly small number of queries that are run often that are more complex and slower. It is perfectly appropriate to consider creating compound/partial indexes to speed up those queries. Just be aware that indexes trade off slower insert/upda

alter system command

hi, I have set archive_command like below: alter system set archive_command ='pgbackrest --stanza=main archive-push %'; then I reloaded the conf file select pg_reload_conf(); now when i checked it using the show command like it gave me correct output postgres=# show archive_command;