Quote:
Originally Posted by alpc360
Hello
You can reinstall postgresql.
yum remove postgresql postgresql-devel postgresql-server -y
and /scripts/installpostgres
Greetings
|
nothing changed !
Installed: postgresql.i386 0:7.4.19-1.el4_6.1 postgresql-devel.i386 0:7.4.19-1.e l4_6.1 postgresql-server.i386 0:7.4.19-1.el4_6.1
Complete!
Stopping postgresql service: [FAILED]
postmaster: no process killed
postmaster: no process killed
Initializing database: [FAILED]
Starting postgresql service: [FAILED]
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
You should now configure postgresql from WHM!
installing config :
Postgres Config
Install Postgres Config
Failed to update /var/lib/pgsql/data/pg_hba.conf: No such file or directory
Failed to update /var/lib/pgsql/data/pg_hba.conf: No such file or directory
i think the path of pg_hba.conf is invalid in cpanel . because the pg_hba.conf is exist on /var/lib/pgsql/ directory
[/var/lib/pgsql]# ll
total 40K
drwx------ 4 postgres postgres 4.0K Aug 24 13:36 ./
drwxr-xr-x 20 root root 4.0K Aug 23 19:53 ../
drwx------ 2 postgres postgres 4.0K Jan 14 2008 backups/
-rw------- 1 postgres postgres 301 Aug 23 20:25 .bash_history
-rw-r--r-- 1 postgres postgres 107 Jan 14 2008 .bash_profile
drwx------ 2 postgres postgres 4.0K Aug 24 13:42 data/
-rw-r--r-- 1 postgres postgres 147 Aug 24 13:42 initdb.i18n
-rw-r--r-- 1 postgres postgres 63 Aug 24 13:42 pg_hba.conf
-rw------- 1 postgres wheel 25 Aug 24 13:37 .pgpass
but its not in data directory !
also if you create this file under data directory initialization of database will fail ! it says that the data directory isnt empty ....!
any idea ?