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