Hello Rory,
Hope you're doing well !
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'
*BR,*
Haseeb Ahmad
On Tue, Jun 15, 2021 at 10:42 AM Haseeb Khan wrote:
> Thankyou Rory
Thankyou Rory !
Br,
Haseeb Ahmad
> On 15-Jun-2021, at 12:42 AM, Rory Campbell-Lange
> wrote:
>
> On 15/06/21, Haseeb Khan (khanhasee...@gmail.com) wrote:
>> Does anyone have complete documentation to configure PostgreSQL V13 Master
>> and Slave on Windows Server and also how to test Manual Fa
> On Mon, 2021-06-14 at 18:16 +0800, Yi Sun wrote:
> > After checking doc, only mentioned vm.overcommit_memory=2, but didn't
> mentioned vm.overcommit_ratio recommended value
> >
> https://www.postgresql.org/docs/11/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
> > some articles mentioned that 80 o
On 15/06/21, Haseeb Khan (khanhasee...@gmail.com) wrote:
> Does anyone have complete documentation to configure PostgreSQL V13 Master
> and Slave on Windows Server and also how to test Manual Failover ?
I suggest having a look at
https://www.postgresql.org/docs/13/high-availability.html
The serv
Hello Everyone !
I trust that you guys are keep doing very Well !
Does anyone have complete documentation to configure PostgreSQL V13 Master and
Slave on Windows Server
and also how to test Manual Failover ?
Would highly appreciated, if someone could help in this regard.
Br,
Haseeb Ahmad
> However, I'm skeptical that any problem actually remains in
> real-world use cases.
Hello Tom,
We also had some issues with planning and get_actual_variable_range(). We
actually found some interesting behaviour that probably requires an eye with
better expertise in how the planner works.
For th
On Mon, 2021-06-14 at 18:16 +0800, Yi Sun wrote:
> After checking doc, only mentioned vm.overcommit_memory=2, but didn't
> mentioned vm.overcommit_ratio recommended value
> https://www.postgresql.org/docs/11/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
> some articles mentioned that 80 or 90 conf
On Mon, Jun 14, 2021 at 06:16:35PM +0800, Yi Sun wrote:
>
> So is it OK just to configure vm.overcommit_ratio to 90 please?
This parameter entirely depends on the amount of RAM and swap you have on your
server, and how much memory you want to be allocable.
See https://www.kernel.org/doc/Documen
Andrew Dunstan writes:
> On 6/10/21 2:23 PM, Andrew Dunstan wrote:
>> Ouch. That looks like a plain old bug. Let's fix it. IIRC I just used
>> the same logic that we use for pg_dump's --exclude-* options, so we need
>> to check if they have similar issues.
> Peter Eisentraut has pointed out to me
On 6/10/21 2:23 PM, Andrew Dunstan wrote:
> On 6/10/21 2:00 PM, Tom Lane wrote:
>> "Dean Gibson (DB Administrator)" writes:
>>> On 2021-06-10 09:54, Ranier Vilela wrote:
Your cmd lacks =
=>pg_dumpall -U Admin --exclude-database=MailPen >zzz.sql
>>> I read that before posting, but misse
Hello,
After checking doc, only mentioned vm.overcommit_memory=2, but didn't
mentioned vm.overcommit_ratio recommended value
https://www.postgresql.org/docs/11/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT
some articles mentioned that 80 or 90 configuration in their env
So is it OK just to conf
11 matches
Mail list logo
