Re: question about zeroes in the wal file names

2019-08-18 Thread Kyotaro Horiguchi
At Sun, 18 Aug 2019 16:17:03 +0200, Luca Ferrari wrote in > I'm just curious to better understand the naming convention behind wal > files, because I've seen on a system of mine that the wals created > were: > > 0005020E00FF > 0005020F > > while I was expecting 20E

Re: Missing Trigger after pgdump install

2019-08-18 Thread Tom Lane
Susan Hurst writes: > Error from Postgres server log (postgresql-2019-08-16_140110.log): > 2019-08-16 14:04:24 CDT ERROR: relation "devops.subscribers" does not > exist > 2019-08-16 14:04:24 CDT STATEMENT: create trigger subscribers_iur_trg > instead of update >

question about zeroes in the wal file names

2019-08-18 Thread Luca Ferrari
I'm just curious to better understand the naming convention behind wal files, because I've seen on a system of mine that the wals created were: 0005020E00FF 0005020F while I was expecting 20E0x100. So I digged into the code and I've seen, from the XLogFileName macro,