public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Paquier <[email protected]>
To: Cocco Gianfranco <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Cc: DBA <[email protected]>
Subject: Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
Date: Sat, 10 Jun 2017 07:43:00 +0900
Message-ID: <CAB7nPqT=+g4RWeqhW1=OsxGAXofbwekfMsznUd8Ug-GSB+gxVQ@mail.gmail.com> (raw)
In-Reply-To: <D0D985968D95594199094F94C3F7BCA124415034@ITPMX020.italy.itroot.adnet>
References: <D0D985968D95594199094F94C3F7BCA124415034@ITPMX020.italy.itroot.adnet>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-bugs>

On Fri, Jun 9, 2017 at 10:55 PM, Cocco Gianfranco
<[email protected]> wrote:
> Is there a way to fix “wal_segsize” to about 1 Gb in 9.2. version, and “rebuild” postgreSQL server?

As long as you are able to compile your own version of Postgres and
your distribution does not allow that, there is nothing preventing you
to do so.

> The goal is to drastically reduce the number of WALs.
> Upgrading to 9.5, is the only way to fix this issue?

Note that a server initialized with a segment size of X won't work
with a binary compiled with a size of Y. But you can always take a
logical dump of the server before the upgrade, and reload it in the
version of the server with a larger segment size. The cost here is
more downtime.
-- 
Michael


-- 
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
  In-Reply-To: <CAB7nPqT=+g4RWeqhW1=OsxGAXofbwekfMsznUd8Ug-GSB+gxVQ@mail.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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox