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

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
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 3 guests