Hello All,
I'm looking for hardware configurations to set up 1 master and 2
hot-standby slaves using 9.6 in one DC. Also, I need to have DR with the
same setup with cross-site replication enabled. I went through a lot of
docs/blogs suggesting 4cores and at least 4/8GB RAM. But I'm looking for
help
AM, you will probably avoid many of your
> problems about disks performances.
>
> Do not forget disks, RAID controllers, networking, SLA, SLO, HA, DR..
>
> OT: I would use newer Postgres than 9.6 if I were you, unless you have
> good reasons to use 9.6.
>
>
> regards,
&
Hello,
I had setup one master and hot-slave by setting WAL_LEVEL=replica
But I use a debezium plugin and it requires to connect to master with
WAL_LEVEL=logical and it is mandatory. Can I achieve master/slave streaming
replication by setting WAL_LEVEL to logical on master ? Are there any
drawback
Thanks. Will this approach replicate DDL changes ?
On Tue, Jun 9, 2020 at 1:36 PM Andreas Kretschmer
wrote:
>
>
> Am 09.06.20 um 09:55 schrieb Praveen Kumar K S:
> > Can I achieve master/slave streaming replication by setting WAL_LEVEL
> > to logical on master ? Are ther
Hello,
I have a master and slave setup running and sometimes we have to do a
complete refresh on dev environments. How can I reset postgres server so
that it wipes out everything including WAL ? So that I configure
master/slave streaming replication again from scratch ? TIA.
--
*Regards,*
*K
Providing more details.
OS is Ubuntu 16.04 and postgres is installed from APT.
logical and physical replication slots configured on master.
No WAL archiving configured.
Streaming replication is enabled on master.
Slave is hot-standby
On Wed, Jun 10, 2020 at 6:03 PM Praveen Kumar K S
wrote
Hello,
Yes, both are part of dev. Should I clean the data directory on both
servers or only on master ?
On Wed, Jun 10, 2020 at 7:50 PM Adrian Klaver
wrote:
> On 6/10/20 5:33 AM, Praveen Kumar K S wrote:
> > Hello,
> >
> > I have a master and slave setup running and some
Hello,
I have set up pgpool and there are 2 postgres servers behind it. I had run
pgbench with and without pgpool and got the results. I would like to
showcase the results for a presentation. Just thought of asking you people
if there are any tools to generate nice results with charts and graphs ?
Hello,
I'm running Postgres9.6 and configured master/slave with synchronous
replication (synchronous_commit set to remote_apply) .
In addition to that I have one logical replication slot on master. When
master fails and one of the slaves is promoted to master, how can I have
that logical replicati
Hello,
PostgreSQL libraries are required while compiling pgpool. I need to install
postgresql-libs and postgresql-devel on Ubuntu Server 16.04
How can I install only these packages without having to install the entire
postgres server ? TIA.
--
*Regards,*
*K S Praveen Kumar*
Thank you. That solved the problem.
On Fri, Jul 3, 2020 at 8:24 PM Adrian Klaver
wrote:
> On 7/3/20 7:21 AM, Adrian Klaver wrote:
> > On 7/3/20 4:37 AM, Praveen Kumar K S wrote:
> >> Hello,
> >>
> >> PostgreSQL libraries are required while compiling pgpoo
11 matches
Mail list logo
