Hi, Per my understanding, From the query which resulted in the deadlock “SELECT sequence_name, start_value, increment_by***********”, it appears that the query which holds the lock is related to sequence numbers. From our understanding it appears that, whenever there is a serial type of data member, PostgreSQL internally needs to keep track of sequence numbers across the dump and restore. Is it possible select query is triggered by PostgreSQL bringing up(to bring up internal database) instead of dump file? because from the log, it looks failed while doing DROP SCHEMA public CASCADE. -- View this message in context: http://postgresql.nabble.com/pg-restore-encounter-deadlock-since-PostgreSQL-bringing-up-tp5874146p5874160.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
