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
>
>