New commit detected on ManageIQ/manageiq-gems-pending/fine: https://github.com/ManageIQ/manageiq-gems-pending/commit/1017ed17fa95fc4589e4230ed43b88821cdd13ae commit 1017ed17fa95fc4589e4230ed43b88821cdd13ae Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed Apr 26 08:37:44 2017 -0400 Commit: Satoe Imaishi <simaishi> CommitDate: Wed Apr 26 17:06:33 2017 -0400 Merge pull request #140 from carbonin/also_remove_pglogical_extension_before_restore Remove the pglogical extension before attempting a database restore (cherry picked from commit a612c007fbcbcaa0419e1c85a4fd1ec2bd9d0a7b) https://bugzilla.redhat.com/show_bug.cgi?id=1445803 lib/gems/pending/util/postgres_admin.rb | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-)
I am still seeing the same behavior in 5.8.0.13, when running the restore through appliance console I still see: Are you sure you would like to restore the database? (Y/N): y Restoring the database... Database restore failed There are 1 connection preventing a database restore Press any key to continue.
https://github.com/ManageIQ/manageiq-gems-pending/pull/149
New commit detected on ManageIQ/manageiq-gems-pending/master: https://github.com/ManageIQ/manageiq-gems-pending/commit/6f17bbf10fa1e92e487c8e7c8d08915144a471da commit 6f17bbf10fa1e92e487c8e7c8d08915144a471da Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 14:46:44 2017 -0400 Commit: Gregg Tanzillo <gtanzill> CommitDate: Thu May 4 12:01:02 2017 -0400 Fix typo dropping pglogical extension https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 lib/gems/pending/util/postgres_admin.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commit detected on ManageIQ/manageiq-gems-pending/master: https://github.com/ManageIQ/manageiq-gems-pending/commit/cdb3b1355349387cc0b41fe54477d4e620666199 commit cdb3b1355349387cc0b41fe54477d4e620666199 Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 14:52:22 2017 -0400 Commit: Gregg Tanzillo <gtanzill> CommitDate: Thu May 4 12:01:25 2017 -0400 Wait for "pglogical manager" db connection to go away before allowing pg_restore to proceed https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 lib/gems/pending/util/postgres_admin.rb | 15 +++++++++++++++ 1 file changed, 15 insertions(+)
New commit detected on ManageIQ/manageiq-gems-pending/master: https://github.com/ManageIQ/manageiq-gems-pending/commit/d8263c8d1ec86fffefb9ddf4397ff1793b29848b commit d8263c8d1ec86fffefb9ddf4397ff1793b29848b Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 14:51:00 2017 -0400 Commit: Gregg Tanzillo <gtanzill> CommitDate: Thu May 4 12:01:20 2017 -0400 Move logic for dropping pglogical extension to a separate method https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 lib/gems/pending/util/postgres_admin.rb | 10 ++++++++-- 1 file changed, 8 insertions(+), 2 deletions(-)
New commit detected on ManageIQ/manageiq-gems-pending/fine: https://github.com/ManageIQ/manageiq-gems-pending/commit/b3dd664074a840a7d4fab1467091cc3305278937 commit b3dd664074a840a7d4fab1467091cc3305278937 Author: Joe Rafaniello <jrafanie.github.com> AuthorDate: Thu May 4 15:39:07 2017 -0400 Commit: Satoe Imaishi <simaishi> CommitDate: Thu May 4 15:58:57 2017 -0400 Merge pull request #149 from gtanzillo/quiesce-pglogical-manager-connection Quiesce pglogical manager DB connection before allowing pg_restore to proceed (cherry picked from commit 5ea4214b6287b3307d4fe6ff93eed835f6d57612) https://bugzilla.redhat.com/show_bug.cgi?id=1445803 lib/gems/pending/util/postgres_admin.rb | 27 ++++++++++++++++++++++++--- 1 file changed, 24 insertions(+), 3 deletions(-)
Verified in 5.8.0.14
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2017:1367
New commit detected on ManageIQ/manageiq-appliance_console/master: https://github.com/ManageIQ/manageiq-appliance_console/commit/98701fbc84181a52c643428cf102f4480739a2f1 commit 98701fbc84181a52c643428cf102f4480739a2f1 Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 18:46:44 2017 +0000 Commit: Nick LaMuro <nicklamuro> CommitDate: Tue Mar 16 19:25:16 2021 +0000 Fix typo dropping pglogical extension https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 (transferred from ManageIQ/manageiq-gems-pending@6f17bbf10fa1e92e487c8e7c8d08915144a471da) lib/manageiq/appliance_console/postgres_admin.rb | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) https://github.com/ManageIQ/manageiq-appliance_console/commit/ef6e1a378d9fd8bab438434bfcae5ab73376391c commit ef6e1a378d9fd8bab438434bfcae5ab73376391c Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 18:51:00 2017 +0000 Commit: Nick LaMuro <nicklamuro> CommitDate: Tue Mar 16 19:25:16 2021 +0000 Move logic for dropping pglogical extension to a separate method https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 (transferred from ManageIQ/manageiq-gems-pending@d8263c8d1ec86fffefb9ddf4397ff1793b29848b) lib/manageiq/appliance_console/postgres_admin.rb | 10 +- 1 file changed, 8 insertions(+), 2 deletions(-) https://github.com/ManageIQ/manageiq-appliance_console/commit/1d7e9243af30bfba1f7a469491287af831934abb commit 1d7e9243af30bfba1f7a469491287af831934abb Author: Gregg Tanzillo <gtanzill> AuthorDate: Wed May 3 18:52:22 2017 +0000 Commit: Nick LaMuro <nicklamuro> CommitDate: Tue Mar 16 19:25:16 2021 +0000 Wait for "pglogical manager" db connection to go away before allowing pg_restore to proceed https://bugzilla.redhat.com/show_bug.cgi?id=1445803 https://bugzilla.redhat.com/show_bug.cgi?id=1444993 (transferred from ManageIQ/manageiq-gems-pending@cdb3b1355349387cc0b41fe54477d4e620666199) lib/manageiq/appliance_console/postgres_admin.rb | 15 + 1 file changed, 15 insertions(+)