We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Upgrading postgresql to 9.5
Upgrading postgresql to 9.5
After successful upgrade to postgresql 9.5 there is a problem with backup script.
Please update this in spcripts.
in file func/db.sh, line 88 there is a command:Can't dump database admin_db
/usr/lib/postgresql/9.5/bin/pg_dump: invalid option -- 'i'
In postgresql 9.5 there is no "i" option.pg_dump -h $HOST -U $USER -c --inserts -O -x -i -f $1 $2 2>/tmp/e.psql
Please update this in spcripts.
-
- Posts: 5
- Joined: Tue May 03, 2016 4:39 am
Re: Upgrading postgresql to 9.5
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.
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
Reason: SPAM
Re: Upgrading postgresql to 9.5
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):
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)