I'm using Postgres 9.6.5.
In the docs under--
[13.3. Explicit Locking][
https://www.postgresql.org/docs/9.6/static/explicit-locking.html]
"13.3.2. Row-level Locks" -> "Row-level Lock Modes" -> "FOR UPDATE":
''' FOR UPDATE causes the rows retrieved by the SELECT statement to be
locked as though
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,
&
drawbacks of it ?
--
*Regards,*
*K S Praveen Kumar*
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
,*
*K S Praveen Kumar*
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
? TIA
--
*Regards,*
*K S Praveen Kumar*
gical replication slot and LSN on the slave ?
--
*Regards,*
*K S Praveen Kumar*
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
12 matches
Mail list logo
