Control Web Panel

WebPanel => PostgreSQL => Topic started by: AcemiPenguen on August 11, 2020, 07:15:13 AM

Title: How can i install postgreSQL?
Post by: AcemiPenguen 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..
Title: Re: How can i install postgreSQL?
Post by: AcemiPenguen 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..