PostgreSQL database backup and recovery (scripting)

Database backup:

D:\Program files\postgresql\9.2\bin> pg_dump-h localhost-u postgres-c--column-inserts-f E:/dbname.sql dbname

Database recovery:

D:\Program files\postgresql\9.2\bin> psql-h localhost-u postgres-f e:/dbname.sql

Note:D:\Program files\postgresql\9.2\bin> is the installation path for Pg_dump.exe

Pg_dump: is a tool for backing up the PostgreSQL database.

- h:P ostgresql Server Host name

- u: Login user name for this operation

C: output the command to create the database before reconnecting to the newly created database.

--column-inserts : Export data with INSERT INTO table_name (columns_list) VALUES (values_list) command

- F: Specify File

PostgreSQL database backup and recovery (scripting)