Received: (from news@localhost) by hub.org (8.9.3/8.9.3) id SAA08773 for pgsql-general@postgresql.org; Fri, 26 Nov 1999 18:13:00 -0500 (EST) (envelope-from news) X-Authentication-Warning: hub.org: news set sender to using -f Message-ID: <383F13FA.61B0A5CF@acrcorp.removethis.com> From: Matthew Leo X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.12-20 i686) X-Accept-Language: en MIME-Version: 1.0 X-Newsgroups: comp.databases.postgresql.questions Subject: Re: PostgreSQL References: <7vn13b$bov2@imsp212.netvigator.com> <381f33af.499056575@news.earthlink.net> <7voii8$eap5@imsp212.netvigator.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 31 Date: Fri, 26 Nov 1999 18:12:58 -0500 X-Complaints-To: abuse@mediaone.net X-Trace: wbnws01.ne.mediaone.net 943657978 24.218.54.77 (Fri, 26 Nov 1999 18:12:58 EST) Organization: Road Runner To: pgsql-questions@postgresql.org I'm figuring this stuff out for myself rightnow. Here's what I've got so far. Visit this location to obtain the win32 ODBC driver: http://www.insightdist.com/psqlodbc. If you've created your database, make sure you edit the file pg_hba.conf in your default database directory to include a line allowing connections from your windows machines over IP (assuming you have a network 192.168.0.*), for example: host all 192.168.0.0 255.255.255.0 trust to give completely unfettered access to everything, ignoring passwords. Obviously, this is probably more permissive than you really want to be! It's a start for config testing. Assuming this works, be a little less trusing, change the line to: host all 192.168.0.0 255.255.255.0 password pg_pwd This requires a password and looks into the file pg_pwd in your database directory for the password. You can run the command "pg_passwd pg_pwd" to set passwords in this file. That's as far as I've got. Other methods include kerberos, crypt (no plaintext password transmitted -- a good idea), and ident (the ident protocol -- don't know about this one). If anyone has any knowledge about integrating with NT domains that would be great. -Matt