Newbie: port
-----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-----
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Mon, 17 Nov 2003, Fajar Priyanto wrote:
On what port does postgre run?
If you've activated tcpip_socket on postgresql.conf, then postmaster will
listen 5432, as default. You're free to change the port in postgresql.conf
bye modifying port variable by setting it to an unused port.
How do I know if postgre already running on my box?
YOu could use psql.
psql template1 -U postgres
will work.
Regards,
- --
Devrim GUNDUZ
devrim@gunduz.org devrim.gunduz@linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
iD8DBQE/uJP5tl86P3SPfQ4RAkHPAJ0ZRfaexRWHd5k6+/MFCMae1clXKgCgsKCG
XHyzsOBG34ZNCxDzAYvW+AA=
=BczP
-----END PGP SIGNATURE-----
Fajar Priyanto wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1Dear all,
How do I know if postgre already running on my box?
$ netstat -taupe
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:
Show quoted text
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1Dear 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