Question

0

How to create a backup of an POSTGRES DB using bash?

flag	asked Oct 14 at 18:34 Roland 863●5●13 92% accept rate

depesz · Answer 1 · 2009-10-14 19:17:14Z

4

pg_dump -U some_user_name -f dump.file -Fc database_name

That's all.

If you need to authenticate with password - use pgpass file.

answered Oct 14 at 19:17

depesz
8,562●6●21

Pablo Santa Cruz · Answer 2 · 2009-10-14 18:42:28Z

0

answered Oct 14 at 18:42

I have difficulties including the username and password with pg_dump – Roland Oct 14 at 18:51

How to create a backup of an POSTGRES DB using bash?

2 Answers