Re: pg_dump fails on temp tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Artem Tomyuk <admin(at)leboutique(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump fails on temp tables
Date: 2016-04-04 13:52:37
Message-ID: 28545.1459777957@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Artem Tomyuk <admin(at)leboutique(dot)com> writes:
> Why pg_dump trying to dump temp tables?

It's not supposed to, and as far as I can tell in some simple tests,
it doesn't unless you force it to with something like -t 'pg_temp*.*'.

Are you sure those tables are actually temp? What version of pg_dump is
that exactly?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2016-04-04 14:02:18 Re: PostgreSQL 9.3.5 - Enable SSL
Previous Message Artem Tomyuk 2016-04-04 08:58:26 pg_dump fails on temp tables