Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1doteX-0001O5-Sq for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 15:51:10 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1doteW-0006I8-HM for pgsql-admin@arkaria.postgresql.org; Mon, 04 Sep 2017 15:51:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1doteW-0006Hz-3w for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 15:51:08 +0000 Received: from mail-wm0-x230.google.com ([2a00:1450:400c:c09::230]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1doteP-0007KL-9D for pgsql-admin@postgresql.org; Mon, 04 Sep 2017 15:51:07 +0000 Received: by mail-wm0-x230.google.com with SMTP id i145so7158870wmf.1 for ; Mon, 04 Sep 2017 08:51:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:mime-version:subject:date:references:to:in-reply-to:message-id; bh=MriLV7BYdS+ipW9a+kVA0Iq08wrcMrENolcAGB2M5uc=; b=A9ZsIZPH62immJHsxeqrjb0cnRnx7dFHPa2JYG5uyeHP6yqnDmC20YhTA0at19sV2v 7dYrrbEjPBnUwdvGIeXUjMNEYfz8M/P+BSctCSsZmkcgoIkG+Ja6s1/ZLulq+WGMfCXW d2HLQE0Viy2eGs74t6kFuS9pmWECKX5sGGLSXtNCvOZ59r5J5ElKK8+eG64Ye0hQYbXO 4U2I2j0X3qrMxqZmO/edTiu9o7QuMC6tsZmNPnFGfVJIEMdiKWN2p61iQ8P710hTGjG3 eH6njv4r37XMyvqDW2Edzzymc2jw+nOchA3C+W8DxGA9Vlq3FRkiMz1Wx8Qc0mPkpDMo GO+w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:mime-version:subject:date:references:to :in-reply-to:message-id; bh=MriLV7BYdS+ipW9a+kVA0Iq08wrcMrENolcAGB2M5uc=; b=eyKNvd10Xvsv6DxCw+qAM/j4uWIksTL4XS6ojVx7fcnLSjVhMvqdi0hXDfj+9fKSOI mXaLHrJw/TaXD4YC+saVKL8JF9gFvrh/HhdlQLQwvL9FJ79QVRU3Mb/a+ftRPpMb16TP Q8KrZgAlUwxd82hAoKeDjNt/TEDQK3fkNfIb/aZacYmF7vEKizRd2U+gyvj7QhMzg43m 67tzKQ55i/7/FZSRM7Crg5oMU0k4haSrw2nIiW+X7lOphYJlnZmfzKOQC362lesQHNL6 GFdLLCs4fyqKOMnBNE/Zpopi2RLFljVlbHSObZ5vrxuFZr7xChdTyyhGBarurEGiqJkD cYCg== X-Gm-Message-State: AHPjjUjwE+526DgCjkf5O9VEe7BuZPc9JVVAabYpqpfHvzcuWZUsur/L LrlOFJYs7nxJE5T0BqI= X-Google-Smtp-Source: ADKCNb6rLD7S0jNUR0zwmYHa/HlqNwdctowoFvcv41EvqL+KxLwVNoC+fSMWoEAukWfpSX4TIHOOBQ== X-Received: by 10.28.220.86 with SMTP id t83mr598087wmg.188.1504540259911; Mon, 04 Sep 2017 08:50:59 -0700 (PDT) Received: from [192.168.1.2] (athedsl-4498212.home.otenet.gr. [94.71.143.44]) by smtp.gmail.com with ESMTPSA id c21sm3448977wrb.17.2017.09.04.08.50.58 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 04 Sep 2017 08:50:59 -0700 (PDT) From: Vasilis Ventirozos Content-Type: multipart/alternative; boundary="Apple-Mail=_CA7E17E0-8832-4D71-BFF2-0DBC96DD3908" Mime-Version: 1.0 (Mac OS X Mail 10.3 \(3273\)) Subject: Re: wal_level not changing Date: Mon, 4 Sep 2017 18:50:56 +0300 References: To: pgsql-admin In-Reply-To: Message-Id: <44FA41F7-71F1-4B26-90BF-ACEF3B20A7A2@gmail.com> X-Mailer: Apple Mail (2.3273) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail=_CA7E17E0-8832-4D71-BFF2-0DBC96DD3908 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii try ALTER SYSTEM set wal_level =3D 'minimal'; and then restart , just make sure that archiving is disabled first. Vasilis Ventirozos > On 4 Sep 2017, at 18:42, Sumeet Shukla = wrote: >=20 >=20 > Hi, >=20 > update pg_settings set reset_val=3D'minimal' where name=3D'wal_level'; >=20 > ERROR: parameter "wal_level" cannot be changed without restarting the = server >=20 > =20 > set wal_level=3D'minimal'; >=20 > ERROR: parameter "wal_level" cannot be changed without restarting the = server >=20 >=20 >=20 > update pg_settings set setting=3D'minimal' where name=3D'wal_level'; >=20 >=20 > ERROR: parameter "wal_level" cannot be changed without restarting the = server >=20 >=20 >=20 > Even after restarting and reloading the server multiple times the = setting does not update and remains as below: >=20 > show wal_level; >=20 > +-----------+ >=20 > | wal_level | >=20 > +-----------+ >=20 > | replica | >=20 >=20 > +-----------+ >=20 >=20 >=20 >=20 >=20 > Thanks & Regards, > Sumeet Shukla >=20 --Apple-Mail=_CA7E17E0-8832-4D71-BFF2-0DBC96DD3908 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii try ALTER SYSTEM  set wal_level =3D 'minimal';
and then restart , just make sure that archiving is disabled = first.

Vasilis = Ventirozos

On 4 Sep 2017, at 18:42, Sumeet Shukla <sumeet.k.shukla@gmail.com> wrote:


Hi,

update pg_settings set reset_val=3D'minimal' where = name=3D'wal_level';

ERROR:  parameter = "wal_level" cannot be changed without restarting the = server

 

set = wal_level=3D'minimal';

ERROR:  parameter = "wal_level" cannot be changed without restarting the server


update pg_settings set = setting=3D'minimal' where name=3D'wal_level';


ERROR:  parameter = "wal_level" cannot be changed without restarting the server


Even = after restarting and reloading the server multiple times the setting = does not update and remains as below:

show wal_level;

+-----------+

| wal_level |

+-----------+

| replica   |


+-----------+



Thanks = & Regards,
Sumeet = Shukla


= --Apple-Mail=_CA7E17E0-8832-4D71-BFF2-0DBC96DD3908--