Leaders, I ask, I want to a remote backup data, the port number is 5432, but my SFTP server port number is not the default of 22 statement should be how to write

CodePudding user response:

Why do you want to backup, with pg_dump into SQL backup files can be like this:
IP pg_dump - h - 5432 - U p postgres - c - f dbname. SQL dbname

My blog: PostgreSQL backup and restore, for reference only,