adi nugroho wrote:
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
bikin user baru pake usernya postgres
template1=# create user gue with password 'xxxx';
terus masukin di login pgadminnya
kalu nggak salah kaya gtu, dulu gw jg kaya gitu pas gw bikin user baru bisa
--
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