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 MoreTag: Vesta Control Panel
How 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 MoreHow to migrate user to the new server in Vesta Control Panel
Migrate user to the new server in Vesta Control Panel 1. Make user backup on the old server. In this example we will use admin as the reference. v-backup-user admin 2. Copy tarball to the new server and place it in the /home/backup directory scp /home/backup/admin.2014-01-14.tar new-server:/home/backup/ 3. Restore backup on the new server v-restore-user […]
See More