Re: : PostgreSQL Online Backup - Mailing list pgsql-general

From Albe Laurenz
Subject Re: : PostgreSQL Online Backup
Date
Msg-id D960CB61B694CF459DCFB4B0128514C206E9FB93@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: : PostgreSQL Online Backup  (Venkat Balaji <venkat.balaji@verse.in>)
Responses Re: : PostgreSQL Online Backup  (Venkat Balaji <venkat.balaji@verse.in>)
List pgsql-general
Venkat Balaji wrote:
> Our problem is -
>
> We had mistakenly executed  "rsync" on the running PostgreSQL data
directory (production) and we did
> not run "pg_start_backup()".
>
> Will this harm production ? can this lead to corruption ?

I assume that you used rsync to copy *from* the data directory.

This cannot lead to data corruption.
Only performance might suffer temporarily due to the additional I/O.

The backup made with rsync will be unusable without pg_start_backup().

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Download States and Capitals Database
Next
From: Venkat Balaji
Date:
Subject: Re: PostgreSQL recovery when lost some file in data\global