how to set up PostgreSQL on a Dabian or Ubunto in vasta control panel

How to set up PostgreSQL on a Debian or Ubuntu in Vesta Control Panel

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 More

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 More

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 More