(Jan 22) Release 0.9.8-19 with bug fixes available now. Run this command for update v-update-sys-vesta-all

Error: Vesta user backup | pg_dump: invalid option -- 'i'

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Forum rules
Before creating a new topic or reply on the forum you should fill out additional fields "Os" and "Web" in your profile section.
In case of violation, the topic can be closed or response from the support will not be received.
7thkey
Posts: 8
Joined: Wed Aug 06, 2014 4:49 pm

Error: Vesta user backup | pg_dump: invalid option -- 'i'

Postby 7thkey » Fri Apr 07, 2017 10:17 am

I get this error on Ubuntu 16.04 machine with NGINX/php-fpm server and mysql + postgreSQL Vesta setup.

Can't dump database admin_db
/usr/lib/postgresql/9.5/bin/pg_dump: invalid option -- 'i'
Try "pg_dump --help" for more information.

Any ideas why this happens?
How we can remove that option?

Cheers

BBuchanan1013
Posts: 139
Joined: Thu Jan 07, 2016 12:01 am

Re: Error: Vesta user backup | pg_dump: invalid option -- 'i'

Postby BBuchanan1013 » Fri May 26, 2017 2:15 am

7thkey wrote:I get this error on Ubuntu 16.04 machine with NGINX/php-fpm server and mysql + postgreSQL Vesta setup.

Can't dump database admin_db
/usr/lib/postgresql/9.5/bin/pg_dump: invalid option -- 'i'
Try "pg_dump --help" for more information.

Any ideas why this happens?
How we can remove that option?

Cheers


Read: https://forum.vestacp.com/viewtopic.php?t=11312.

BBuchanan1013
Posts: 139
Joined: Thu Jan 07, 2016 12:01 am

Re: Error: Vesta user backup | pg_dump: invalid option -- 'i'

Postby BBuchanan1013 » Fri May 26, 2017 2:17 am

BBuchanan1013 wrote:
7thkey wrote:I get this error on Ubuntu 16.04 machine with NGINX/php-fpm server and mysql + postgreSQL Vesta setup.

Can't dump database admin_db
/usr/lib/postgresql/9.5/bin/pg_dump: invalid option -- 'i'
Try "pg_dump --help" for more information.

Any ideas why this happens?
How we can remove that option?

Cheers


Read: https://forum.vestacp.com/viewtopic.php?t=11312.


More specific:

Code: Select all

in file func/db.sh, line 88 there is a command:

[quote]pg_dump -h $HOST -U $USER -c --inserts -O -x -i -f $1 $2 2>/tmp/e.psql[/quote]


If you feel bold, just remove the -i from func/db.sh on line 88


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 1 guest

cron