On 2/22/21 7:43 PM, Santosh Udupi wrote:
If I backup using pgAdmin, I am able to restore using pg_restore but for
some reason, pg_rsestore on the output from pg_dump does not create
values for the generated columns
To troubleshoot this:
1) Stick to one dump/restore combination. The three versions you tried
before just confuse the issue. For instance:
pg_dump -Ft mydb > mydb.tar
pg_restore -Ft -d mydb mydb.backup
makes no sense. As mydb.backup came from:
pg_dump -C -Fc mydb > mydb.backup
I have not tested, but I'm pretty sure the pg_restore just ignored the
-Ft and just did -Fc.
2) Big explicit in your dump and restore commands for -h(ost), -p(ort)
and -U(ser). I suspect you may not be restoring to where you think you are.
3) Closely follow the progress of both the dump and the restore.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
