- Cli Commands
- Paid Plugins are now FREE
- Vesta 2.0: Coming Soon
- API description & examples
- How to install Vesta Control panel
- How to unistall Vesta Control panel
- Template description
- Config and log locations on a RHEL and CentOS
- Config and log locations on a Debian and Ubuntu
- How to install ClamAV and SpamAssassin on a RHEL or CentOS
- How to install ClamAV and SpamAssassin on a Debian or Ubuntu
- How to install WHMCS module
- How to configure FTP backup
- How to translate Vesta interface
- How to enable WSGI support on a RHEL or CentOS
- How to enable WSGI support on a Debian or Ubuntu
- How to enable PHP-FCGI support on a RHEL or CentOS
- How to enable PHP-FCGI support on a Debian or Ubuntu
- How to force https/SSL on a domain
- How to configure temporary links for new domains
- How to set up own Name Servers (vanity/private/child nameservers)
- How to set up master-slave DNS cluster
- How to enable AXFR (Zone Transfer) in Bind
- How to migrate user to the new server
- How to add remote MySQL database server
- How to set up PostgreSQL on a RHEL or CentOS
- How to set up PostgreSQL on a Debian or Ubuntu
- How to replace vsftpd with ProFTPD on a RHEL or CentOS
- How to replace vsftpd with ProFTPD on a Debian or Ubuntu
- How to remove Nginx on a RHEL or CentOS
- How to remove Nginx on a Debian or Ubuntu
- How to properly set up a Mail Server
- How to properly set up a Mail Client
- How to install Fail2Ban on RHEL or CentOS
- How to install Fail2Ban on Debian or Ubuntu
- How to configure Service (SRV) Records
- How to replace MySQL with Percona Server on RHEL or CentOS
- How to replace MySQL with Percona Server Debian or Ubuntu
- How to redirect HTTP to HTTPS using htaccess
- How to redirect subdomain to folder using htaccess
How to set up PostgreSQL on a RHEL or CentOS
- 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
- Initialize database cluster
service postgresql initdb
- Download hba configuration
wget http://c.vestacp.com/0.9.8/rhel/pg_hba.conf -O /var/lib/pgsql/data/pg_hba.conf
- Start the server
service postgresql start
- Set oracle user password
su - postgres
psql -c "ALTER USER postgres WITH PASSWORD 'pgp4sw0rd'"
exit
- Enable pgsql databases support in vesta. open /usr/local/vesta/conf/vesta.conf and set DB_SYSTEM to 'mysql,pgsql'
- Register pg instance in control panel
v-add-database-host pgsql localhost postgres pgp4sw0rd
- Download phpPgAdmin configuration
wget http://c.vestacp.com/0.9.8/rhel/pga.conf -O /etc/phpPgAdmin/config.inc.php
wget http://c.vestacp.com/0.9.8/rhel/httpd-pga.conf -O /etc/httpd/conf.d/phpPgAdmin.conf
- Restart web server
service httpd restart