How to take backup of database?

Answer Posted / madhub

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

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you query pgadmin?

415


How to delete/drop an existing postgresql database?

462


How do I add a primary key in pgadmin?

427


How do I start postgresql on windows?

446


Can we have multiple index on a table?

450






How do I delete a query?

432


Do provide an explanation for pgadmin?

451


How many rows can postgres handle?

444


How do I start pgadmin 4 on windows?

437


What is maximum size of table in postgresql?

456


What happens to index when table is dropped?

455


What is the Maximum size for a table in PostgreSQL?

952


What is rds instance?

437


What is the difference between postgresql and sql?

398


How do I create a foreign key in postgresql?

414