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

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

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Michael Leshchenko" <Michael(dot)Leshchenko(at)its(dot)fh-giessen(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: File system level backup with more than one cluster folders
Date: 2008-12-10 14:15:26
Message-ID: dcc563d10812100615y400ec5c3lbba7ae54440239ed@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Wed, Dec 10, 2008 at 12:26 AM, Michael Leshchenko
<Michael(dot)Leshchenko(at)its(dot)fh-giessen(dot)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.

In response to

pgsql-admin by date

Next:From: Simon RiggsDate: 2008-12-10 17:56:11
Subject: Re: warm standby server
Previous:From: Marcelo MartinsDate: 2008-12-10 13:08:19
Subject: Re: moving users/roles from one server to another?

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