Tag Archives: postgre

Installing PostgreSQL 9.2 contrib extension in RedHat Linux

I had a table view in PostgreSQL DB, which uses ‘crosstab‘ function.

But my PostgreSQL wouldn’t let me use it, as it requires some extensions.

Crosstab function requires ‘tablefunc‘ extension.

When I tried

CREATE EXTENSION tablefunc;

It gave me

ERROR: could not open extension control file “/usr/pgsql-9.2/share/extension/tablefunc.control”: No such file or directory

********** Error **********

ERROR: could not open extension control file “/usr/pgsql-9.2/share/extension/tablefunc.control”: No such file or directory
SQL state: 58P01

Read more of this post

Advertisements

PosgreSql 9.0.x replication on CentOS 5.5 x64

For Postgresql replication database system consists of two servers, one is master server and another is slave server. CentOS 5.5 x64 is installed in both of the servers. Following steps are applicable in both of the servers. I issued all the commands as root. For our demo I used 172.20.1.88 as master and 172.20.1.89 as slave.

  • Installing Postgresql server.

wget http://yum.postgresql.org/9.0/redhat/rhel-5.0-x86_64/pgdg-centos90-9.0-5.noarch.rpm

rpm -ivh pgdg-centos90-9.0-5.noarch.rpm

yum install postgresql90-server.x86_64

Read more of this post

Automated Postgres database backup on CentOS

My application is running on Postgres. Now, I’m planning to take daily backup of my database.

So, far I have learned from using PgAdmin III, I can take back up using the backup tool. Its a easy process. Open PgAdmin III, connect to the database server. Right click on the db name and click backup. Save the back up file and it is done. But, I couldn’t find anything, that I can create a schedule and it will take back up according to the schedule.

Read more of this post