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. [...]

Connecting Postgres remotely through pgAdmin III

I’m new at postgre. I have installed Postgres to my server machine. It has nice and effective client interface, which is pgAdmin III. I have worked on it, where postgre DB server and pgAdmin III are in same machine. But, now I need connect with the server machine. Which means, my db server is in [...]

Installing Postgres Plus 9.0.2 on CentOS 5.5 64 bit

I wanted to install Postgre SQL on my CentOS. So, I went for Enterprisedb which is Postgres Plus 9.0.2 I went to http://www.enterprisedb.com/products-services-training/pgdownload to download 64bit version of Postgres Plus. I downloaded ‘postgresplus-9.0.2-1-linux-x64.bin’. I found that there is some pre requisite to install postgre. I have to install gcc and other libraries. So, I issued .. yum install bison byacc [...]