Control Web Panel
WebPanel => PostgreSQL => Topic started 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..
-
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..
-
Hi AcemiPenguen, one question: the version of new installation are the same of older ?
I have similar problem.
Thanks