PostgreSQL backup script

You do not need to enter the password for local backup:

Pg_dump -- Host 10.13.38.81 -- username "s" -- no-Password -- format tar -- blobs -- verbose -- file "D: \ pg. Bak" "mydb"

 

You need to manually enter the password for backup on a different machine:

Pg_dump -- Host 10.13.38.81 -- username "s" -- password -- format tar -- blobs -- verbose -- file "D: \ pg. Bak" "mydb"

 

You can also set the ipvs user and remote host IP address in the server HbA file to trust during Backup on different hosts without entering a password:

Pg_dump -- Host 10.13.38.81 -- username "s" -- no-Password -- format tar -- blobs -- verbose -- file "D: \ pg. Bak" "mydb"