Postgresql - What are the WAL filename limits?

Asked Oct 27 '17 at 16:04

Active Oct 27 '17 at 22:26

Viewed 117 times

Concerning postgresql WAL filename, what are the limits to the following?

My understanding is that segment is limited to 00..FF (boundary-inclusive).

For instance, could the following WAL be produced by postgresql?

FFFFFFFFFFFFFFFF000000FF

UPDATE:

I have since found the following in postgresql source code:

typedef uint32 TimeLineID

which allows from a data store the values 0x00000000..0xFFFFFFFF

edited Oct 27 '17 at 22:26

asked Oct 27 '17 at 16:04

abstractx1

I wish to see `FFFFFFFF` timeline... – Vao Tsun Oct 27 '17 at 16:51
Is it possible within postgresql? – abstractx1 Oct 27 '17 at 20:43
i dont see any reason why not. but definitely never wondered – Vao Tsun Oct 27 '17 at 20:44
It would take a very, very, VERY long time to get there, unless you modified the code to increment the timeline faster. Since you have to do a promotion via recovery.conf for each timeline increment, you're never going to run out of timelines. – Craig Ringer Oct 29 '17 at 14:29

0 Answers0