PostgreSQL Question:
How to take backup of database?
Answers:
Answer #1
/usr/local/bin/pg_dump mydatabase > mydatabase.pgdump
/usr/local/bin/pg_dump mydatabase > mydatabase.pgdump
Answer #2
pg_dump -h servername -U username -d dbname > dbname.sql
pg_dump -h servername -U username -d dbname > dbname.sql
| Previous Question | Next Question |
| How to list the number of database? | How to create a PostgreSQL user? |