How to restart Postgres database?
Posted on 2010-08-18
I'm newbie to Postgres. Software version is:
- PostgreSQL 7.4.2
- Conectiva Linux 10
I'm trying to connect pgAdmin to database server, but I can't. I got error:
"FATAL: NO PG_HBA.CONf entry for host"
I found that solution is searching for the file pg_hba.conf and then add the following line:
host all all 192.168.10.1 255.255.255.0 password
Restart the PostgreSQL database. After that, connect to PostgreSQL database server through pgAdmin.
Problem is that I don't know how to restart database.
# /etc/rc.d/init.d/postgresql stop
# /etc/rc.d/init.d/postgresql restart
But got the following error:
-bash: postgresql: command not found
How do I restart database?