From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: File system level backup with more than one cluster folders
Date: Wed, 10 Dec 2008 11:13:04 +0100
Message-ID: <20081210101304.GB21211@easy2.in-chemnitz.de> (raw)
In-Reply-To: <493F6F40.9060906@its.fh-giessen.de>
References: <493F6F40.9060906@its.fh-giessen.de>
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
You need to backup any file system structure belonging to your PG
database.
HTH,
Tino.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: postgresql@tisc.de
Subject: Re: File system level backup with more than one cluster folders
In-Reply-To: <20081210101304.GB21211@easy2.in-chemnitz.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox