Re: pg_dump and disk full

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump and disk full
Date: 2018-09-01 14:43:55
Message-ID: 30150.1535813035@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ron <ronljohnsonjr(at)gmail(dot)com> writes:
> Will the v9.6 pg_dump exit with a non-zero exit code if the dump volume runs
> out of space?

It'll report any error reported by fwrite/fputc/fclose. But we didn't
add a forced fsync of the output file till later, so perhaps there are
some filesystems where you might not find out about trouble ...

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Keith 2018-09-01 15:57:28 Re: Can we exclude errors of some particular text in Postgres log file?
Previous Message Evan Bauer 2018-09-01 14:29:50 Re: Archive to secondary Postgres instance