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

Поиск
Список
Период
Сортировка
От Dhanush D
Тема Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command
Дата
Msg-id CAMpFLfMac3GEQ8Pt8cR_-+Eh742_Qimq6L0vUZCbGd5Od28b9A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения
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@gmail.com> wrote:
On Friday, July 30, 2021, Dhanush D <dhanushdk94@gmail.com> 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.


		
	


	
	
Вложения

	
	

					

					





	

	            	В списке pgsql-general по дате отправления:
	
	

	
	

		
			

	        	

	       			Предыдущее
	    		

	    		
	От:
	Ganesh Korde

	Дата:
	



	Сообщение:
	Re: ERROR: ImportError: No module named 'psutil'
 

	    	

	    
	    
	    
			

	        	

	       			Следующее
	    		

	    		
	От:
	"David G. Johnston"

	Дата:
	



	Сообщение:
	Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command