CODEWITHSUNDEEP
pgadmin-4pg-dump
Michael
Michael

Reputation: 251

PgAdmin 4: Terminate database backup process

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?

Upvotes: 13

Views: 15909

Answers (2)

Gidy
Gidy

Reputation: 426

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.

Upvotes: -1

Markus
Markus

Reputation: 2163

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.

Upvotes: 0

Related Questions