From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_dumpall (7.1beta1, current CVS) |
Date: | 2001-01-02 02:04:56 |
Message-ID: | 20010101200456.A28188@lerami.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [010101 13:16]:
> Larry Rosenman <ler(at)lerctr(dot)org> writes:
> > I noticed today that pg_dumpall from current CVS does *NOT*
> > dump a password assiged to the postgres user.
>
> > I consider this BAD, since if one has to restore from
> > a pg_dumpall, one may forget to reset the password.
>
> I'm unconvinced. The pg_dumpall script is clearly intended to allow
> restoration into a new database installation with a different superuser;
> you will note that the script is careful not to assume that the old and
> new superuser names are the same (an assumption your proposed patch
> does make).
>
> In any case the new installation certainly already *has* a superuser.
> I'm not sure it's the job of the restore script to change his password
> for him.
>
> This does point up that there is some state that is not saved/restored
> by pg_dumpall --- the pg_hba.conf file and other config files that
> live in $PGDATA come to mind. Perhaps there should be a separate
> utility that saves/restores these. (pg_dump can't do it because there's
> no way to retrieve these files through a database connection.)
How would you suggest doing this? A shell script that makes a SHAR or
somesuch? Or what? Should it save the SuperUser password?
I agree that this is a shortcoming.
As to the SuperUser password thing, how do we remind the user that
they had one set? Can we at least put out a comment in the pg_dumpall
output that mentions it?
>
> regards, tom lane
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | Larry Rosenman | 2001-01-02 02:05:27 | Re: Current Sources/UW7.1.1 |
Previous Message | Ferruccio Zamuner | 2001-01-02 00:34:55 | Re: PRIMARY KEY and INHERITANCE |