pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alfonso Peniche <alfonso@iteso.mx>
Cc: pgsql-admin@postgresql.org
Subject: Re: pgadmin
Date: Tue, 06 Feb 2001 10:37:18 -0600
Message-ID: <3A80283E.F4767534@iteso.mx> (raw)
References: <000801c08b76$1d11c700$28bc09ca@sekhar>

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,




view thread (9+ messages)  latest in thread

Message-ID: <3A80283E.F4767534@iteso.mx>
Permalink:  ../3A80283E.F4767534@iteso.mx/
Also on:    postgresql.org/message-id/3A80283E.F4767534@iteso.mx

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: alfonso@iteso.mx
  Subject: Re: pgadmin
  In-Reply-To: <3A80283E.F4767534@iteso.mx>
  References: <000801c08b76$1d11c700$28bc09ca@sekhar> <3A80283E.F4767534@iteso.mx>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox