Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

problem postgres 9.5

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
2 posts • Page 1 of 1
k26
Posts: 12
Joined: Sat Feb 10, 2018 4:56 am

Os: CentOS 6x
Web: apache + nginx
problem postgres 9.5
  • Quote

Post by k26 » Sun Feb 11, 2018 7:11 am

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
Top

k26
Posts: 12
Joined: Sat Feb 10, 2018 4:56 am

Os: CentOS 6x
Web: apache + nginx
Re: problem postgres 9.5
  • Quote

Post by k26 » Sun Feb 11, 2018 9:19 am

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 ====>
Top


Post Reply
  • Print view

2 posts • Page 1 of 1

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password