Skip site navigation (1) Skip section navigation (2)

Re: best practices for dumping databases

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Mag Gam" <magawake(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: best practices for dumping databases
Date: 2008-04-06 20:51:55
Message-ID: 264855a00804061351w667fde3buc093b780b76da67@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Sean

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2008-04-06 22:36:27
Subject: Re: best practices for dumping databases
Previous:From: Mag GamDate: 2008-04-06 20:25:13
Subject: best practices for dumping databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group