CODEWITHSUNDEEP
postgresqlubuntuarchiving
Bwire
Bwire

Reputation: 1201

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?

Upvotes: 2

Views: 2636

Answers (1)

Bwire
Bwire

Reputation: 1201

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.

Upvotes: 6

Related Questions