jumpstart - pgsql.v824 - Mailing list pgsql-admin

From dx k9
Subject jumpstart - pgsql.v824
Date
Msg-id BAY116-W3375AA4C7AD7EC4B3B0FC1D18D0@phx.gbl
Whole thread Raw
Responses Re: jumpstart - pgsql.v824  ("Peter Childs" <peterachilds@gmail.com>)
Re: jumpstart - pgsql.v824  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi Everyone,

Is there any way to trick an instance into starting when you just have base, global, pg_clog, pg_mulitxact, pg_subtrans, pg_tblspc, & pg_twophase, but no pg_xlog?

 We weren't backing up the pg_xlog, because we didn't think we needed it, but the backup_label seems to need it.  Even if we take the backup_label file out, and try to start postgres, it doesn't start.

I'm going to start experimenting and testing to see if I can trick it to starting, but if anyone has any insight that would help.  We noticed this on a test restore, so it wasn't a major problem, now we are backing up the pg_xlog files as well.

~DjK



Windows Live Hotmail and Microsoft Office Outlook – together at last. Get it now!

pgsql-admin by date:

Previous
From: Jessica Richard
Date:
Subject: Re: how to check objects dependency??
Next
From: "Campbell, Lance"
Date:
Subject: How do I identify the privileges a role has?