R: Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64

Thank you.

If I understand it well, we can build a new postgreSQL server, by setting this value into "configure" file?

--with-wal-segsize=SEGSIZE becomes --with-wal-segsize=1024 ??

_______________________________

Gianfranco Cocco

Gruppo DBA Torino

Managed Operations - Data Center Factory

gianfranco(dot)cocco(at)eng(dot)it

Engineering.MO S.p.A

Corso Mortara, 22 - 10149 Torino

Tel. 011 19449548 (SHORT CODE: 676548)

www.eng.it

___________________________

-----Messaggio originale-----
Da: Michael Paquier [mailto:michael(dot)paquier(at)gmail(dot)com]
Inviato: lunedì 12 giugno 2017 23:26
A: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Cocco Gianfranco <Gianfranco(dot)Cocco(at)eng(dot)it>; pgsql-performance(at)postgresql(dot)org; pgsql-bugs(at)postgresql(dot)org; DBA <DBA(at)italiaonline(dot)it>
Oggetto: Re: [BUGS] Invalid WAL segment size. Allowed values are 1,2,4,8,16,32,64

On Tue, Jun 13, 2017 at 2:27 AM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com<mailto:jeff(dot)janes(at)gmail(dot)com>> wrote:

> 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.

Yes, indeed. I have misread --with-segsize and --with-wal-segsize in the docs. Sorry for the confusion.

--

Michael