Re: tablespaces a priority for 7.5? - Mailing list pgsql-general

From John Sidney-Woollett
Subject Re: tablespaces a priority for 7.5?
Date
Msg-id 1405.192.168.0.64.1074792638.squirrel@mercury.wardbrook.com
Whole thread Raw
In response to Re: tablespaces a priority for 7.5?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: tablespaces a priority for 7.5?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane said:
> The planned PITR feature would not require you to take anything offline.
> The whole concept of an "offline" database is an Oracle-ism that I see
> no value in emulating.

> I dunno what a "dump file" would equate to in Postgres terms, but yeah,
> we're envisioning using ordinary filesystem tools (tar, say) as the
> mechanism for handling a baseline backup.

(I think) that was the point I was trying to make. Oracle lets you backup
while up and running (using export) OR when offline (copying db files)...

However, it looks like postgres will require a file system level backup to
recover from. Or will you be able to build a new db from the dump file,
and then apply the WAL segments?

John Sidney-Woollett




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Lost plpgsql function
Next
From: Culley Harrelson
Date:
Subject: regex in plpgsql function