pg_dump to fifo file on Linux

From: girish R G peetle <giri(dot)anamika0(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_dump to fifo file on Linux
Date: 2018-03-01 22:07:49
Message-ID: CAKKd06458cp8hFMBhmpuG7462DPjwGaxwB36YDNmFPrhEN06Tg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
We have a customer with database size around 1TB who wants take dump based
backed. We are planning to use FIFO file to redirect the output of 'pg_dump
-FC' . Our backup process will read the data from FIFO file and write to
storage media.
On smaller databases we tested this and we didn't face any issues.

Just wanted to confirm if we can safely redirect 'pg_dump -FC' to FIFO
file without any possible dump corruption.

Thanks
Girish

Browse pgsql-admin by date

  From Date Subject
Next Message Ted EH 2018-03-01 22:24:35 Re: WAL segment not replicated
Previous Message Andres Freund 2018-03-01 21:42:50 Re: postgresql 9.6 - cannot freeze committed xmax