RE: [cobalt-users] [RaQ4] phpPgAdmin comments and suggestions

[Johan Pretorius <johan@xxxxxxxxxx>]

A-Team,

>>
The overview is a phpMyAdmin ported for Postgre and my
ticker is thinking I could do small fixes or even learn something
about Cobalt's Postgre DB on the 4i. I've got a RaQ to test it on,
but I also wanted to hear people's opinions and experiences with it.
What's the good, bad, and the ugly? Anyone?
>>

phpPgAdmin is great - it as good as phpMyAdmin.  However, your
biggest challenge will be to study and understand the PostgreSQL
authentication system (using the file pg_hba.conf as basis).

Some useful starting points:

[1] http://postgresql.bteg.net/users-lounge/index.html

[2] http://postgresql.bteg.net/users-lounge/docs/#7.1

And this is where you would like to start with the
authentication itself:
[3]
http://postgresql.bteg.net/users-lounge/docs/7.1/admin/client-authentication
.html

We have one client running against Postgres (the site is still
under some construction - pardon the pun) ->
http://www.construction-eastafrica.net/

We've made 100% sure the client cannot access the Cobalt
db.  Others suggested that one uses a seperate postmaster
process, but we haven't tried that one out yet.

Hope this helps,

Johan Pretorius

Ps - I'm sending you a direct copy - I presume you want to get
going on this asap ;-)

.
. http://host24.com
. All the PHP/mySQL hosting you'll ever need
.