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