Re: [GENERAL] Client Authentication methods

2017-11-10 Thread Peter J. Holzer
On 2017-11-10 08:25:24 -0500, chiru r wrote: > I am trying to understand the Authentication method in pg_hba.conf file > (password & md5) in PostgreSQL database server.  > > I am assuming that the user provides the  connection string host/usser/ > password,then client will go and contact the DB se

Re: [GENERAL] Client Authentication methods

2017-11-10 Thread Berend Tober
chiru r wrote: Hi All, I am trying to understand the Authentication method in pg_hba.conf file (password & md5) in PostgreSQL database server. I am assuming that the user provides the connection string host/usser/password,then client will go and contact the DB server pg_hba.conf file in memo

[GENERAL] Client Authentication methods

2017-11-10 Thread chiru r
Hi All, I am trying to understand the Authentication method in pg_hba.conf file (password & md5) in PostgreSQL database server. I am assuming that the user provides the connection string host/usser/password,then client will go and contact the DB server pg_hba.conf file in memory without carrying

Re: [GENERAL] Client Authentication

2008-04-18 Thread Stefan Sturm
Hello, > try adding a subnet mask > host all username 0.0.0.0 0.0.0.0 md5 > or a cidr mask > host all username 0.0.0.0/0 md5 > > that's it. I don't know, why I only wrote 0.0.0.0... Thats cleary my fault. Thanks for all your help. Greetings, Urkman

Re: [GENERAL] Client Authentication

2008-04-17 Thread Klint Gore
Stefan Sturm wrote: Hello, I set up a PostgreSQL 8.3.1 Server on my Webserver( located somewhere in the web ). On my local Server I use the trust method to access the server. But on my Webserver I want to use an user with password to access the Server. So I did the following: I created a use

Re: [GENERAL] Client Authentication

2008-04-17 Thread A. Kretschmer
am Fri, dem 18.04.2008, um 8:41:17 +0200 mailte Stefan Sturm folgendes: > Hello, > > I set up a PostgreSQL 8.3.1 Server on my Webserver( located somewhere in the > web ). > On my local Server I use the trust method to access the server. But on my > Webserver I want to use an user with password t

[GENERAL] Client Authentication

2008-04-17 Thread Stefan Sturm
Hello, I set up a PostgreSQL 8.3.1 Server on my Webserver( located somewhere in the web ). On my local Server I use the trust method to access the server. But on my Webserver I want to use an user with password to access the Server. So I did the following: I created a user( as superuser ) with: c

Re: [GENERAL] Client authentication

2003-09-25 Thread Nigel J. Andrews
On Thu, 25 Sep 2003, Claudio Lapidus wrote: > Hello > > We need to deny access to the database for regular users, while allowing > access to admins and a variety of application scripts. > > If we use passwords, everything is fine while interactive, but could not > devise a way for scripts to han

[GENERAL] Client authentication

2003-09-25 Thread Claudio Lapidus
Hello We need to deny access to the database for regular users, while allowing access to admins and a variety of application scripts. If we use passwords, everything is fine while interactive, but could not devise a way for scripts to handle them. We also tried to set up ident authentication, bu