Page 1 of 1

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

Posted: Fri Apr 07, 2017 10:17 am
by 7thkey
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

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

Posted: Fri May 26, 2017 2:15 am
by BBuchanan1013
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: viewtopic.php?t=11312.

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

Posted: Fri May 26, 2017 2:17 am
by BBuchanan1013
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: 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