Skip site navigation (1) Skip section navigation (2)

Re: File system level backup with more than one cluster folders

From: "Vladimir Rusinov" <vladimir(at)greenmice(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: File system level backup with more than one cluster folders
Date: 2008-12-11 11:58:55
Message-ID: f6fdfb550812110358q4dc40063vd79e355805e63523@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, Dec 10, 2008 at 1:13 PM, Tino Schwarze <postgresql(at)tisc(dot)de> wrote:

> Hi Mike,
>
> > I am newbie with PostgreSQL. I have separate table space for my
> > databases, which is located in separate folder, which is different to
> > default. I would like to carry out file system level backup.  Do I need
> > to backup only folder with my table space or all pg folders.
>
> Do you know that a file system level backup is only useful if
>
> a) the postgres instance is stopped
> or
> b) your are using WAL archiving and have an appropiate setup to tell PG
>   about backup starts and ends


c) your are using lvm (or zfs) snapshots and know that postgres would run
recovery after backup restore.

-- 
Vladimir Rusinov
http://greenmice.info/

In response to

pgsql-admin by date

Next:From: paulo matadrDate: 2008-12-11 18:40:13
Subject: Tool to converter plsql in pgplsql
Previous:From: AmitKumar JainDate: 2008-12-11 08:10:54
Subject: Re: Tool to converter plsql in pgplsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group