Vesta Control Panel - Forum

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.

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.

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)