Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

Hi Arnaud: On Thu, Aug 25, 2016 at 4:35 PM, arnaud gaboury wrote: >> Are this all the contents of you pg_hba.conf? Note order matters, all >> non comment ( or at least the host ones ) need to be checked . > Here is the whole content: > 79 local thetradinghall mailman

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:28 PM, arnaud gaboury wrote: > On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich > wrote: >>>I entered this line in pg_hab.conf: >> Are you sure your file name is correct and it is really used by postgres? > I think so as another service (Postfix) is running and working.

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 5:50 PM, Francisco Olarte wrote: > Hi Arnaud: > > On Thu, Aug 25, 2016 at 4:35 PM, arnaud gaboury > wrote: >>> Are this all the contents of you pg_hba.conf? Note order matters, all >>> non comment ( or at least the host ones ) need to be checked . >> Here is the whole cont

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 5:43 PM, Francisco Olarte wrote: > On Thu, Aug 25, 2016 at 4:28 PM, arnaud gaboury > wrote: >> On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich >> wrote: I entered this line in pg_hab.conf: >>> Are you sure your file name is correct and it is really used by postgres?

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 5:26 PM, Joshua D. Drake wrote: > On 08/25/2016 07:44 AM, arnaud gaboury wrote: >> >> On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake >> wrote: > > >>> Did you reload PostgreSQL? That is how you tell PostgreSQL to reread the >>> pg_hba.conf. >>> >>> FTR: I have deployed M

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On 08/25/2016 07:44 AM, arnaud gaboury wrote: On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake wrote: Did you reload PostgreSQL? That is how you tell PostgreSQL to reread the pg_hba.conf. FTR: I have deployed Mattermost and it works wonderfully. The issue is solved (see my replies). By any

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

% psql --host=127.0.0.1/32 --dbname=mattermost --username=mmuser psql: could not translate host name "127.0.0.1/32" to address: Name or service not known % psql --host=127.0.0.1/24 --dbname=mat

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:27 PM, Melvin Davidson wrote: > > > On Thu, Aug 25, 2016 at 10:18 AM, arnaud gaboury > wrote: > >> I am deploying mattermost on my machine following their documentation[0]. >> >> My machine network settings: >> -- >> $ ip a >> 1: lo: mtu

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On 08/25/2016 07:18 AM, arnaud gaboury wrote: I am deploying mattermost on my machine following their documentation[0]. There is a public IP with a domain name (http works OK). I entered this line in pg_hab.conf: I assume you mean pg_hba.conf -- host matte

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:38 PM, Joshua D. Drake wrote: > On 08/25/2016 07:18 AM, arnaud gaboury wrote: >> >> I am deploying mattermost on my machine following their documentation[0]. > > >> There is a public IP with a domain name (http works OK). >> >> I entered this line in pg_hab.conf: > > > I

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:37 PM, Ilya Kazakevich wrote: > > % psql --host=127.0.0.1/32 --dbname=mattermost --username=mmuser > psql: could not translate host name "127.0.0.1/32" to address: Name or > service not known > % psql --host=127.0.0.1/24 --dbname=mattermost --username=mmuser > psql: could

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:29 PM, Francisco Olarte wrote: > Hi Arnaud: > On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury > wrote: >> There is a public IP with a domain name (http works OK). > Nice to know, but does not matter if all you use is 127.0.0.1 > > >> I entered this line in pg_hab.conf: >

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:32 PM, Tom Lane wrote: > arnaud gaboury writes: >> I entered this line in pg_hab.conf: >> -- >> host mattermost mmuser 127.0.0.1 md5 > >> What am I doing wrong? > > Looking in the postmaster log for complaints about pg_

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 10:28 AM, arnaud gaboury wrote: > On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich > wrote: > >>I entered this line in pg_hab.conf: > > Are you sure your file name is correct and it is really used by postgres? > > I think so as another service (Postfix) is running and wor

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

>How can I verify ? Can you connect as postgres (superuser)? If yes, connect and type "show hba_file;" If no, try adding "local all postgres peer" or even "local all postgres trust" to this file and restart postgres. Check again. -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

arnaud gaboury writes: > I entered this line in pg_hab.conf: > -- > host mattermost mmuser 127.0.0.1 md5 > What am I doing wrong? Looking in the postmaster log for complaints about pg_hba.conf would probably have helped you diagnose this. But

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

