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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
