Search Postgresql Archives

Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks for your response, David. 

I realized I was running multiple threads to ("-j 12") run the pg_upgrade. If one thread fails, it sends a kill to other threads. Hence the fatal error.

However, running it as a single thread always fails at the below step:
 
Screen Shot 2021-08-02 at 11.38.20 AM.png

The dump file has something like this: 

Screen Shot 2021-08-02 at 11.40.01 AM.png
Multiple "Create sequence" and "Drop sequence". However the drop sequence doesn't seem to drop the sequence cleanly hence failing the restore process.

Are you or anyone aware of this issue while running pg_upgrade from 9.6 to 12.7?

On Fri, 30 Jul 2021 at 23:07, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Friday, July 30, 2021, Dhanush D <dhanushdk94@xxxxxxxxx> wrote:

pg_restore: error: could not execute query: FATAL:  terminating connection due to administrator command

Did you control-C or something, maybe remote connection dropped?

 
pg_restore: creating SEQUENCE "schema99.sequence2"
pg_restore: creating SEQUENCE OWNED BY "schema99.sequence2"
pg_restore: creating SEQUENCE "schema99.sequence2"
Is your source database corrupted such that this duplication appears in its catalog?

David J.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux