pg_rman is a tool to take incremental backups on Postgres. Although I do not see any recent development on this tool since june 2011. I somehow wanted to try installing it and try to use it in a test environment to justify its usage. I was facing some issues when I tried to install it and somehow could not find an answer to the errors I saw during installation.
pg_ram can be downloaded from here.
Once downloaded just untar using:
tar -xvzf pg_rman-1.2.4.tar.gz cd pg_rman-1.2.4 sudo make USE_PGXS=1
Got the following error message and started looking at google for help. All I could find is set your PATH for postgres binaries. Which I saw was correct. The issue seemed to me that the pg_rman Makefile would not find pg_config.
Also you should ensure that you have the postgresql-devel package installed as that’s the one that gets the pg_config in there.
make: pg_config: Command not found cc -c -o backup.o backup.c In file included from backup.c:10:0: pg_rman.h:12:25: fatal error: postgres_fe.h: No such file or directory compilation terminated. make: *** [backup.o] Error 1
I then modified the Makefile with the full path to the pg_config and it just worked. Below is the change:
PG_CONFIG = /opt/PostgreSQL/8.4.9/bin/pg_config (path to your pg_config could be different. Append it accordingly)