Table of Contents Previous Next


3 Database Administration : 3.7 Customizable WAL Segment File Size

When a database cluster is created with the initdb utility program, the default size of each WAL segment file is 16 MB.
The Advanced Server initdb utility provides an additional --wal-segsize option to specify the size of WAL segment files when creating a new data base cluster.
initdb --wal-segsize=size [ options ]... -D directory
size is the WAL segment file size in megabytes, which must be a power of 2 (for example, 1, 2, 4, 8, 16, 32, etc.). The minimum permitted value of size is 1 and the maximum permitted value is 1024. The database cluster is to be created in directory.
For more information on the initdb utility and its other options, see the PostgreSQL core documentation available at:
After the database server is started, the display of the wal_segment_size parameter also confirms the file size:


3 Database Administration : 3.7 Customizable WAL Segment File Size

Table of Contents Previous Next