From: | "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | pg_restore: could not close data file: Success |
Date: | 2020-04-15 10:01:46 |
Message-ID: | 20200415100146.GA22324@hjp.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
I'm trying to restore a backup on a different machine and it terminates
with the not really helpful messages:
pg_restore: [directory archiver] could not close data file: Success
pg_restore: [parallel archiver] a worker process died unexpectedly
The backup was made with
pg_dump --compress=5 -v -Fd -f "$dirname" -j 4 $db
(so it's in directory format)
The restore command was
pg_restore -c --if-exists -d $db -j 4 -v $dirname
(I would use -C, but due to suboptimal partitioning I have to use a
different tablspace, so I need to create $db before the restore)
Both machines are running Ubuntu 18.04 and PostgreSQL is version 11.7
from the pgdg repo.
The error happens while restoring the data for the tables.
My guess is that maybe one of the data files is damaged ("Success"
probably means that errno is 0, so it wasn't a system call that failed,
but something in the application). Does that sound plausible or should I
look somewhere else? A web search returned nothing relevant.
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
From | Date | Subject | |
---|---|---|---|
Next Message | Peter J. Holzer | 2020-04-15 10:14:25 | Re: pg_restore: could not close data file: Success |
Previous Message | Dilip Kumar | 2020-04-15 07:40:37 | Re: Help needed with XMLTABLE |
From | Date | Subject | |
---|---|---|---|
Next Message | Zhang, Jie | 2020-04-15 10:06:52 | [PATHC] Fix minor memory leak in pg_basebackup |
Previous Message | Rajkumar Raghuwanshi | 2020-04-15 09:28:37 | Re: WIP/PoC for parallel backup |