pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedFile system level backup with more than one cluster folders
4+ messages / 4 participants
[nested] [flat]
* File system level backup with more than one cluster folders
@ 2008-12-10 07:26 Michael Leshchenko <Michael.Leshchenko@its.fh-giessen.de>
0 siblings, 2 replies; 4+ messages in thread
From: Michael Leshchenko @ 2008-12-10 07:26 UTC (permalink / raw)
To: pgsql-admin
Dear pg community
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.
Thank you in advance
Mike Leshchenko
Attachments:
Michael_Leshchenko.vcf (text/x-vcard, 278B) download
begin:vcard
fn:Michael Leshchenko
n:Leshchenko;Michael
org;quoted-printable:FH Gie=C3=9Fen-Friedberg;ITS
adr:;;Wiesenstr. 14;Giessen;Hessen;35390;Germany
email;internet:michael.leshchenko@its.fh-giessen.de
tel;work:(+49)641 3091279
tel;cell:(+49)1778096776
version:2.1
end:vcard
* Re: File system level backup with more than one cluster folders
@ 2008-12-10 10:13 Tino Schwarze <postgresql@tisc.de>
parent: Michael Leshchenko <Michael.Leshchenko@its.fh-giessen.de>
1 sibling, 1 reply; 4+ messages in thread
From: Tino Schwarze @ 2008-12-10 10:13 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: File system level backup with more than one cluster folders
@ 2008-12-10 14:15 Scott Marlowe <scott.marlowe@gmail.com>
parent: Michael Leshchenko <Michael.Leshchenko@its.fh-giessen.de>
1 sibling, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2008-12-10 14:15 UTC (permalink / raw)
To: Michael Leshchenko <Michael.Leshchenko@its.fh-giessen.de>; +Cc: pgsql-admin
On Wed, Dec 10, 2008 at 12:26 AM, Michael Leshchenko
<Michael.Leshchenko@its.fh-giessen.de> wrote:
> Dear pg community
>
> 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.
Quick question, why? If you really need it, you need to shutdown
pgsql and then run the file system backup of all the directories that
pg uses. But a pg_dumpall is a much better way to take a backup.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: File system level backup with more than one cluster folders
@ 2008-12-11 11:58 Vladimir Rusinov <vladimir@greenmice.info>
parent: Tino Schwarze <postgresql@tisc.de>
0 siblings, 0 replies; 4+ messages in thread
From: Vladimir Rusinov @ 2008-12-11 11:58 UTC (permalink / raw)
To: pgsql-admin
On Wed, Dec 10, 2008 at 1:13 PM, Tino Schwarze <postgresql@tisc.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/
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-12-11 11:58 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-12-10 07:26 File system level backup with more than one cluster folders Michael Leshchenko <Michael.Leshchenko@its.fh-giessen.de>
2008-12-10 10:13 ` Tino Schwarze <postgresql@tisc.de>
2008-12-11 11:58 ` Vladimir Rusinov <vladimir@greenmice.info>
2008-12-10 14:15 ` Scott Marlowe <scott.marlowe@gmail.com>
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