Re: 7.0.2 install doesn't read .conf files

Eugene Lee <eugene(at)anime(dot)net> writes:
> Note, no "-i" option. Instead, I added the line "tcpip_socket = yes"
> in the file /usr/local/pgsql/data/postgresql.conf to enable TCP/IP
> socket access. But the line in the config file doesn't work.

There is no such config file in 7.0.*. You must be reading the
development-sources documentation at postgresql.org. See the 7.0
docs included in your distribution (they're also on the website,
but you have to dig a little).

> However, instead of being denied outright, I can connect to the default
> port from the outside world.

By "connect" I suppose you mean you telnet to the port and type a few
random characters?

> In the logs, it shows up as an entry with
> a datetime stamp and a message "Invalid packet length". Is this normal
> PostgreSQL behavior?

That's about what I'd expect, since authorization checks aren't applied
until the would-be client has sent a connection-request packet.

If you want to prevent the connection from even reaching the postmaster,
I recommend messing around with your firewall's filters.

regards, tom lane