Postgresql - Artisan backup not available

[jk-na]

Unable to run the artisan backup:run command as the following response is returned:

Backup failed because: Cannot create a dumper for db driver 'postgres'. Use 'mysql', 'pgsql', 'mongodb' or 'sqlite'..

There is no mention of 'postgres' in my .env file so I gather this is incorrectly defined in some application file.

My relevant .env entries are:
DB_CONNECTION=pgsql
DB_DRIVER=pgsql

[trwnh]

DB_DRIVER is not an env var anywhere in the config. But do you maybe have cached config? Try running the config:cache or config:clear Artisan tasks.

[jk-na]

I removed DB_DRIVER from my .env file and ran config:cache as per normal with any env update.. still exactly the same error

[jk-na]

I presume that the artisan job itself or associated file(s) contains a reference to 'postgres' rather than 'pgsql'

[dansup]

@jk-na Replace mysql with pgsql here

pixelfed/config/backup.php

Line 52 in 4ad3de3

'mysql',

Then run php artisan config:cache

[jk-na]

this worked, thanks.