Set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel Step 1. Install PostgreSQL packages apt-get install postgresql postgresql-contrib phppgadmin Step 2. Download hba configuration wget http://c.vestacp.com/0.9.8/debian/pg_hba.conf -O /etc/postgresql/*/main/pg_hba.conf Step 3. Restart the server service postgresql restart Step 4. Set oracle user password su – postgres psql -c “ALTER USER postgres WITH PASSWORD […]
See MoreTag: web server
How to set up PostgreSQL on a RHEL or CentOS in Vesta Control Panel
Set up PostgreSQL on a RHEL or CentOS in Vesta Control Panel 1. Install PostgreSQL packages yum install postgresql postgresql-server postgresql-contrib phpPgAdmin * If you have remi installed then don’t forget to explicitly enable it. yum install –enablerepo=remi postgresql postgresql-server postgresql-contrib phpPgAdmin 2. Initialize database cluster service postgresql initdb 3. Download hba configuration wget http://c.vestacp.com/0.9.8/rhel/pg_hba.conf […]
See MoreHow to add remote MySQL database server in Vesta Control Panel
Add remote MySQL database server in Vesta Control Panel 1. It is assumed you already have your second server up and running. 2. On the first server run following command v-add-database-host mysql new-server.com root password 3. To make sure eveyrhing is in order, check database host list v-list-database-hosts
See More
You must be logged in to post a comment.