PostgreSQL Question:

Download Job Interview Questions and Answers PDF

How to take backup of database?

PostgreSQL Interview Question
PostgreSQL Interview Question

Answers:

Answer #1
/usr/local/bin/pg_dump mydatabase > mydatabase.pgdump

Answer #2
pg_dump -h servername -U username -d dbname > dbname.sql

Download PostgreSQL Interview Questions And Answers PDF

Previous QuestionNext Question
How to list the number of database?How to create a PostgreSQL user?