Posts tagged as:

Postgres

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…)

{ 4 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…)

{ 7 comments }