Re: 8.1dev ssl broke?

FYI: I also followed the instructions per:

http://developer.postgresql.org/docs/postgres/ssl-tcp.html

Joshua D. Drake wrote:
> I pulled cvs today and performed the following:
> 
> ./configure --with-openssl --prefix=/tmp/pgsqldev
> make install
> cd /tmp/pgsqldev
> initdb --no-locale -D data -l data/serverlog
> 
> pg_hba.conf lines:
> 
> # "local" is for Unix domain socket connections only
> #local   all         all                               trust
> # IPv4 local connections:
> hostssl   all         all         127.0.0.1/32        trust
> # IPv6 local connections:
> host    all         all         ::1/128               trust
> 
> postgresql.conf
> 
> listen_addresses = 'localhost'  # what IP interface(s) to listen on;
>                                 # defaults to localhost, '*' = any
> port = 5432
> ssl = on
> 
> 
> When I try to connect I get:
> 
> 
> LOG:  redo record is at 0/34D73C; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 561; next OID: 16385
> LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> LOG:  database system is ready
> LOG:  transaction ID wrap limit is 2147484132, limited by database 
> "postgres"
> LOG:  invalid entry in file "/tmp/pgsqldev/data/pg_hba.conf" at line 73, 
> token "hostssl"
> FATAL:  missing or erroneous pg_hba.conf file
> HINT:  See server log for details.
> DEBUG:  forked new backend, pid=26717 socket=6
> DEBUG:  server process (PID 26717) exited with exit code 0
> 
> If I change the entries to:
> 
> # "local" is for Unix domain socket connections only
> #local   all         all                               trust
> # IPv4 local connections:
> host   all         all         127.0.0.1/32        trust
> # IPv6 local connections:
> host    all         all         ::1/128               trust
> 
> Everything works fine.
> 
> Sincerely,
> 
> Joshua D. Drake
> 
> 


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/