Re: Survey on backing up unlogged tables: help us with PostgreSQL development!

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date: 2010-11-17 01:44:16
Message-ID: 4CE33370.5050701@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/16/2010 07:33 PM, Josh Berkus wrote:
>
>> With the current patches, the data survives a restart just fine.
>
> Per -hackers, that's not guarenteed.
>

Ah, I just read the thread on -hackers. And yea, my system had 24 hours to write/flush/etc before I'd restarted it moments ago as a test. I have NOT tested a bunch of writes and then quickly restarting PG. I CAN report that given 24 hours, your data will survive a restart :-)

-Andy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-11-17 01:45:00 Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Previous Message Josh Berkus 2010-11-17 01:33:47 Re: Survey on backing up unlogged tables: help us with PostgreSQL development!