Received: from iteso.mx (iteso.mx [148.201.1.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f16GbVx10194 for ; Tue, 6 Feb 2001 11:37:31 -0500 (EST) (envelope-from alfonso@iteso.mx) Received: from iteso.mx (alfonso@[148.201.112.30]) by iteso.mx (8.11.1/8.11.1) with ESMTP id f16GbO785025 for ; Tue, 6 Feb 2001 10:37:24 -0600 (CST) (envelope-from alfonso@iteso.mx) Message-ID: <3A80283E.F4767534@iteso.mx> Date: Tue, 06 Feb 2001 10:37:18 -0600 From: Alfonso Peniche Organization: Iteso University X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.17 i686) X-Accept-Language: en MIME-Version: 1.0 CC: pgsql-admin@postgresql.org Subject: Re: pgadmin References: <000801c08b76$1d11c700$28bc09ca@sekhar> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/49 X-Sequence-Number: 649 What you have to do is: For every database you have in PostgreSQL you have to: 1.- Select ODBC Data Sources in the Control Panel 2.- Select the User DSN tab 3.- Click on 'Add...' 4.- Choose the ODBC Driver corresponding to PostgreSQL and click on 'Finish'. 5.- A Setup window will appear with the following: Data Source: Type the name you will identify your driver with (could be the name of your database) Description: (Optional) Anything that will make you remember what the database or connection is Database: Type your database's name (where you are going to connect). Server: Type your server name (where Postgres is installed) Port: If you use default values, leave 5432 as is, otherwiase type the Postgres Port you are using. Username: Type the name you will use to make the connection Password: Type the user's password NOTE 1: Remember, in order for this to work you have to have a Postgres username and password (since you need a user for unix, I would suggest, for security reasons, that you take advantage of this feature). NOTE 2: You have to modify your pg_hba.conf file so the connection privilege is 'password' (no quotes). I haven't been able to make it work with 'crypt'. I don't know if it's a bug or if it's meant to be that way or if it's just me (maybe someone from the ODBC area could help us out here) 6.- In the Options (Advanced) section (still in the Setup window) click on 'DataSources' 6.1.- A new window will appear. Make sure that the only boxes checked are Show Columns and Fake Index in the OID Options Section. If I didn't forget anything, this should work. Hope this helps. (If you have any question don't hesitate to ask). "Raghav Infotech Ltd [Chennai]" wrote: > We want to install the client at Windows machine. We had downloaded > the pgadmin and installed in in windows2000 machine through windows > installer. But we could not configure the DSN and get going. kindly > help by pointing further documentation Regards, T.G.Sekhar,Raghav > Infotech Limited,Chennai,India,