kmu edit file postgresql.conf atau hba.conf.
disitu ada baris ip address mana saja yang boleh akses ke system.
ada commentnya juga kok.
----- Original Message -----
From: "adi nugroho" <[EMAIL PROTECTED]>
To: <tanya-jawab@linux.or.id>
Sent: Tuesday, October 30, 2007 12:06 PM
Subject: [tanya-jawab] tolong postgresql
maap saya baru belajar install postgresql
yang ternyata lebih susah dibanding mysql....
aku pake ubuntu 6.10
dan sudah jalan postgressqlnya
------
[EMAIL PROTECTED]:~$ ps ax |grep postgres
7706 ? S
0:00 /usr/lib/postgresql/7.4/bin/postmaster -D
/var/lib/postgresql/7.4/main
7708 ? S 0:00 postgres: stats buffer process
7709 ? S 0:00 postgres: stats collector process
15923 ? S 0:01 kate
[kdeinit] --use /etc/postgresql/7.4/main/pg_hba.conf
15976 pts/6 S+ 0:00 grep postgres
-------
juga dapat masuk pake psql
-----
[EMAIL PROTECTED]:~$ su postgres
Password:
[EMAIL PROTECTED]:/home/ibm$ psql template1
Welcome to psql 7.4.13, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
template1=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
focus | postgres | UNICODE
template0 | postgres | UNICODE
template1 | postgres | UNICODE
(4 rows)
template1=#
-------
tapi kalo mau pake phppgadmin
user diisi postgres
selalu muncul
Login disallowed for security reasons.
trus di coba liat portnya
[EMAIL PROTECTED]:~$ nmap 127.0.0.1
Starting Nmap 4.10 ( http://www.insecure.org/nmap/ ) at 2007-10-30 13:50
EIT
mass_dns: warning: Unable to determine any DNS servers. Reverse DNS is
disabled. Try using --system-dns or specify valid servers
with --dns_servers
Interesting ports on localhost (127.0.0.1):
Not shown: 1676 closed ports
PORT STATE SERVICE
80/tcp open http
631/tcp open ipp
3306/tcp open mysql
Nmap finished: 1 IP address (1 host up) scanned in 0.173 seconds
[EMAIL PROTECTED]:~$
pertanyaan :
1. kenapa tidak mau konek dengan phppgadmin ? kalo masalah dengan port
5432
bagaimana cara aktifin port 5432:tcp nya ?
2. aku juga coba pake pgaccess kalo mau dikonek localhost, user postgres,
muncul tulisan
ERROR TRYING TO CONECT DATABASE bla-bla bla bla
could not connect to server : connection refused is the server running
on
host "localhost and accepting on port 5432 ?
3 aku coba pake pgadmin III muncul error yang sama dengan no 2
4. mohon bantuannya SOS aku dah mau putus asa nih........
i
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis
--
FAQ milis di http://wiki.linux.or.id/FAQ_milis_tanya-jawab
Unsubscribe: kirim email ke [EMAIL PROTECTED]
Arsip dan info milis selengkapnya di http://linux.or.id/milis