timescale / timescaledb-backup

Other
35 stars 9 forks source link

Trouble restoring to PG14: too many command-line arguments (first is "--list") #48

Open cristihcd opened 3 years ago

cristihcd commented 3 years ago

Hello,

Using Windows, package compiled from source.

ts-dump finishes ok. When running restore, I get the following error:

$ ts-restore.exe --db-URI=postgresql://postgres@localhost/database --dump-dir=d:\pgsql\backup\database --jobs=16 --verbose
pg_restore version: pg_restore (PostgreSQL) 14.0

pg_restore: error: too many command-line arguments (first is "--list")
Try "pg_restore --help" for more information.
2021/11/02 10:54:16 pg_restore run failed while writing TOC file: cmd.Run() failed with 'exit status 1'

I solved this by inverting the order of lines 136 and 137: https://github.com/timescale/timescaledb-backup/blob/91a3601268636de7f57414084c17b5d6e38c741c/pkg/restore/restore.go#L137, that is append --list before dumpDir.

It seems to work.