"Mag Gam" <magawake@gmail.com> writes:
> But, what is the correct practice to do db_dumps? pg_dump db should suffice?
Yes, though remember that pg_dump doesn't dump any role or tablespace
definitions, and it also doesn't think about properties attached to the
database as such (ALTER DATABASE etc). You might want to use
"pg_dumpall -g" for those.
regards, tom lane