On Tue, 15 Jun 2021 at 21:13, Ayub Khan wrote:
>
>
> Would it be a cursor issue on postgres, as there seems to be a difference
in how cursors are handled in postgres and Oracle database. It seems
cursors are returned as buffers to the client side. Below are the steps we
take from jdbc side
i did
Hi Haseeb,
I had configured replication on windows and made a document in an easy way.
I am not expert but I hope it will help you.
Regards
Atul
On Tuesday, June 15, 2021, Haseeb Khan wrote:
> Hello Rory,
>
> Yes , I have followed the document and configured each and everything. But
> I
Would it be a cursor issue on postgres, as there seems to be a
difference in how cursors are handled in postgres and Oracle database. It
seems cursors are returned as buffers to the client side. Below are the
steps we take from jdbc side
below is the stored procedure code:
CREATE OR REPLACE PROCE
Hello Rory,
Yes , I have followed the document and configured each and everything. But I
can’t see archive_Wal_segments is copying to the folder which I have created.
So the issue I am facing is that where should I create the archive folder
should I create on master or slave server ? Might be I
On 15/06/21, Haseeb Khan (khanhasee...@gmail.com) wrote:
> I have confusion below, Should we create an archive path on the standby
> server and then set it to recovery.conf file ?
>
> restore_command = 'cp /path/to/archive/%f %p'
Hi Hasseb
Are you following this procedure?
https://www.postgresql
Laurenz Albe 于2021年6月15日周二 下午3:07写道：
> On Tue, 2021-06-15 at 08:34 +0800, Yi Sun wrote:
> > > overcommit_ratio < (RAM - swap) / RAM * 100
> > >
> > > Here, RAM is the RAM available to PostgreSQL.
> >
> > Thank you for your reply
> >
> > 1. Our env RAM are 4GB, 8 GB, 16 GB... as below url suggesti
On Tue, 2021-06-15 at 08:34 +0800, Yi Sun wrote:
> > overcommit_ratio < (RAM - swap) / RAM * 100
> >
> > Here, RAM is the RAM available to PostgreSQL.
>
> Thank you for your reply
>
> 1. Our env RAM are 4GB, 8 GB, 16 GB... as below url suggestion, could we
> configure swap as below?
> https://o
