Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section General Discussion
  • Search

Upgrading postgresql to 9.5

General questions about VestaCP
Post Reply
  • Print view
Advanced search
3 posts • Page 1 of 1
Spider
Posts: 1
Joined: Sat Apr 30, 2016 7:33 am

Upgrading postgresql to 9.5
  • Quote

Post by Spider » Sat Apr 30, 2016 7:39 am

After successful upgrade to postgresql 9.5 there is a problem with backup script.
Can't dump database admin_db
/usr/lib/postgresql/9.5/bin/pg_dump: invalid option -- 'i'
in file func/db.sh, line 88 there is a command:
pg_dump -h $HOST -U $USER -c --inserts -O -x -i -f $1 $2 2>/tmp/e.psql
In postgresql 9.5 there is no "i" option.

Please update this in spcripts.
Top

violajsilver
Posts: 5
Joined: Tue May 03, 2016 4:39 am

Re: Upgrading postgresql to 9.5
  • Quote

Post by violajsilver » Tue May 03, 2016 6:09 am

Before you proceed, make sure you are logged in as a Postgres user with super powers. In Ubuntu, switching to postgres user is enough: sudo -iu postgres

During the installation of the new version, you’ll notice that a new directory for 9.5 version was created.Remove the newly created empty cluster pg_dropcluster 9.5 main
During the installation of the new version, you’ll notice that a new directory for 9.5 version was created.
We are removing it because our upgrade process from 9.4 will create it again and convert the old data format to work with 9.5.
Upgrade your databases
pg_upgradecluster 9.5 main
Depending on the amount of data you had, this may take a long while. After it finishes sucessfully, you’ll see this message:
Success. Please check that the upgraded cluster works.
Remove the old cluster
Postgres 9.5 should now be running, check your local apps which use the Postgres databases to confirm data is correct. If all seems to work, you can remove the old 9.4 cluster by running:pg_dropcluster 9.4 main.
Last edited by skurudo on Wed Aug 24, 2016 8:22 am, edited 2 times in total.
Reason: SPAM
Top

IStranger
Posts: 1
Joined: Wed Aug 30, 2017 2:18 pm

Re: Upgrading postgresql to 9.5
  • Quote

Post by IStranger » Wed Aug 30, 2017 2:32 pm

I got the same bag on vesta 0.9.8-17.
Here is bag report: https://github.com/serghey-rodin/vesta/issues/913

But you may fix it manually (from github):
The parameter -i was removed in version 9.5. I solved this Issue manually by removing the -i option in the $VESTA/func/db.sh script (line 88)
Top


Post Reply
  • Print view

3 posts • Page 1 of 1

Return to “General Discussion”



  • 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