pg_dumpall / restore issues - Mailing list pgsql-admin

From Derek Neighbors
Subject pg_dumpall / restore issues
Date
Msg-id 1033232784.536.186.camel@latitude
Whole thread Raw
In response to Re: pg_dumpall fails  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dumpall / restore issues  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
After a recent failure and restore I noticed two things that might be
bugs in pg_dumpall:

1. It saves the users passwords as plain text in the dump. (gack)
2. It doesnt seem to be i18n friendly.  Our tables had lots of
   umlats and accent's etc in them and they barfed on the restore
   noticed that they were represented as \0232 or such.  I had
   to hand fix all occurances to import.

--
Derek Neighbors
GNU Enterprise
http://www.gnuenterprise.org
derek@gnue.org

Was I helpful?  Let others know:
 http://svcs.affero.net/rm.php?r=dneighbo

Attachment

pgsql-admin by date:

Previous
From: "shreedhar"
Date:
Subject: Pg_acl check Invalid userid 106
Next
From: Willy Wonka
Date:
Subject: Re: pg_dumpall fails