Re: Point in Time Recovery - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Point in Time Recovery
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA40184D170@m0114.s-mxs.net
Whole thread Raw
In response to Point in Time Recovery  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Point in Time Recovery
Re: Point in Time Recovery
List pgsql-hackers
> > I was wondering about this point - might it not be just as reasonable
> > for the copied file to *be* an exact image of pg_control?  Then a very
> > simple variant of pg_controldata (or maybe even just adding switches to
> > pg_controldata itself) would enable the relevant info to be extracted
>
> We didn't do that so admins could easily read the file contents.

If you use a readable file you will also need a feature for restore (or a tool)
to create an appropriate pg_control file, or are you intending to still require
that pg_control be the first file backed up.
Another possibility would be that the start function writes the readable file and
also copies pg_control.

Andreas


pgsql-hackers by date:

Previous
From: Mamta Singh
Date:
Subject: Regarding the logging in Postgres
Next
From: Thomas Hallgren
Date:
Subject: Re: try/catch macros for Postgres backend