Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6vxn-0004lo-HD for pgsql-admin@arkaria.postgresql.org; Tue, 02 Feb 2021 13:43:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l6vxl-0002uC-BW for pgsql-admin@arkaria.postgresql.org; Tue, 02 Feb 2021 13:43:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l6vxl-0002u5-0M for pgsql-admin@lists.postgresql.org; Tue, 02 Feb 2021 13:43:25 +0000 Received: from mail-qk1-x731.google.com ([2607:f8b0:4864:20::731]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1l6vxg-0000wJ-U1 for pgsql-admin@postgresql.org; Tue, 02 Feb 2021 13:43:24 +0000 Received: by mail-qk1-x731.google.com with SMTP id d85so19752766qkg.5 for ; Tue, 02 Feb 2021 05:43:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=cqRViwPQQe8hrMa07lhumxAsRf9NDBqHAFW0ww3ZJf0=; b=uvQmbtbYYjzmGzw8qblFap6UELiAx5/ei7sfy2O90FC9+AC6Co7kzp9fMMnYcSfB8D NbFoQJA/LgRnMqWpI2Kg0FTzsm5eEHm3JyLdcvXX84Xc5OOO3vaK4AdFoCWBnV6WWTDE LltfhTy4K5em+uQWda3Za0VEpge3o6vZ81jdRXRQr0bWHXtBSXtxs2Lfj7GoemSO+KfQ z2XzJh7d7+NeYO7HJTCIhLiDthEdaRStEXe5ycbJG1b0XhMveK1X0twesjdGa2UEydma VoI6DSY8ogM0WVT/5fB2XI3Auz9qAMhp2ADNbGReJHaqtlPVkvbGdh6Zk02BHBW7NwCU 4ouA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=cqRViwPQQe8hrMa07lhumxAsRf9NDBqHAFW0ww3ZJf0=; b=fR9Jr4t7M1YG44DW1UqnkyL/BiG9sFLBNfYwSzchtj4wyjkbu2h6HETjxTG2sXSJgS Dcvd78ZdO0jovQsrbeoICMxxEzX89eCb/mGdkMKPrGV9BRi5Kcy8KxNQEH7I6gA5QQ3r Spu7mEviQKk3Dosh8hXbgKNRbss9wAXubcB5o3osfZYmCcxwTEnzYLtb6RERuweWOJfK lof07V5tDtnsyMGtgopB3CCKcY7irSK277VTYgiU94pOrpGS/5VY24W1flEzBOKE04R8 nATMQvmi6svMnEOvl95uPJcYegg9UXkfZiYdZr4Ce2rsqeY8cQsOM7yo8soX2aEAbG37 JusA== X-Gm-Message-State: AOAM531oVOnAbxgBD44eM+LdbK9TcF/wWZtRufZEyiZsa2zkJ2nxliNC V2S453se2JY3C+FsslV5TcA= X-Google-Smtp-Source: ABdhPJxTLOiIyvKQOjGvd4fAFxZWoMmyjWfa59ITNKeAXKygNZh7br2oMRIIERGKf4UlykqykDm8JQ== X-Received: by 2002:a37:bc07:: with SMTP id m7mr21304527qkf.438.1612273398917; Tue, 02 Feb 2021 05:43:18 -0800 (PST) Received: from [192.168.254.67] (h178.165.133.40.static.ip.windstream.net. [40.133.165.178]) by smtp.gmail.com with ESMTPSA id q6sm9060289qkq.34.2021.02.02.05.43.18 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 02 Feb 2021 05:43:18 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-3D856C40-A690-47CC-8311-9CEAACC2B35B Content-Transfer-Encoding: 7bit From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: Changes in Aurora PostgreSQL for min & max_wal_size parameter Date: Tue, 2 Feb 2021 08:43:17 -0500 Message-Id: <02E20838-5081-47A9-8A89-81F83CE1DA6E@gmail.com> References: Cc: pgsql-admin@postgresql.org In-Reply-To: To: dbatoCloud Solution X-Mailer: iPad Mail (18C66) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-3D856C40-A690-47CC-8311-9CEAACC2B35B Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Well, I hate to be bearer of bad news, but Aurora PostgreSQL is certainly n= ot the community version, and they really haven=E2=80=9Dt built it for data w= arehousing. Sent from my iPad > On Feb 2, 2021, at 8:32 AM, dbatoCloud Solution w= rote: >=20 > =EF=BB=BF > Oh my God ! It is my time too. I am requesting them to share Dataware hou= se specific document to optimize Aurora PostgreSQL . This is the first time I= am working with this flavor earlier i used to work community version. I don= 't know what to do now. > =20 > =20 >=20 > --------------------------------------------------------------------------= ------------------------------------------- >=20 > Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103) >=20 > Dubai , UAE | BLR , INDIA >=20 > M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922 >=20 > W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com=20 >=20 >=20 >=20 >> On Tue, Feb 2, 2021 at 6:36 PM John Scalia wrote= : >> With AWS Aurora, you=E2=80=99re out of luck. They really don=E2=80=99t al= low many parameters and database parameter groups are not editable to add a n= ew parameter. I deal with this on a daily basis. >>=20 >> Sent from my iPad >>=20 >> > On Feb 2, 2021, at 8:05 AM, Scott Ribe wr= ote: >> >=20 >> > =EF=BB=BF >> >>=20 >> >> On Feb 2, 2021, at 6:01 AM, dbatoCloud Solution wrote: >> >>=20 >> >> when I checked with AWs they are saying that we cannot increase the ma= x_wal_size & min_wal_size >> >=20 >> > Seems like you already have your answer. >> >=20 >> >=20 >> >=20 >> >=20 --Apple-Mail-3D856C40-A690-47CC-8311-9CEAACC2B35B Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Well,  I hate to be bearer of bad news= , but Aurora PostgreSQL is certainly not the community version, and they rea= lly haven=E2=80=9Dt built it for data warehousing.

S= ent from my iPad

On Feb 2= , 2021, at 8:32 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote= :

=EF=BB= =BF

 Oh m= y God ! It is my time too. I am requesting them to share Dataware house specific document to optimize Aurora PostgreSQL . This i= s the first time I am working with this flavor earlier i used to work community version. I don't know what to do now.

 

=

 

-----------------------------------------------------= ----------------------------------------------------------------

A= shokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UA= E | BLR , I= NDIA

M:= +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W:= https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com



On Tue, Feb 2, 2021 at 6:36 PM John Scalia <jayknowsunix@gmail.com> wrote:
With AWS Aurora, you=E2=80= =99re out of luck. They really don=E2=80=99t allow many parameters and datab= ase parameter groups are not editable to add a new parameter. I deal with th= is on a daily basis.

Sent from my iPad

> On Feb 2, 2021, at 8:05 AM, Scott Ribe <scott_ribe@elevated-dev.com> wro= te:
>
> =EF=BB=BF
>>
>> On Feb 2, 2021, at 6:01 AM, dbatoCloud Solution <dbatocloud17@gmail.com> w= rote:
>>
>> when I checked with AWs they are saying that we cannot increase the= max_wal_size & min_wal_size
>
> Seems like you already have your answer.
>
>
>
>
= --Apple-Mail-3D856C40-A690-47CC-8311-9CEAACC2B35B--