Use the following command line:
Pg_dump. Exe - E utf-8 - Ft -u postgres -w testDB & gt; D: \ testDB. Backup
The testDB backup. Backup file, use the following command to restore, has been an error:
Pg_restore -u postgres testDB - v - d "d: \ testDB. Backup"

If write wrong, please give directions,

CodePudding user response:

File is quite large around 2 g, the hard disk is NTFS

CodePudding user response:

An error is
Pg_restore: [archiver] input file does not appear to be a valid archive

CodePudding user response:

You to add a backup file. The tar suffix to try?

CodePudding user response:

The

reference 3 floor minsic78 response:

you to add a backup file. The tar suffix to try?

No, or to the same fault.

CodePudding user response:

reference 4 floor aoyusky response:

Quote: reference minsic78 reply: 3/f

You to add a backup file. The tar suffix to try?

No, at the same fault,

So probably file damaged,,,

CodePudding user response:

I to carry out
Pg_dump. Exe - E utf-8 - Ft -u postgres -w testDB & gt; D: \ testDB. Backup
Backup the file or not! The command is wrong?

CodePudding user response:

Everyone is what command automatically backup the database?

CodePudding user response:

No master knows?

CodePudding user response:

Look closely again under your theme, do you want to export from Windows, Linux import? If so, try it or use plain format

CodePudding user response:

You try the PSQL command reduction, I remember use pg_restore reduction, the parameters of the backup - Fc