Author Topic: How can i install postgreSQL?  (Read 1108 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
How can i install postgreSQL?
« on: August 11, 2020, 07:15:13 AM »
Hi,

i deleted postgres database and cannot use postgresql anymore. So, i uninstalled by terminal with this command

yum remove postgresql-server postgresql postgresql-devel

and when i open cwp admin page, postgresql installer, show click to install postgresql

and i try to install by web but its not working. not installing anything.

i can open phpgadmin page but its empty and cannot login there too.. please help..

Offline
*
Re: How can i install postgreSQL?
« Reply #1 on: August 11, 2020, 12:35:57 PM »
i solved my problem myself..

first, istall by console this command;

yum install postgresql-server postgresql-contrib

after that this command for create new db;

postgresql-setup initdb

if the see data directory is not empty! error, then remove data directory first
this path;

/var/lib/pgsql/data

after that try again same command;

postgresql-setup initdb

then will be create new database and start services and add autoload;

systemctl start postgresql
systemctl enable postgresql

thats all..