PostgreSQL database

How to Execute PostgreSQL Commands Inside Unix Shell Scripts

by SathiyaMoorthy on March 26, 2010

Question: How do I executed PostgreSQL Commands inside a Linux / UNIX shell script?

Answer: With the help of the psql interactive terminal, you can execute the psql commands from the shell script. For this purpose, you should enable the password less login by pg_hba.conf, or .pgpass.
(more…)

{ 2 comments }

15 Advanced PostgreSQL Commands with Examples

by SathiyaMoorthy on May 21, 2009

postgreSQL DB
Some of the open source application comes with postgreSQL database. To maintain those application, companies may not hire a fulltime postgreSQL DBA. Instead they may request the existing Oracle DBA, or Linux system administrator, or programmers to maintain the potgreSQL. In this article let discuss about the 15 practical postgresql database commands which will be useful to both DBA and expert psql users.

Also, refer to our previous article about 15 Practical PostgreSQL DBA Commands.
(more…)

{ 15 comments }

15 Practical PostgreSQL Database Administration Commands

by Ramesh Natarajan on April 16, 2009

PostgreSQL DBA Commands
Earlier we discussed about how to install PostgreSQL database on Linux from source.

In this article, let us review top 15 practical postgreSQL DBA command examples.

If you are a mySQL administrator, check-out our 15 examples of mysqladmin command article that we discussed a while back.


(more…)

{ 9 comments }

9 Steps to Install and Configure PostgreSQL from Source on Linux

by Ramesh Natarajan on April 9, 2009

PostgreSQL Installation and Configuration Steps
Similar to mySQL, postgreSQL is very famous and feature packed free and open source database.

Earlier we’ve discussed several installations including LAMP stack installation, Apache2 installation from source, PHP5 installation from source and mySQL installation.

In this article, let us review how to install postgreSQL database on Linux from source code.

(more…)

{ 15 comments }

How To Backup and Restore PostgreSQL Database Using pg_dump and psql

by Ramesh Natarajan on January 21, 2009

PostgreSQL DB Backup and RestoreThis is a guest post written by SathiyaMoorthy

pg_dump is an effective tool to backup postgres database. It creates a *.sql file with CREATE TABLE, ALTER TABLE, and COPY SQL statements of source database. To restore these dumps psql command is enough.

Using pg_dump, you can backup a local database and restore it on a remote database at the same time, using a single command. In this article, let us review several practical examples on how to use pg_dump to backup and restore.
(more…)

{ 11 comments }