Re: postgresql11: How to use publication/subscription on primary/standby setup

2021-10-01 Thread Tomas Pospisek
On 29.09.21 11:01, Abhishek B wrote: Is there a solution to use publication/subscription on a master-slave or primary-standby postgres setup without manual intervention? Currently the DB clusters are managed by Pacemaker. Once there is a failover, the pacemaker is able to promote the secondary

Re: Sysbench tests on PG12

2021-10-01 Thread Subhrajyoti Senapati
Thanks Laurenz, will try these flags. Regards, Subhrajyoti On Fri, Oct 1, 2021 at 5:19 PM Laurenz Albe wrote: > On Fri, 2021-10-01 at 14:22 +0530, Subhrajyoti Senapati wrote: > > Was running a few sysbench tests in Postgres12. > > Sysbench Test Config > > oltp-readwrite-custom > > Threads - 500

Re: Sysbench tests on PG12

2021-10-01 Thread Laurenz Albe
On Fri, 2021-10-01 at 14:22 +0530, Subhrajyoti Senapati wrote: > Was running a few sysbench tests in Postgres12. > Sysbench Test Config > oltp-readwrite-custom > Threads - 500 > Machine: 16 core 64G > > In PG server: > shared_buffers: 16GB > maintenance_work_memory: 16GB > checkpoint_timeout: 1h >

Re: Where can I find the pg_config binary in PostgreSQL 14?

2021-10-01 Thread Oskar Stenberg
Never mind... I found it! For anyone else that has the same problem:  It had been moved to "/usr/pgsql-14/bin/pg_config" Sorry for disturbing everyone with this... *Facepalm* On Fri, 2021-10-01 at 12:12 +0200, Oskar Stenberg wrote: > Hi! > > I'm developing an application with PostgreSQL as the

Where can I find the pg_config binary in PostgreSQL 14?

2021-10-01 Thread Oskar Stenberg
Hi! I'm developing an application with PostgreSQL as the database. But during the compilation I need to use pg_config to get the paths of the other PostgreSQL files. But since upgrading to PostgreSQL 14 I can't find it anymore. Earlier I got this binary from libpq-devel (I'm using fedora as my wor