"Mag Gam" <magawake(at)gmail(dot)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
In response to
pgsql-novice by date
|Next:||From: Karl Martindale||Date: 2008-04-07 01:40:40|
|Subject: Postgres -> VB6|
|Previous:||From: Mag Gam||Date: 2008-04-07 00:49:35|
|Subject: Re: best practices for dumping databases|