/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

Is postgresql faster than mysql?

890

What is join and how many types of joins?

869

What is character varying in postgres?

900

Which method is used to load the driver?

844

How are the stats updated in postgresql?

895

How to write sql script in postgresql?

921

What is the difference between a primary key and a composite key?

835

How do I make a pgadmin server?

946

What is postgres default password?

829

How do you edit a table in pgadmin?

820

Does postgres cache queries?

834

What are the types of stored procedures?

852

Is postgresql better than oracle?

863

What is the port 5432?

856

What is postgresql database cluster?

976