The PostgreSQL binary file trailer is a single 16-bit integer with a value of -1, followed by the end of the file. This is easily distinguishable from a tuple’s initial 16-bit field-count, and can aid an application in staying in sync with the data.

Get Practical PostgreSQL now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.