Postgres Pro
Downloads
Home   >   mailing lists

Re: best practices for dumping databases - Mailing list pgsql-novice

From Tom Lane
Subject Re: best practices for dumping databases
Date
Msg-id 16057.1207531444@sss.pgh.pa.us
Whole thread Raw
In response to Re: best practices for dumping databases  ("Mag Gam" <magawake@gmail.com>)
Responses Re: best practices for dumping databases  (richard terry <rterry@gnumed.net>)
List pgsql-novice
Tree view 
"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

pgsql-novice by date:

Previous
From: "Mag Gam"
Date:
Subject: Re: best practices for dumping databases
Next
From: Karl Martindale
Date:
Subject: Postgres -> VB6