From: Vasilis Ventirozos <v.ventirozos@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: wal_level not changing
Date: Mon, 4 Sep 2017 18:50:56 +0300
Message-ID: <44FA41F7-71F1-4B26-90BF-ACEF3B20A7A2@gmail.com> (raw)
In-Reply-To: <CABUL1344egq5suaXz=epmRRc8M4Hd8LZ2RjxyV5PeHVv1CC3XA@mail.gmail.com>
References: <CABUL1344egq5suaXz=epmRRc8M4Hd8LZ2RjxyV5PeHVv1CC3XA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
try ALTER SYSTEM set wal_level = '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='minimal' where name='wal_level';
>
> ERROR: parameter "wal_level" cannot be changed without restarting the server
>
>
> set wal_level='minimal';
>
> ERROR: parameter "wal_level" cannot be changed without restarting the server
>
>
>
> update pg_settings set setting='minimal' where name='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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: v.ventirozos@gmail.com
Subject: Re: wal_level not changing
In-Reply-To: <44FA41F7-71F1-4B26-90BF-ACEF3B20A7A2@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox