Page 1 of 1

problem postgres 9.5

Posted: Sun Feb 11, 2018 7:11 am
by k26
Hi all, I installed postgresql 9.5 after I installed VestaCP following viewtopic.php?t=3799&sid=9d41b84993d9c7 ... ded26b23b7 (of course adapted to postgresql-9.5

Then I changed the password for postgres and run
v-add-database-host pgsql localhost postgres pgp4sw0rd

I changed the /usr/local/vesta/conf/vesta.conf file to add the pgsql
DB_SYSTEM='pgsql,mysql'

I restarted postgresql-9.5 and vestacp as well
but when I try to create a database in vestacp (web) I can only see mysql as possible choice

Do you know how I could select pgsql as well ? Are there some things to check ?
thanks for your help

Re: problem postgres 9.5

Posted: Sun Feb 11, 2018 9:19 am
by k26
ok, just to let you know that I found the solution !
Just add the postgresql port (32 or 24 or 5432...) after the installation like explaine in my previous post, in the vestacp web firewall tab...and the pgsql is showed when you want to create a postgres database.

<==== closed for me ====>