Groups > comp.databases.postgresql > #415

Re: Backup strategy

From	gargoyle60 <gargoyle60@example.invalid>
Newsgroups	comp.databases.postgresql
Subject	Re: Backup strategy
Date	2012-10-22 09:39 +0100
Organization	A noiseless patient Spider
Message-ID	<6i1a88pllc7cnc2p49lo8stcoea7irikl7@4ax.com> (permalink)
References	<d89388l86t741jeed9sq501cbkgtr1kqfj@4ax.com> <5083fe0d$0$287$14726298@news.sunsite.dk>

Show all headers | View raw

On Sun, 21 Oct 2012 15:52:12 +0200, Jens Henrik Leonhard Jensen <jhlj@statsbiblioteket.dk> wrote:

>On 19/10/12 21:08, gargoyle60 wrote:
>> I am considering various approaches to data backup on single-user standalone desktop Windows (XP)
>> file system and was wondering if it is safe to simply shut down the server, physically copy the data
>> files from "C:\Program Files\PostgreSQL\9.0\data" and then restart the server. Restoring would do
>> similar, copying backups back to the \data directory.
>>
>> Is this a safe method?
>
>Yes.
>
>What you describe is one of the recommended methods.
>See http://www.postgresql.org/docs/9.0/static/backup-file.html
>
>/Jens Henrik

Thanks, nice to have it confirmed.

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Backup strategy gargoyle60 <gargoyle60@example.invalid> - 2012-10-19 20:08 +0100
  Re: Backup strategy Jens Henrik Leonhard Jensen <jhlj@statsbiblioteket.dk> - 2012-10-21 15:52 +0200
    Re: Backup strategy gargoyle60 <gargoyle60@example.invalid> - 2012-10-22 09:39 +0100

csiph-web