Re: Failing tcp/ip connection

>> My pg_hba.conf looks like this (at least the lines that aren't
>> (/var/lib/pgsql). The third line is not necessairy as I understand. I
>> ################################################################
>> local all crypt
>> host all 127.0.0.1 255.255.255.255 crypt
>> host all 192.168.0.249 255.255.255.255 crypt
>> host all 192.168.0.0 255.255.255.0 crypt
>> ################################################################
>
> 1. Make sure that you are, in fact, accessing the pgsql/data/ directory
> that you think you are.

That's the point I am most unsure about. I don't actually know where to
place the file. My book about postgresql only states to put in the data
directory...

nyffeltrach:/var/lib/pgsql # l
total 56
drwx------ 6 postgres postgres 4096 Apr 11 23:09 ./
drwxr-xr-x 31 root root 4096 Apr 12 03:00 ../
-rw------- 1 postgres daemon 185 Apr 10 23:53 .bash_history
-rw------- 1 postgres daemon 4 Apr 6 12:23 PG_VERSION
drwx------ 4 postgres daemon 4096 Apr 6 12:23 base/
drwx------ 2 postgres daemon 4096 Apr 11 23:09 global/
drwx------ 2 postgres daemon 4096 Apr 6 12:23 pg_clog/
lrwxrwxrwx 1 root root 27 Apr 11 23:08 pg_hba.conf ->
/root/pg_config/pg_hba.conf
-rw------- 1 postgres daemon 1250 Apr 6 12:23 pg_ident.conf
drwx------ 2 postgres daemon 4096 Apr 6 12:23 pg_xlog/
-rw------- 1 postgres postgres 3844 Mar 13 22:08 postgresql.conf
-rw------- 1 postgres daemon 48 Apr 11 23:09 postmaster.opts
-rw------- 1 postgres daemon 41 Apr 11 23:09 postmaster.pid
-r--r--r-- 1 root root 1204 Apr 11 07:47 server.crt
-r--r--r-- 1 root root 887 Apr 11 07:47 server.key

BTW: I also put it physically in this directory as well as into the bin
directory of postgres

> 2. Make sure that your startup script isn't accessing an alternate
> pg_hba.conf directory.

Below part of the output of ps ax
12833 ? S 0:00 su - postgres -c
/opt/pgsql/bin/postmaster -D /var/lib/pgsql
12834 ? S 0:00 -su -c
/opt/pgsql/bin/postmaster -D /var/lib/pgsql
12843 ? S 0:00 /opt/pgsql/bin/postmaster -D /var/lib/pgsql

The script is
su - postgres \
-c "/opt/pgsql/bin/postmaster \
-D /var/lib/pgsql \
1>> /var/log/postgres/postgreSQL.err \
2>> /var/log/postgres/postgreSQL.log" &

> 3. Have you restarted Postmaster since you made the changes to
> pg_hba.conf? Sometimes that's required.

Yepp.

Hell, it was a permission problem. Links don't work and when I copied
the file to the data directory I did it as root (I was trying to have
the configs at a central point such that I would not loose it too
easily) and forgot to change the owner...

Thx

Thiemo

--
Thiemo Kellner
Tösstalstrasse 146
CH-8400 Winterthur