Re: Newbie: port

None to begin with.  You have to tell it to.  Then you have to tell it to
allow connections on that port.  PostgreSQL comes configured to NOT let
outside computers connect until you change things, enhancing security.

You want to read the admin guide located here:

http://www.postgresql.org/docs/7.4/static/admin.html

Sepcifically this section:

The server runtime environment:
http://www.postgresql.org/docs/7.4/static/runtime.html

And this one:

Client Authentication:
http://www.postgresql.org/docs/7.4/static/client-authentication.html

Postgresql has a great administrator's guide.  It's a complex enough tool
that you really need to read up on it to take full advantage of it and
your personal investment in it.

Short story: pg_hba.conf controls who can connect, postgresql.conf
controls whether to listen on TCP/IP ports.

Good luck with pgsql, hope to see ya around.

On Mon, 17 Nov 2003, Fajar Priyanto wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Dear all,
> On what port does postgre run?
> How do I know if postgre already running on my box?
> I nmaped and the result was:
> Starting nmap V. 3.00 ( www.insecure.org/nmap/ )
> Interesting ports on localhost (127.0.0.1):
> (The 1583 ports scanned but not shown below are in state: closed)
> Port       State       Service
> 21/tcp     open        ftp
> 22/tcp     open        ssh
> 25/tcp     open        smtp
> 80/tcp     open        http
> 110/tcp    open        pop-3
> 111/tcp    open        sunrpc
> 139/tcp    open        netbios-ssn
> 143/tcp    open        imap2
> 443/tcp    open        https
> 631/tcp    open        ipp
> 783/tcp    open        hp-alarm-mgr
> 993/tcp    open        imaps
> 2049/tcp   open        nfs
> 3306/tcp   open        mysql
> 6000/tcp   open        X11
> 10000/tcp  open        snet-sensor-mgmt
> 32770/tcp  open        sometimes-rpc3
> 32771/tcp  open        sometimes-rpc5
> Thanks
> - --
> Fajar http://linux.arinet.org
> Linux mdk91.sistek.kom 2.4.21-0.13mdk GNU/Linux
> 16:10:38 up 8:21, 10 users, load average: 0.43, 0.31, 0.28
> Quote of the day:
> Choose two:
> (A) Fast
> (B) Efficient
> (C) Stable
> (D) Windows 98 (counts as two)
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (GNU/Linux)
>
> iD8DBQE/uJDxMai9kCFqACoRAs4eAKCxWmzBL8EgZ/V/NPZn0sha2cUx3QCgj0D9
> eJvhNgAzlmiW3TujJLaa6Gc=
> =q1gi
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
>