pg_filedump 10.0 released

Christoph Berg <[email protected]> Sun, 22 Oct 2017 20:38:31 +0200

Newsgroups	gmane.comp.db.postgresql.announce
Message-ID	<[email protected]>

pg_filedump 10.0 released

pg_filedump is a utility to format PostgreSQL heap/index/control files
into a human-readable form. You can format/dump the files several
ways, as listed in the Invocation section, as well as dumping straight
binary.

https://wiki.postgresql.org/wiki/Pg_filedump

New in version 10.0 is the ability to decode tuples by giving a list
of type names:

  -D  Decode tuples using given comma separated list of types.
      List of supported types:
        * bigint
        * bigserial
        * bool
        * char
        * charN     -- char(n)
        * date
        * float
        * float4
        * float8
        * int
        * json
        * macaddr
        * name
        * oid
        * real
        * serial
        * smallint
        * smallserial
        * text
        * time
        * timestamp
        * timetz
        * uuid
        * varchar
        * varcharN -- varchar(n)
        * xid
        * xml
        * ~        -- ignores all attributes left in a tuple

For instance, pg_attribute can be decoded like this:

    pg_filedump -D oid,name,oid,int,smallint,~ path/to/segment/1249

This feature was implemented by Aleksander Alekseev, reviewed by
Dmitry Ivanov, tested by Dmitry Ivanov and Grigoriy Smolkin.

signature.asc (application/pgp-signature, 833 B)