LinuxSay - A Discussion Forum for Linux Enthusiasts

PostgreSQL error while installing on CentOS

CentOS
#1

Hi Guys,

Please find below details when I am trying to install PostgreSQL on CentOS 6.5 getting error as below
Please help…

Error: Failed to load SQL modules into the database cluster.

Installing
0% ______________ 50% ______________ 100%
########################################
Error: Failed to load SQL modules into the database cluster.
Press [Enter] to continue:

Setup has finished installing PostgreSQL on your computer.

Thanks
Kiran

#2

digit the command:
/etc/init.d/postgresql status

and paste the return here.

#3

Hi !!

Please find below output after executing /etc/init.d/postgresql status

postmaster is stopped

Thanks

#4

If you don’t have anything in you database execute:

before, execute:
user@servername:~$ ls /etc/postgresql
9.2
user@servername:~$ ls /etc/postgresql/9.2/
main

change the commands below with your version of postgresql and name of cluster.

Remove the cluster if exists:
pg_dropcluster --stop 9.2 main

create a new cluster:
pg_createcluster -u postgres -g postgres 9.2 main

start the postgres cluster
/etc/init.d/postgresql start