Hi Arnaud: On Thu, Aug 25, 2016 at 4:18 PM, arnaud gaboury wrote: > There is a public IP with a domain name (http works OK). Nice to know, but does not matter if all you use is 127.0.0.1 > I entered this line in pg_hab.conf: Have you checked the filename? you are saying HAB, but it is HBA ( Hos

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 10:18 AM, arnaud gaboury wrote: > I am deploying mattermost on my machine following their documentation[0]. > > My machine network settings: > -- > $ ip a > 1: lo: mtu 65536 qdisc noqueue state UNKNOWN > group default qlen 1 > link/loop

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

On Thu, Aug 25, 2016 at 4:26 PM, Ilya Kazakevich wrote: >>I entered this line in pg_hab.conf: > Are you sure your file name is correct and it is really used by postgres? I think so as another service (Postfix) is running and working. How can I verify ? > > > Ilya Kazakevich > > JetBrains > http:

Re: [GENERAL] pg_hba.conf : bad entry for ADDRESS

>I entered this line in pg_hab.conf: Are you sure your file name is correct and it is really used by postgres? Ilya Kazakevich JetBrains http://www.jetbrains.com The Drive to Develop -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On Wed, Jul 8, 2015 at 3:55 AM, Karsten Hilbert wrote: > On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown wrote: > > > >>> >at a bare minimum, a database administrator needs to create database > > >>> >roles (users) and databases for an app like yours. > > >>> > > >> The admin don't need to

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On Tue, Jul 07, 2015 at 06:57:45AM -0500, John McKown wrote: > >>> >at a bare minimum, a database administrator needs to create database > >>> >roles (users) and databases for an app like yours. > >>> > >> The admin don't need to create the db. It is done by the application > >> (sqlalchemy-utils

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On Tue, Jul 7, 2015 at 12:10 AM, John R Pierce wrote: > On 7/6/2015 9:55 PM, c.bu...@posteo.jp wrote: > >> On 2015-07-05 22:16 John R Pierce wrote: >> >>> >at a bare minimum, a database administrator needs to create database >>> >roles (users) and databases for an app like yours. >>> >> The admi

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On 7/6/2015 9:55 PM, c.bu...@posteo.jp wrote: On 2015-07-05 22:16 John R Pierce wrote: >at a bare minimum, a database administrator needs to create database >roles (users) and databases for an app like yours. The admin don't need to create the db. It is done by the application (sqlalchemy-util

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On 2015-07-05 22:16 John R Pierce wrote: > at a bare minimum, a database administrator needs to create database > roles (users) and databases for an app like yours. The admin don't need to create the db. It is done by the application (sqlalchemy-utils on Python3) itself. But I see. I will go ba

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On 07/05/2015 09:43 PM, c.bu...@posteo.jp wrote: On 2015-07-05 15:13 Jan de Visser wrote: You could set up a whole new server with a different $PGDATA on a different port. I (and the user) don't want to setup anything - that is the point. Then what you want is an embedded database, in other

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

Jan de Visser wrote: On July 6, 2015 06:43:53 AM c.bu...@posteo.jp wrote: On 2015-07-05 15:13 Jan de Visser wrote: You could set up a whole new server with a different $PGDATA on a different port. I (and the user) don't want to setup anything - that is the point. Well, you don't have to set

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On July 6, 2015 06:43:53 AM c.bu...@posteo.jp wrote: > On 2015-07-05 15:13 Jan de Visser wrote: > > You could set up a whole new server with a different $PGDATA on a > > different port. > > I (and the user) don't want to setup anything - that is the point. Well, you don't have to setup anything.

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On 7/5/2015 9:43 PM, c.bu...@posteo.jp wrote: But isn't there a way to use PostgreSQL without that setup and configuration things? no, not really, as its a generic database server meant to be used by multiple applications across a network, with a wide range of configuration options, plugins a

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On 2015-07-05 15:13 Jan de Visser wrote: > You could set up a whole new server with a different $PGDATA on a > different port. I (and the user) don't want to setup anything - that is the point. > What I'm wondering though is what made you decide to use pgsql for > your project? It seems to me th

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On July 5, 2015 08:58:17 PM c.bu...@posteo.jp wrote: > On 2015-07-05 15:11 Charles Clavadetscher > > wrote: > > I am not really an expert, but from your description I guess that you > > assume an existing PostgreSQL installation on your customers' server. > > The application is a simple open sou

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On 7/5/2015 3:15 AM, c.bu...@posteo.jp wrote: These are the modification I have to do to make my application run with the connetion string "postgres://puser@localhost/FoobarTest". The settings are about the /etc/postgresql/9.3/main/pg_hba.conf file. There I change this line hostall

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

On 2015-07-05 15:11 Charles Clavadetscher wrote: > I am not really an expert, but from your description I guess that you > assume an existing PostgreSQL installation on your customers' server. The application is a simple open source using a local PostgreSQL database. The customer is just any use

Re: [GENERAL] [pg_hba.conf] publish own Python application using PostgreSQL

Hi I am not really an expert, but from your description I guess that you assume an existing PostgreSQL installation on your customers' server. If that is the case you probably won't get around giving instructions to your customer and let them do the change. I would not like to install applica

Re: [GENERAL] pg_hba.conf analysis tool

>We are in the process of talking about this: >    http://www.postgresql.org/message-id/86fvnm5t44@jerry.enova.com > I know of no tool currently available. Thank you, for the reply. I think, my case might be a little bit different. I am working with several clusters and I find sometimes pg_hb

Re: [GENERAL] pg_hba.conf analysis tool

On Fri, Feb 14, 2014 at 07:28:38AM -0800, salah jubeh wrote: > Hello, > > I am looking for a tool that could help me in analyzing the pg_hab.conf file. > For example , detecting duplicates, unused entries, and overlaping entries. We are in the process of talking about this: http://www.po

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 05:03 PM, John R Pierce wrote: On 10/16/2013 4:56 PM, Adrian Klaver wrote: I have never seen this in a pg_hba,conf. Of course I don't get out much:) Not sure of its purpose. It seems to be in the place of the IP mask. i think thats an email program artifact,

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 4:56 PM, Adrian Klaver wrote: I have never seen this in a pg_hba,conf. Of course I don't get out much:) Not sure of its purpose. It seems to be in the place of the IP mask. i think thats an email program artifact, trying to treat an IP as a URL -- john r p

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 04:20 PM, Bob Jolliffe wrote: CCing the list so more eyes can see thid. Hi Adrian Sure. Here are 6 versions of complete pg_hba.conf files: 1. This works (note the auth method is peer not ident. my first post had an error). Complete one line pg_hba.conf file: local all postg

Re: [GENERAL] pg_hba.conf broken after cluster upgrade

On 10/16/2013 09:46 AM, Bob Jolliffe wrote: Hello I just upgraded my postgresql server from 8.4 to 9.2 on ubuntu linux 12.04. I installed the new version then used pg_upgrade to upgrade and replicate the cluster from the old server to the new. Everything appears to have worked well except that

Re: [GENERAL] pg_hba.conf directory?

On 11/09/2012 04:49 AM, Matt Zagrabelny wrote: > Hello, > > I've searched the mailing list archives and google regarding using a > directory to contain pg_hba.conf snippets. Does such a feature exist > for any version of PG? Oh, by the way; proposals are currently being discussed on pgsql-hackers a

Re: [GENERAL] pg_hba.conf directory?

On 11/09/2012 04:49 AM, Matt Zagrabelny wrote: > Hello, > > I've searched the mailing list archives and google regarding using a > directory to contain pg_hba.conf snippets. Does such a feature exist > for any version of PG? If I understand you correctly, you want a `pg_hba.conf.d` where PostgreSQL

Re: [GENERAL] pg_hba.conf

In response to quickinfo quickinfo : > Dear all, > > I am using postgres. when I try to connect to the database it is showing me > following error. Please look into that and help me out. > > an error occurred: > > FATAL: no pg_hba.conf entry for host "127.0.0.1", user "postgres", database > "tem

Re: [GENERAL] pg_hba.conf

with the old configuration file from the older version of Postgres. Cheers, Pete From: Scott Mead To: jkun...@laurcat.com Cc: postgres help Date: 28/04/2010 18:41 Subject: Re: [GENERAL] pg_hba.conf Sent by:pgsql-general-ow...@postgresql.org On Tue, Apr 27, 2010

Re: [GENERAL] pg_hba.conf

On Tue, Apr 27, 2010 at 6:42 AM, wrote: > I am putting up a new server on version 8.4.3. I copied pg_hba.conf > from a running 8.3.6 system, changing only the public IP address for the > local machine. > > I get the error: > FATAL: no pg_hba.conf entry for host "209.159.145.248", user "postgres"

Re: [GENERAL] pg_hba.conf

ed list of addresses; # defaults to 'localhost', '*' = all # (change requires restart) port = 5432 > Date: Tue, 27 Apr 2010 21:08:31 +0900 > From: ketan...@ashisuto.co.jp > To: pgsql-general@postgresql.org > Subject:

Re: [GENERAL] pg_hba.conf

Hi >Would there be a line earlier in the file that matches and is preventing >a connection? At first, I think so too. But if there is a line earlier in the file ,we get following error. psql: could not connect to server: C

Re: [GENERAL] pg_hba.conf

On 27/04/2010 11:42, jkun...@laurcat.com wrote: > I am putting up a new server on version 8.4.3. I copied pg_hba.conf > from a running 8.3.6 system, changing only the public IP address for the > local machine. > > I get the error: > FATAL: no pg_hba.conf entry for host "209.159.145.248", user "po

Re: [GENERAL] pg_hba.conf - Allow All Connections Over TCP/IP Networks

Wang, Mary Y wrote: Hi, I'd like to allow all connections over TCP/IP networks. So could I just add the following line to the pg_hba.conf in the $PGDATA directory? "host all * trust" The database server is located inside a firewall. host all all 0.0.0.0/0 trust or

Re: [GENERAL] pg_hba.conf use hostname not IP

Bessette-Halsema, Dominique E. wrote: > Is there a way to use the hostname that is in the /etc/hosts file > instead of the IP address in pg_hba.conf No. It has been discussed but we've not found a good way in which it should work. -- Alvaro Herrerahttp://www.Com

Re: [GENERAL] pg_hba.conf - md5

Vince wrote: I want to access by postgre db over the internet. My pg_hba.conf if setup to do this: hostall all 0.0.0.0/0md5 Now, what I don't understand is how does the "md5" effect things? If I connect via php: $db = pg_connect('host=xx.xx.xx.xx port=5433 dbname=MYDB u

Re: [GENERAL] pg_hba.conf - md5

On Sat, Jun 09, 2007 at 02:43:06AM -0700, Vince wrote: > I want to access by postgre db over the internet. My pg_hba.conf if > setup to do this: > hostall all 0.0.0.0/0 md5 > > Now, what I don't understand is how does the "md5" effect things? It causes the password exchan

Re: [GENERAL] pg_hba.conf

Tom Lane wrote: Tom Allison <[EMAIL PROTECTED]> writes: host allall127.0.0.1/32 md5 hostsslallall192.168.0.1/24 md5 ^^ That needs to be 192.168.0.0/24 ... as is, it won't match anything. But I have a localhost client that

Re: [GENERAL] pg_hba.conf

Tom Allison <[EMAIL PROTECTED]> writes: > host allall127.0.0.1/32 md5 > hostsslallall192.168.0.1/24 md5 ^^ That needs to be 192.168.0.0/24 ... as is, it won't match anything. > But I have a localhost client that can't log in b

Re: [GENERAL] pg_hba.conf

Tom Allison wrote: Ran into a mystery that I can't seem to figure out I want to authenticate using SSL for all external IP addresses that I have in my subnet. I also want to be able to authenticate via non-SSL for localhost (not unix socket). I thought something like this would work:

Re: [GENERAL] pg_hba.conf errors

"Bradley W. Dutton" <[EMAIL PROTECTED]> writes: > Does anyone know if there were any updates to this issue? > http://archives.postgresql.org/pgsql-hackers/2003-06/msg00195.php That was fixed in 7.4, see sslmode connection option and PGSSLMODE environment variable. regards,

Re: [GENERAL] Pg_hba.conf issues

On 15 Feb 2006 at 15:44, Colin Shreffler wrote: > host all all 192.168.0.0 255.255.255.0 trust Is there any other, more restrictive, line *above* this one in the file? The order of entries does seem to make a difference. --Ray. --

Re: [GENERAL] Pg_hba.conf issues

Colin Shreffler <[EMAIL PROTECTED]> writes: > I have tried entering the following record in the file, but it does not > grant me access. (1) did you remember to sighup the postmaster after changing the file? (2) what error message do you get *exactly*? What shows up in the postmaster log file?

Re: [GENERAL] pg_hba.conf changes without restarting postmaster

If you launch your progress server at startup (in init.d), you only have to type : # service postgresql reload It works fine. Luc - Original Message - From: "Christopher Browne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 31, 2004 3:09 AM

Re: [GENERAL] PG_HBA.conf still keeps complaining. I've done all I could imagine.

[EMAIL PROTECTED] (Liza) writes: > When I try to connect to the postgresql server in pgmanage, or through > an ODBC from other windows machines I get a message: > "missing or erroneous pg_hba.conf file" > Here is my pg_hba.conf: > local all trust > host 10.1.9

Re: [GENERAL] pg_hba.conf change in 7.4

Seum-Lim Gan wrote: > Hi Bruce, > > I tried to newly compiled 7.4 with HAVE_IPV6 commented out > in /src/include/pg_config.h. > > After that I tried psql: > > psql -U scncraft -h localhost > psql: FATAL: no pg_hba.conf entry for host "::1", user "scncraft", > database "A" > > This happens the

Re: [GENERAL] pg_hba.conf change in 7.4

Yes, I am not suspecting that there is something strange with that Solaris installation. Maybe everything is IPv6. We certainly have lots of Solaris users. Are all Solaris connections coming in as IPv6? That seems impossible because we didn't support IPv6 in PostgreSQL 7.3 and it worked fine.

Re: [GENERAL] pg_hba.conf change in 7.4

Hello, Also solaris has an option to not use IPV6 at least with Solaris 9. When we installed it it asked us if we wanted IPV6 support. We just said no. Sincerely, Joshua D. Drake Seum-Lim Gan wrote: Hi Bruce, Thanks for the recommendation. I will edit the pg_config.h file and comment out th

Re: [GENERAL] pg_hba.conf change in 7.4

Hi Bruce, I tried to newly compiled 7.4 with HAVE_IPV6 commented out in /src/include/pg_config.h. After that I tried psql: psql -U scncraft -h localhost psql: FATAL: no pg_hba.conf entry for host "::1", user "scncraft", database "A" This happens the same way whether I have this line in pg_hba.

Re: [GENERAL] pg_hba.conf change in 7.4

Hi Bruce, I am rebuilding now and noticed some error that I may have missed since the last time I build 7.4. Essentially the postmaster, bin, lib have been built and server is able to start and I am able to create a new DB and etc. Will let you know if the commenting out the HAVE_IPV6 will work. M

Re: [GENERAL] pg_hba.conf change in 7.4

Title: Re: [GENERAL] pg_hba.conf change in 7.4 Hi Bruce, I wonder if there is any recommendation to this ? Is there a way to configure PostgreSQL to not use IPv6 ? We are also wonder if there is a version of Ident server that the PostgreSQL community knows that will work with IPv6. Thanks

Re: [GENERAL] pg_hba.conf problem

On Nov 30, 2003, at 21:01, Tom Lane wrote: The only other idea I can think of is he's editing the wrong pg_hba.conf file; we've seen a couple of people make that mistake. (David, the right pg_hba.conf file is the one in the $PGDATA directory. If you don't see a postmaster.pid file in the same d

Re: [GENERAL] pg_hba.conf change in 7.4

Hi Bruce, We are using Sun Solaris 9 on Sparc. uname -a : SunOS test01 5.9 Generic_112233-04 sun4u sparc SUNW,Ultra-80 Gan At 12:29 pm -0500 2003/11/20, Bruce Momjian wrote: I think what happens is that when we listen on IPv4 and IPv6, that all connections get IPv6. What OS are you using?

Re: [GENERAL] pg_hba.conf change in 7.4

I think what happens is that when we listen on IPv4 and IPv6, that all connections get IPv6. What OS are you using? --- Seum-Lim Gan wrote: > Hi Bruce, > > Thanks for the info. > I captured the netstat output below. > > L

Re: [GENERAL] pg_hba.conf change in 7.4

Hi Bruce, Thanks for the info. I captured the netstat output below. Looks like there is a bunch of IPv4 being used. Any idea how this can be resolved ? Thanks. Gan UDP: IPv6 Local Address Remote Address State If - --

Re: [GENERAL] pg_hba.conf change in 7.4

Seum-Lim Gan wrote: > Hi, > > In 7.4, I noticed there is this ::1 and : (x8 of them) > for IPv6. > > I looked at the documentation and there is nothing that says > what the ::1 is for. The ::1 is a IPv6 shorthand for 127.0.0.1 (localhost). > Commenting out that line will prevent access to P

Re: [GENERAL] pg_hba.conf

On Tue, 30 Sep 2003, Tom Lane wrote: > "Nigel J. Andrews" <[EMAIL PROTECTED]> writes: > > In 7.3 and less ssl connections fail if a host line matches before the hostssl > > line. At least I think that's the situation, there is definitely something > > there that will make a ssl connection get reje

Re: [GENERAL] pg_hba.conf

"Nigel J. Andrews" <[EMAIL PROTECTED]> writes: > In 7.3 and less ssl connections fail if a host line matches before the hostssl > line. At least I think that's the situation, there is definitely something > there that will make a ssl connection get rejected even if there is an > appropiate entry in

Re: [GENERAL] pg_hba.conf

On Tue, 30 Sep 2003, Angel Todorov wrote: > Hello, sometimes I get a strange error from postgresql when I try to > connect using ssl to the server: > > LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token > "hostssl" > FATAL: Missing or erroneous pg_hba.conf file, see postmaste

Re: [GENERAL] pg_hba.conf

Angel Todorov writes: > LOG: parse_hba: invalid syntax in pg_hba.conf file at line 46, token > "hostssl" It looks as though your server was not compiled with SSL support. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 8: e

Re: [GENERAL] pg_hba.conf with the "password" auth failed to work sometimes...

matthew wong <[EMAIL PROTECTED]> writes: > i found sometimes when i setup the pg_hba.conf > to restrict to only allow a client from certain > ip to access a database with password auth, but > i found even i give an invalid password, the > client still can connect to t

Re: [GENERAL] pg_hba.conf and crypt/password

On Sat, Mar 31, 2001 at 10:31:36AM +0200, Peter Eisentraut wrote: > > what i want is for the pg_shadow file to contain encrypted passwords like > > /etc/passwd, and for the server to encrypt the plain text password handed > > to it and compare with the crypto-gunge in pg_shadow. > > This is not p

Re: [GENERAL] pg_hba.conf and crypt/password

Jim Mercer writes: > i seem to recall setting this up before, but now i can't seem to > get passwords working the way i want. > > i'm running 7.0.3 on FreeBSD 4.3-RC. > > i've set the entry in pg_hba.conf to both "crypt" and "password". > > i've used "ALTER USER pgsql WITH PASSWORD 'test'; > > re

Re: [GENERAL] pg_hba.conf and crypt/password

Jim Mercer wrote: > >i seem to recall setting this up before, but now i can't seem to >get passwords working the way i want. > >i'm running 7.0.3 on FreeBSD 4.3-RC. > >i've set the entry in pg_hba.conf to both "crypt" and "password". > >i've used "ALTER USER pgsql WITH PASSWORD '

Re: [GENERAL] pg_hba.conf edit

On Wed, 17 Jan 2001, Uro Gruber wrote: > I want to know how to edit this file. Because is only for reading. Is > there any program to edit this. For now i chmod it to 600 > end edit with my editor. That's the way you are supposed to do it! Just make sure you make it read-only after you are done

Re: [GENERAL] pg_hba.conf

"Tamsin" <[EMAIL PROTECTED]> writes: > I'm trying to sort out security on my db, configuring pg_hba.conf etc. I > just wanted to check that this in't possible - I want my postgres linux user > to be able to connect to the database without a password, but I don't want > other users logged on to th

Re: [GENERAL] pg_hba.conf and password/crypt authorization

On Tue, 30 May 2000, Dana Eckart wrote: > Things work fine with the authorization type in pg_hba.conf set to "trust". > However, when I try to use either "crypt" or "password" psql fails to > authenticate either the postgresql super-user (mylocal in my case) or any > other non-privelegded user.

Re: [GENERAL] pg_hba.conf and crypt

Louis Zirkel III wrote: >I'm having trouble understanding how to get the crypt option working in >the pg_hba.conf file. I can get cleartext passwords to be passed and they >work just fine, but I cannot figure out how in the heck to get the crypt >option working. I've looked through the F