Thread: pgadmin

pgadmin

From
"Raghav Infotech Ltd [Chennai]"
Date:
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,

Re: pgadmin

From
Alfonso Peniche
Date:
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,


Re: Re: pgadmin

From
DHSC Webmaster
Date:
I have successfully setup the driver on a win98 machine, but when
performing the same process on a win2000 machine, I get the following
error:
ODBC--call failed, Password authentication failed for user
'ADMINISTRATION' (#210)[Microsoft][ODBC Driver Manager] Connection not
open (#0)

I have tried repeatedly, re-entering the user and password in case of
typo error, but have had no success. I've even tried different settings
in 'options'.
Any suggestions?
Thanks, Bill MacArthur

Alfonso Peniche wrote:
>
> 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,

--
Bill MacArthur
Webmaster
DHS Club

Re: Re: pgadmin

From
Stefan Huber
Date:
At 10:15 2001-02-08 -0500, DHSC Webmaster wrote:
>I have successfully setup the driver on a win98 machine, but when
>performing the same process on a win2000 machine, I get the following
>error:
>ODBC--call failed, Password authentication failed for user
>'ADMINISTRATION' (#210)[Microsoft][ODBC Driver Manager] Connection not
>open (#0)


Are you yure, that you...
...started the postmaster with the -i option?
...have the correct settings in your pg_hba.conf?

Stefan