Re: pg_dumpall / restore issues

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Derek Neighbors <derek(at)gnue(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dumpall / restore issues
Date: 2002-09-28 18:00:22
Message-ID: 200209281800.g8SI0MV18145@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Derek Neighbors wrote:
-- Start of PGP signed section.
> 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)

Use:

password_encryption = true

and during the load the passwords will be MD5 encrypted. However, this
disables pre-7.2 clients using crypt. This will be the default in 7.3.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-09-29 03:24:05 Re: [DBmirror Issue] recordchange() dies in packageData unless
Previous Message Willy Wonka 2002-09-28 17:19:49 Re: pg_dumpall fails