Re: PostgreSQL Dump based backup using pipe - Mailing list pgsql-admin

From Tom Lane
Subject Re: PostgreSQL Dump based backup using pipe
Date
Msg-id 31650.1432736684@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL Dump based backup using pipe  (girish R G peetle <giri.anamika0@gmail.com>)
Responses Re: PostgreSQL Dump based backup using pipe  (girish R G peetle <giri.anamika0@gmail.com>)
List pgsql-admin
girish R G peetle <giri.anamika0@gmail.com> writes:
> We were using named pipe to read dump data from 'pg_dump -Fc' (compressed
> format) on Windows.
> Restore was failing with 'corrupt dump data' error.
> Later found that pg_dump was performing 'illegal seek' on pipe to write the
> data, which was causing corrupt dump.

That should work.  What PG version are you using exactly, and can we see a
full example of what you were trying to do?

There are unsupported cases --- I recall in particular that you can't do
a parallel restore from a pipe --- but you should not be getting "corrupt
file" errors.

            regards, tom lane


pgsql-admin by date:

Previous
From: Jan Lentfer
Date:
Subject: Re: PostgreSQL Dump based backup using pipe
Next
From: girish R G peetle
Date:
Subject: Re: PostgreSQL Dump based backup using pipe