Both are different versions The following works:
Version: pg_dump (pgAdmin Windows) version:13.1 Method: Backup using Windows connecting to the remote host: Command: pg_dump -Fc -p 5432 -h <remotehost_ip> -d mydb > mydb.backup1 -U postgres Restore locally on Ubuntu : pg_restore -d mydb-restore mydb.backup1 ----------- The following does not work: (Does not populate the generated column values) Version: pg_dump (PostgreSQL v13.2 on Ubuntu 20.04) version 13.2 Method: Backup locally on Ubuntu 20.04 Command: pg_dump -Fc -p 5432 -h localhost -d mydb > mydb.backup2 -U postgres Restore locally on Ubuntu : pg_restore -d mydb-restore mydb.backup2 On Tue, Feb 23, 2021 at 9:34 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > Santosh Udupi <em...@hitha.net> writes: > > Right. pg_dump under the pgAdmin runtime folder works perfectly. pg_dump > > in postgres13 (ubuntu) does not work. Exact same syntax. > > So, are these identical pg_dump versions? We did fix some things > in this area in 13.2. > > regards, tom lane >
