Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
Date
Msg-id CAMkU=1wWV=3MMpncboYjXkVQqXrk6Dnukj-57h=LyiLnWE=zHA@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64
List pgsql-bugs
Tree view
On Fri, Jun 9, 2017 at 3:43 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Fri, Jun 9, 2017 at 10:55 PM, Cocco Gianfranco
<Gianfranco.Cocco@eng.it> 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

pgsql-bugs by date:

Previous
From: Neil Anderson
Date:
Subject: Re: [BUGS] BUG #14701: pg_dump fails to dump pg_catalog schema
Next
From: Michael Paquier
Date:
Subject: Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64