如何追加pg_dump备份命令PostgreSQL的日志输出

Question

我使用下面的命令来添加。

pg_dump -Fc -h hostname -W --dbname=dbanme -f dbname.sql --username 2>demo.log

我想像下面的示例输出那样登录到demo.log。

pg_dump: reading user-defined tables
pg_dump: reading packages variables
pg_dump: reading user-defined packages
pg_dump: reading user-defined synonyms
pg_dump: reading extensions
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: finding typelem dependencies for user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
.
.
.
....```

If we run in mysql using --verbose it will log all stuff using below command.
``` mysqldump -u -p dbname --log-error=error.log --verbose >bkp.sql```

我们如何在PostgreSQL中取得成功？

请帮帮忙。

Answer 1

使用--verbose，如下所述

./pg_ -Fc -h主机名-W --dbname=dbanme -f dbname.sql --用户名postgres --详细2>demo.log

披露:我为EnterpriseDB (EDB)工作