Author: Casey Duncan
Date: 28-10-01 18:49
(posted by Dan Langille)
The ZEOS interface is quite handy and I use it quite a lot when sitting
behind NT. You do have to modify pg_hba.conf to get it (or any network
access to the database, like ODBC) to work.
Digging....
You want to edit /usr/local/pgsql/data/pg_hba.conf (or wherever PG_DATA
points to)
add the line:
host all <your subnet> <your netmask> password passwd
Then use the pg_passwd utility to create the passwd file like so:
in /usr/local/pgsql/data execute: pg_passwd passwd
enter the username and password for the account. This should be the same as
the database account you want to access the database with. You can also use
other authentication methods such as Kerberos.
more info:
http://www.postgresql.org/users-lounge/docs/7.0/user/app-pg-passwd.htm
http://www.postgresql.org/users-lounge/docs/7.0/admin/security.htm
There are also some other tools, pgtksh, pgaccess and pgadmin that I have
not used but might be worth looking into.
Happy daemonizing,
|
|
