/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 to execute a function in postgresql?

462

How to start, stop and restart postgresql database?

469

List different advantages of postgresql?

484

What is stored procedure in postgresql?

454

How do I open the query tool in pgadmin?

424

Do foreign keys speed up queries?

426

What are the types of stored procedures?

438

What is self referencing foreign key?

414

Where is postgres configuration file?

440

What is the default password for postgres windows?

404

How do I rename a column in postgresql?

448

How to create a new table from existing table in postgresql?

442

Is foreign key an index?

449

What is a delete query?

437

How to access postgresql database from another machine?

400