Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Fri, Jun 9, 2017 at 3:43 PM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:

On Fri, Jun 9, 2017 at 10:55 PM, Cocco Gianfranco
<Gianfranco.Cocco@xxxxxx> 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.

But there is something preventing it.  wal_segsize cannot exceed 64MB in 9.2. v10 will be the first version which will allow sizes above 64MB.

Cheers,

Jeff