(copying here as it was a misclick about "reply all" button)
I'll try to, but even plain text dump didn't work
psql:<db_name>_20230323.sql:5672327: ERROR: extra data after last expected column CONTEXT: COPY alpha_beta, line 3828998: "1643415437295 SRSR MORN1661692859461 NODK MORNINGSTAR f {"fiscalYearEndMonth": "12"} 0P00019YC1 0C00..."
I can check md5sum if there is an idea about network issue.
On Thu, 23 Mar 2023 at 10:43, Daniel Gustafsson <daniel@yesql.se> wrote:
> pg_restore: processing data for table "<db_name>.consensus_estimate" > pg_restore: error: could not uncompress data: (null)
This error indicates, as it clearly states, a failure to decompress the compressed file, but it's a bit worrying that the error is (null) since this really should report an error. Handling an empty ->msg seems like something we maybe should do.
Does dumping/restoring any database in your cluster work? Is it just this one that fails?