Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Dev Section 3rd Party Software
  • Search

[SOLVED] How to properly uninstall PostgreSQL ?

Section with additional software for Vesta
Post Reply
  • Print view
Advanced search
2 posts • Page 1 of 1
newtron
Posts: 22
Joined: Wed Jan 13, 2016 4:43 pm

[SOLVED] How to properly uninstall PostgreSQL ?
  • Quote

Post by newtron » Fri Jan 15, 2016 7:00 pm

1. Install PostgreSQL packages
apt-get install postgresql postgresql-contrib phppgadmin

2. Download hba configuration
wget http://c.vestacp.com/0.9.8/debian/pg_hba.conf -O /etc/postgresql/*/main/pg_hba.conf

3. Restart the server
service postgresql restart

4. Set oracle user password
su - postgres
psql -c "ALTER USER postgres WITH PASSWORD 'pgp4sw0rd'"
exit

5. Enable pgsql databases support in vesta.
open /usr/local/vesta/conf/vesta.conf and set DB_SYSTEM to 'mysql,pgsql'

6. Register pg instance in control panel
v-add-database-host pgsql localhost postgres pgp4sw0rd

7. Download phpPgAdmin configuration
wget http://c.vestacp.com/0.9.8/debian/pga.conf -O /etc/phppgadmin/config.inc.php
wget http://c.vestacp.com/0.9.8/debian/apache2-pga.conf -O /etc/apache2/conf.d/phppgadmin

8. Restart web server
service apache2 restart
I think all i have to do is revert all these changes... right?
Last edited by newtron on Mon Jan 18, 2016 8:34 am, edited 1 time in total.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: How to properly uninstall PostgreSQL ?
  • Quote

Post by skurudo » Fri Jan 15, 2016 9:20 pm

newtron wrote: I think all i have to do is revert all these changes... right?
Yep, you're right.
Top


Post Reply
  • Print view

2 posts • Page 1 of 1

Return to “3rd Party Software”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password