le the extra data at the master. I'm not sure what would happen but
> killall in general is a dangerous command.
>
> On Thu, 3 Oct 2019, 7:00 am Shital A, wrote:
>
>>
>>
>> On Thu, 3 Oct 2019, 00:08 Ravi Krishna, wrote:
>>
>>> >
>>> >
On Thu, 3 Oct 2019, 00:08 Ravi Krishna, wrote:
> >
> > As the failed primary is having more data, How is it possible that
> primary is committing transaction before they were applied on standby with
> synchronous_commit=remote_apply?
>
> If I am not mistaken remote_apply is only from ver 11.
>
H
Hello,
We are seeing a strange issue with postgresql streaming application in sync
mode.
We are using postgresql 9.6. Old version because of some specific
requirements. We have setup cluster with master-standby using pacemaker.
When we kill master using killall -9 postgres. The failed primary h
*Hello All,*
We are in process of testing a Postgres 9.6 active-passive HA cluster using
streaming replication on Rhel 7.5.
We are seeing below issue with the setup :
1. When a failover is triggered while data is being added to the primary
by killing primary (killall -9 postgres), the failed no
On Mon, 23 Sep 2019, 00:46 Shital A, wrote:
>
> Hello,
>
> We have setup active-passive cluster using streaming replication on Rhe
> 7.5. We are testing pacemaker for automated failover.
> We are seeing below issues with the setup :
>
> 1. When a failoveris triggered whe
Hello,
We have setup active-passive cluster using streaming replication on Rhe
7.5. We are testing pacemaker for automated failover.
We are seeing below issues with the setup :
1. When a failoveris triggered when data is being added to the primary by
killing primary (killall -9 postgres), the sta
*Hello*,
We are working on a payments systems which uses postgreSql 9.6 as backend
DB and blockchain technology. The database is setup in HA in master-standby
mode using pacemaker on Linux 7.6.
*We are new to postgres and ne*ed help in deciding how to set value for
max_connections on DB.
1. How
On Mon, 19 Aug 2019, 23:36 Shital A, wrote:
>
>
> On Mon, 19 Aug 2019, 18:47 Shital A, wrote:
>
>> Hello,
>>
>> Need advise on below situation:
>>
>> Postgres 9.6
>> Pacemaker 1.1.19
>> Corosync 2.4.3
>>
>> We are testing HA s
On Mon, 19 Aug 2019, 18:47 Shital A, wrote:
> Hello,
>
> Need advise on below situation:
>
> Postgres 9.6
> Pacemaker 1.1.19
> Corosync 2.4.3
>
> We are testing HA setup on a two node cluster using pacemaker, corosync
> stack. The replication is streaming replica
On Tue, 13 Aug 2019, 11:50 Shital A, wrote:
>
>
> On Mon, 12 Aug 2019, 18:54 Adrien Nayrat,
> wrote:
>
>> On 8/12/19 2:57 PM, Shital A wrote:
>> >
>> >
>> > Hello,
>> >
>> > Postgres version : 9.6
>> > OS:Rhel 7.
On Mon, 12 Aug 2019, 18:54 Adrien Nayrat,
wrote:
> On 8/12/19 2:57 PM, Shital A wrote:
> >
> >
> > Hello,
> >
> > Postgres version : 9.6
> > OS:Rhel 7.6
> >
> > We are working on HA setup for postgres cluster of two nodes in
> active-pas
Hello,
Postgres version : 9.6
OS:Rhel 7.6
We are working on HA setup for postgres cluster of two nodes in
active-passive mode.
Installed:
Pacemaker 1.1.19
Corosync 2.4.3
The pacemaker agent with this installation doesn't support automatic
failback. What I mean by that is explained below:
1. Clu
On Fri, 9 Aug 2019, 21:25 Adrian Klaver, wrote:
> On 8/9/19 8:14 AM, Shital A wrote:
> >
>
> > Hello,
>
> >
> > 4) What techniques have you tried?
> > Insert into with With statement, inserting 200 rows at a time. This
> > takes 40 mins.
>
On Fri, 9 Aug 2019, 20:08 Adrian Klaver, wrote:
> On 8/9/19 4:12 AM, Shital A wrote:
> > Hello
> >
> > Postgresql 9.6
> >
> > Need to generate 1GB test data in very less time. I got some techniques
> > online but they take around 40mins for 400GB. Any quic
Hello
Postgresql 9.6
Need to generate 1GB test data in very less time. I got some techniques
online but they take around 40mins for 400GB. Any quicker way?
Thanks.
On Mon, 5 Aug 2019, 18:57 Kenneth Marshall, wrote:
> > >Hi,
> > >
> > >On RHEL/Centos you can use VDO filesystem compression to make an archive
> > >tablespace to use for older data. That will compress everything.
> >
> > Doesn't this imply that either his table is partitioned or he
> > regularly
On Mon, 5 Aug 2019, 12:42 Ron, wrote:
> On 8/5/19 1:30 AM, Shital A wrote:
> > Hello,
> >
> > Need inputs on below:
> >
> > We are working on a setting up a new highly transactional (tps 100k)
> OLTP
> > system for payments using blockchain and postgr
Hello,
Need inputs on below:
We are working on a setting up a new highly transactional (tps 100k) OLTP
system for payments using blockchain and postgresql 9.6 as DB on Rhel 7.6.
Postgres version is 9.6 and not latest because of specs of blockchain
component.
There is a requirement for data compr
18 matches
Mail list logo
