Robert Haas <robertmh...@gmail.com> writes: > On Tue, Nov 16, 2010 at 1:58 PM, Alvaro Herrera >> I think if you do a regular backup of the complete database, unlogged >> tables should come out empty, but if you specifically request a dump of >> it, it shouldn't.
> Oh, wow. That seems confusing. I don't like it either. I think allowing pg_dump to dump the data in an unlogged table is not only reasonable, but essential. Imagine that someone determines that his reliability needs will be adequately served by unlogged tables plus hourly backups. Now you're going to tell him that that doesn't work because pg_dump arbitrarily excludes the data in unlogged tables? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers