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

best practices for dumping databases

From: "Mag Gam" <magawake(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: best practices for dumping databases
Date: 2008-04-06 20:25:13
Message-ID: 1cbd6f830804061325s51445b56rdca85cef9f5ed512@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.

TIA

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2008-04-06 20:51:55
Subject: Re: best practices for dumping databases
Previous:From: G. J. WalshDate: 2008-04-05 22:42:04
Subject: Difficulties with postgresql based session handlers

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