postgresqlubuntuarchiving

ubuntu 14.10 and postgres 9.4 how to run pg_controldata


I have a server with pg_xlog directory filled up. I need to determine the WAL(Write Ahead Log) files to delete and according to this link i need pg_controldata which is not available in ubuntu with postgresql-contrib-9.4 installed.

How can I proceed?


Solution

  • Use locate pg_controldata to locate it at /usr/lib/postgresql/9.4/bin/pg_controldata.

    Alternatively, use find / -name pg_controldata. Ideally you would search somewhere more specific than the filesystem root.