0

Running into an issue running pg_dump with -Fd -Z 9 -j 10 using postgres-14 on linux. The backup completes from the cmdline, but I see that CREATE table IF not exists statements are blocked by a pid for pg_dump doing COPY of a partition table. Not quite sure why pg_dump is still running and doing COPY when pg_dump itself on cmdline completed successfully.

pg_dump completes successfully and no other job running related to pg_dump blocking other jobs

Improve this question
6
  • 1) Where are seeing this ... CREATE table IF not exists statements are blocked by a pid for pg_dump doing COPY of a partition table.? 2) To your question add the query you used and the result. Commented Feb 5, 2024 at 23:41
  • It might be worth to try SELECT pg_terminate_backend(<put the PID here>);, but only if you are really sure this should no longer be running Commented Feb 5, 2024 at 23:47
  • @AdrianKlaver CREATE table if not exists shows up when doing select to find the blocked pids in pg_stat_activity. Then I just look up what the PID is using select * from pg_stat_activity pid=blockingpid Commented Feb 6, 2024 at 0:06
  • @Islingre yeah that's what i did Commented Feb 6, 2024 at 0:08
  • 1
    How are you are determining something is blocked? Commented Feb 6, 2024 at 0:20
Related questions
436
Copy a table from one database to another in Postgres
0
Backup Postgres Table using pg_dump is there a workaround to include the --jobs option
4
postgres table partition on null date
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.