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.
pgsql-novice by date
|Next:||From: Sean Davis||Date: 2008-04-06 20:51:55|
|Subject: Re: best practices for dumping databases|
|Previous:||From: G. J. Walsh||Date: 2008-04-05 22:42:04|
|Subject: Difficulties with postgresql based session handlers|