On Sun, Apr 6, 2008 at 4:25 PM, Mag Gam <magawake(at)gmail(dot)com> wrote:
> What is the best way to dump a database?
> Currently, I am using pg_dump dbname. However, my data contains a lot of
> escape sequences and various characters which is causing a restore problem.
> How can I avoid problems like this? Is there a "binary" dump and restore? I
> rather use that if its going to guarantee valid data.
See the format argument to pg_dump. It allows binary dumps.
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2008-04-06 22:36:27|
|Subject: Re: best practices for dumping databases |
|Previous:||From: Mag Gam||Date: 2008-04-06 20:25:13|
|Subject: best practices for dumping databases|