Re: [cobalt-users] Cannot connect DSN to PostgreSQL

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Wednesday 12 February 2003 18:04, Jason Goodridge wrote:
> Thanks Gerald
>
> There is just a couple things I still do not understand:
>
> 1. If Postgre is not setup to use a port, how does the Raq use it to
> generate its webpages? I had assumed that all that must be setup for this
> reason. Also, I ran netstat and it said that it was listening to port 5432.
> Is there a configuration file I need to know about to get it to work on
> that port?

Someone has turned it on then. The default is to not listen on a tcp/udp port.
Edit the file /var/lib/pgsql/data/postgres/pg_hba.conf to permit remote TCP/IP 
access to the database system. 
Run the program `postmaster' as user `postgres'. The `postmaster' process is 
the database server process which has sole control over the database system. 
To enable access the database system, run the program `psql' as Unix user 
`postgres' (for special privileges), and add access rights for any ordinary 
Unix users who should be able to use the system. 
Run `psql' as an ordinary Unix user (as enabled via the `postgres' process), 
and create a database, and use it. 

> 2. Are there any vulnerabilities you know about with PostgreSQL? While I am
> using my system to test on can I simply leave it set to "local all trust"
> and then make sure that port 5432 is blocked on my hardware firewall? I
> understand that when I have other users using my system with shell accounts
> that this is not acceptable but in the interim where there is only me
> testing on it will that be sufficient security to guard against external
> attacks?

Se above

Gerald
-- 
http://frontstreetnetworks.com | http://store.raqware.com
Front Street Networks LLC      |  Phone: 203-785-0699
229 Front Street, Ste #C, New Haven, CT 06513-3203