Re: pg_restore - generated column - not populating

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(dot)klaver(at)aklaver(dot)com