On Wed, Aug 17, 2016 at 2:09 PM, Sameer Kumar
wrote:
>
>
> On Wed, Aug 17, 2016 at 12:00 PM Venkata B Nagothi
> wrote:
>
>> On Wed, Aug 17, 2016 at 1:31 PM, Sameer Kumar
>> wrote:
>>
>>>
>>>
>>> On Wed, Aug 17, 2016 at 10:34 AM Patrick B
>>> wrote:
>>>
Hi guys,
I'm using Postgre
On Wed, Aug 17, 2016 at 11:51 AM Patrick B wrote:
>
>>
>> But do you have statements which causes Exclusive Locks? Ignoring them in
>> OLTP won't make your life any easier.
>>
>> (Keeping avoiding to get into 'recovery conflict' as your sole goal) If
>> you decide to run pg_dump from master, it
On Wed, Aug 17, 2016 at 12:00 PM Venkata B Nagothi
wrote:
> On Wed, Aug 17, 2016 at 1:31 PM, Sameer Kumar
> wrote:
>
>>
>>
>> On Wed, Aug 17, 2016 at 10:34 AM Patrick B
>> wrote:
>>
>>> Hi guys,
>>>
>>> I'm using PostgreSQL 9.2 and I got one master and one slave with
>>> streaming replication.
On Wed, Aug 17, 2016 at 1:31 PM, Sameer Kumar
wrote:
>
>
> On Wed, Aug 17, 2016 at 10:34 AM Patrick B
> wrote:
>
>> Hi guys,
>>
>> I'm using PostgreSQL 9.2 and I got one master and one slave with
>> streaming replication.
>>
>> Currently, I got a backup script that runs daily from the master, it
>
>
>
> But do you have statements which causes Exclusive Locks? Ignoring them in
> OLTP won't make your life any easier.
>
> (Keeping avoiding to get into 'recovery conflict' as your sole goal) If
> you decide to run pg_dump from master, it would block such statements
> which have Exclusive locki
On Wed, Aug 17, 2016 at 11:36 AM Patrick B wrote:
>
>
> 2016-08-17 15:31 GMT+12:00 Sameer Kumar :
>
>>
>>
>> On Wed, Aug 17, 2016 at 10:34 AM Patrick B
>> wrote:
>>
>>> Hi guys,
>>>
>>> I'm using PostgreSQL 9.2 and I got one master and one slave with
>>> streaming replication.
>>>
>>> Currently,
2016-08-17 15:31 GMT+12:00 Sameer Kumar :
>
>
> On Wed, Aug 17, 2016 at 10:34 AM Patrick B
> wrote:
>
>> Hi guys,
>>
>> I'm using PostgreSQL 9.2 and I got one master and one slave with
>> streaming replication.
>>
>> Currently, I got a backup script that runs daily from the master, it
>> generate
On Wed, Aug 17, 2016 at 10:34 AM Patrick B wrote:
> Hi guys,
>
> I'm using PostgreSQL 9.2 and I got one master and one slave with streaming
> replication.
>
> Currently, I got a backup script that runs daily from the master, it
> generates a dump file with 30GB of data.
>
> I changed the script t
Hi guys,
I'm using PostgreSQL 9.2 and I got one master and one slave with streaming
replication.
Currently, I got a backup script that runs daily from the master, it
generates a dump file with 30GB of data.
I changed the script to start running from the slave instead the master,
and I'm getting
