/usr/local/bin/pg_dump mydatabase

How to take backup of database?

Question Posted / madhub

Answer Posted / madhub

/usr/local/bin/pg_dump mydatabase > mydatabase.pgdump

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How long does it take to create an index on a large table?

739

How do I connect to postgresql on windows?

905

What is a sequence table in postgresql?

788

What is bytea in postgres?

847

What is psql?

814

How do I connect to postgresql access?

1009

Why do we need connection pooling?

785

How do I download postgresql on windows?

824

Does drop table remove indexes?

791

What is the point of foreign keys?

762

What does truncate table do?

803

What is multi-version control?

805

What is function and stored procedure?

828

What is work_mem in postgresql?

854

How do I remove all rows from a table?

834