The FreeBSD Diary

The FreeBSD Diary (TM)

Providing practical examples since 1998

If you buy from Amazon USA, please support us by using this link.
[ HOME | TOPICS | INDEX | WEB RESOURCES | BOOKS | CONTRIBUTE | SEARCH | FEEDBACK | FAQ | FORUMS ]

 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Newer Topic  |  Older Topic 
 Windows GUI inteface to PostgreSQL
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,

Reply To This Message
 Forum List  |  Threaded View   Newer Topic  |  Older Topic 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.
How to get the most out of the forum

phorum.org