| From: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
|---|---|
| To: | "Dr(dot) Hans-Christian Waldmann" <waldmann(at)samson(dot)fire(dot)uni-bremen(dot)de> |
| Cc: | pgsql-admin(at)postgresql(dot)org, silvan(at)goemon(dot)polito(dot)it |
| Subject: | Re: psql -U postgres does not require a password |
| Date: | 2000-11-06 16:44:36 |
| Message-ID: | 3A06DFF4.5E39803D@wgcr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Dr. Hans-Christian Waldmann" wrote:
> which is _external_ to the database. I could imagine that your migration
> install has simply overwritten the external file while preserving internal
> tables. A default pg_hba.conf leads to the behavior described: anyone can
> access any database with just a username. So please chekc this file.
The upgrade procedure calls for a dump, then an initdb (done by the
startup script), then a restore.
The passwords, etc, are dumped and restored -- but pg_hba.conf is not
copied in any way. The initdb would in fact overwrite this file --
which, if the recommendations in the upgrade docs (README.rpm) were
followed, there should be a copy of that file in the backup directory.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin M. Roy | 2000-11-06 20:48:11 | v7.0.3 |
| Previous Message | Peter Eisentraut | 2000-11-06 16:02:41 | Re: psql -U postgres does not require a password |