13

I am attempting to back up a PostgreSQL database from pgAdmin 4, but a pg_dump backup process is already running, and I am unable to stop it.

I've restarted the postgres server, restarted the server OS, and restarted pgAdmin, but the pg_dump backup process is still running.

Update: Removing and reinstalling postgresql and pgAdmin 4 did not solve the problem. The backup process resumed.

How can I stop this process?

metaperture
  • 2,393
  • 1
  • 18
  • 19
Michael
  • 251
  • 1
  • 2
  • 13
  • 3
    I had to kill the process with task manager. Because of this (and many other) problem I decided to wait until the developers finish up their work on PgAdmin4 and have installed [old good PgAdmin3](https://bigsql.org/postgresql/installers.jsp), still [supported by BIGSQL](https://bigsql.org/pgadmin3/index.jsp). – klin Oct 27 '16 at 13:51
  • 2
    Same here, absolute nightmare. Even when we restart pgAdmin 4, the backup is still on going. Even after killing the process. I had to stop the pg server, kill the process several times to make it stop – MrJibus Mar 24 '20 at 15:48

2 Answers2

0

I managed to stop it (actually fail it and then close it) by doing this workaround:

  • closing PGAdmin 4
  • killing all pg_restore/pg_admin processes
  • for restore: rename/move/delete file restoring from
  • for backup: temporarily remove access rights from target filesystem (or rename target folder to "break the path" in the PGAdmin job)

Next time you open PG-Admin it will try to start the job again, but will fail immediately. Open details and close with "X" and it's gone.

Markus
  • 1,887
  • 18
  • 23
  • @ChetanPurohit possibly you have a different version. what did not work for you? the closing of PGAdmin, the process killing or the file move/rename? – Markus Nov 11 '20 at 13:03
-1

I hade the same problem today, i found this Post: PostgreSQL-Mailinglist with the given answer:

First, click on "Click here for details" link on the dialogue (same dialogue you have attached). When you click on that, another dialogue (details of backup) will show up. Please close that another dialogue through the close button (at upper right), this window will not show up again.

I had to do this ~3 times, and now the "Backup-Window" is gone.

Gidy
  • 426
  • 6
  • 16