RE: [HACKERS] Re: [GENERAL] How do I activate and change the postgres user's password? - Mailing list pgsql-general

From Aaron J. Seigo
Subject RE: [HACKERS] Re: [GENERAL] How do I activate and change the postgres user's password?
Date
Msg-id 99101411153306.25873@stilborne
Whole thread Raw
In response to RE: [HACKERS] Re: [GENERAL] How do I activate and change the postgres user's password?  (Nicolas Huillard <nhuillard@ghs.fr>)
List pgsql-general
hi..

> * there is still a problem for the access to the database themselves : site
> 1 should access database 1, and not database 2, but there should have the
> least password in the calling scripts

a quick thought: if you are really paranoid, set up different installations of
postgres, even if on the same box... don't run them on the default port, set up
seperate pg_hba files and it should keep everything QUITE seperate.

> I already posted a message concerning security, but nobody seems to be
> concerned about this. I read the advices at www.cert.org, and since then, I
> became paranoiac...

as a side note, CERT sucks. they know security, if only because they know about
much of the cracking activity on the net, via reports. however, they are
close-mouthed about it all. they don't offer solutions, don't require vendors
to produce solutions and don't tell the public about the problems until the
vendor says "ok, tell 'em now", which is usually FAR too late. why do you think
they lose most of their star players (such as the guy who wrote SATAN?)? A:
frustration.

there are MUCH better security sites/sources than CERT. e.g. security portal.

--
Aaron J. Seigo
Sys Admin

pgsql-general by date:

Previous
From: "Aaron J. Seigo"
Date:
Subject: Re: [GENERAL] How do I activate and change the postgres user's password?
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Another access control query