pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgadmin
9+ messages / 8 participants
[nested] [flat]

* pgadmin
@ 2001-01-31 11:08 Raghav  Infotech Ltd [Chennai] <raghavinfo@eth.net>
  2001-02-06 16:37 ` Re: pgadmin Alfonso Peniche <alfonso@iteso.mx>
  0 siblings, 1 reply; 9+ messages in thread

From: Raghav Infotech Ltd [Chennai] @ 2001-01-31 11:08 UTC (permalink / raw)
  To: pgsql-admin

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,

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pgadmin
  2001-01-31 11:08 pgadmin Raghav  Infotech Ltd [Chennai] <raghavinfo@eth.net>
@ 2001-02-06 16:37 ` Alfonso Peniche <alfonso@iteso.mx>
  2001-02-08 15:15   ` Re: Re: pgadmin DHSC Webmaster <webmaster@dhs-club.com>
  2001-02-09 10:34   ` Re: Re: pgadmin Stefan Huber <schweinsaug@crosswinds.net>
  0 siblings, 2 replies; 9+ messages in thread

From: Alfonso Peniche @ 2001-02-06 16:37 UTC (permalink / raw)
  To: ; +Cc: pgsql-admin

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,




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Re: pgadmin
  2001-01-31 11:08 pgadmin Raghav  Infotech Ltd [Chennai] <raghavinfo@eth.net>
  2001-02-06 16:37 ` Re: pgadmin Alfonso Peniche <alfonso@iteso.mx>
@ 2001-02-08 15:15   ` DHSC Webmaster <webmaster@dhs-club.com>
  1 sibling, 0 replies; 9+ messages in thread

From: DHSC Webmaster @ 2001-02-08 15:15 UTC (permalink / raw)
  To: Alfonso Peniche <alfonso@iteso.mx>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: Re: pgadmin
  2001-01-31 11:08 pgadmin Raghav  Infotech Ltd [Chennai] <raghavinfo@eth.net>
  2001-02-06 16:37 ` Re: pgadmin Alfonso Peniche <alfonso@iteso.mx>
@ 2001-02-09 10:34   ` Stefan Huber <schweinsaug@crosswinds.net>
  1 sibling, 0 replies; 9+ messages in thread

From: Stefan Huber @ 2001-02-09 10:34 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* pgAdmin
@ 2003-11-02 09:02 Ganesan Kanavathy <ganesh@magnusquest.com>
  2003-11-02 11:47 ` Re: pgAdmin Ganesan Kanavathy <ganesh@magnusquest.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Ganesan Kanavathy @ 2003-11-02 09:02 UTC (permalink / raw)
  To: pgsql-admin; pgsql-sql@postgresql.org

How do I uninstall pgAdmin III? Please help
 
Regards,
Ganesan
 

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pgAdmin
  2003-11-02 09:02 pgAdmin Ganesan Kanavathy <ganesh@magnusquest.com>
@ 2003-11-02 11:47 ` Ganesan Kanavathy <ganesh@magnusquest.com>
  2003-11-02 11:53   ` Re: pgAdmin Mailing List <list@1006.org>
  0 siblings, 1 reply; 9+ messages in thread

From: Ganesan Kanavathy @ 2003-11-02 11:47 UTC (permalink / raw)
  To: pgsql-admin; pgsql-sql@postgresql.org; 'Mailing List' <list@1006.org>

pgAdmin is installed on linux redhat 8.
 
Regards,
Ganesan
 
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Ganesan Kanavathy
Sent: Sunday, November 02, 2003 17:03
To: pgsql-admin@postgresql.org; pgsql-sql@postgresql.org
Subject: [ADMIN] pgAdmin
 
How do I uninstall pgAdmin III? Please help
 
Regards,
Ganesan
 

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pgAdmin
  2003-11-02 09:02 pgAdmin Ganesan Kanavathy <ganesh@magnusquest.com>
  2003-11-02 11:47 ` Re: pgAdmin Ganesan Kanavathy <ganesh@magnusquest.com>
@ 2003-11-02 11:53   ` Mailing List <list@1006.org>
  0 siblings, 0 replies; 9+ messages in thread

From: Mailing List @ 2003-11-02 11:53 UTC (permalink / raw)
  To: pgsql-admin; +Cc: ganesh@magnusquest.com


> > How do I uninstall pgAdmin III? Please help
> pgAdmin is installed on linux redhat 8.

If you used rpm (redhat package manager) to install it, you can
uninstall it with:

  rpm -e pgadmin3

Bye, Chris.






^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* pgadmin
@ 2005-05-11 20:30 Ing. Jhon Carrillo <jdigital@cantv.net>
  2005-05-11 20:51 ` Re: pgadmin Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 9+ messages in thread

From: Ing. Jhon Carrillo @ 2005-05-11 20:30 UTC (permalink / raw)
  To: pgsql-admin

I need  when the users are conected to pgadmin  only have  access to their databases (owners) and not entry to another databases when they aren't owners.

thanks.

^ permalink  raw  reply  [nested|flat] 9+ messages in thread

* Re: pgadmin
  2005-05-11 20:30 pgadmin Ing. Jhon Carrillo <jdigital@cantv.net>
@ 2005-05-11 20:51 ` Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 9+ messages in thread

From: Scott Marlowe @ 2005-05-11 20:51 UTC (permalink / raw)
  To: Ing. Jhon Carrillo <jdigital@cantv.net>; +Cc: pgsql-admin

On Wed, 2005-05-11 at 15:30, Ing. Jhon Carrillo wrote:
> I need  when the users are conected to pgadmin  only have  access to
> their databases (owners) and not entry to another databases when they
> aren't owners.
>  
> thanks.

Look here:

http://www.postgresql.org/docs/8.0/static/client-authentication.html#AUTH-PG-HBA-CONF

and look specifically at the entry under database / sameuser



^ permalink  raw  reply  [nested|flat] 9+ messages in thread


end of thread, other threads:[~2005-05-11 20:51 UTC | newest]

Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-31 11:08 pgadmin Raghav  Infotech Ltd [Chennai] <raghavinfo@eth.net>
2001-02-06 16:37 ` Alfonso Peniche <alfonso@iteso.mx>
2001-02-08 15:15   ` DHSC Webmaster <webmaster@dhs-club.com>
2001-02-09 10:34   ` Stefan Huber <schweinsaug@crosswinds.net>
2003-11-02 09:02 pgAdmin Ganesan Kanavathy <ganesh@magnusquest.com>
2003-11-02 11:47 ` Re: pgAdmin Ganesan Kanavathy <ganesh@magnusquest.com>
2003-11-02 11:53   ` Re: pgAdmin Mailing List <list@1006.org>
2005-05-11 20:30 pgadmin Ing. Jhon Carrillo <jdigital@cantv.net>
2005-05-11 20:51 ` Scott Marlowe <smarlowe@g2switchworks.com>

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