A bit of pedanticism:
> So we would like to know how you recommend copying PostgreSQL database files in Windows OS to perform file system level backups.
(For Example – The recommended way in Linux is to use tar format.)
That is not what a file-system-level back up is, and not what tar does at all. Tar basically creates a file that contains other files, and would be subject to the same issues a copy would be.
A file-system level backup is just that, a backup done by the file system itself, usually via an atomic snapshot. LVM, ZFS, and BTFS are all capable of doing this in Linux and *BSD. The filesystem will store the current state of the filesystem somewhere in an atomic manner, i.e. nothing else happens when the snapshot is made.
I think NTFS can do volume shadow copies, but I havn't used windows in perhaps a decade and have never done so as an admin or professionally.
Jim
On Mon, May 14, 2018 at 7:22 AM, Yashwanth Govinda Setty <ygovindasetty@xxxxxxxxxxxxx> wrote:
Hi all,
We are facing this problem while performing file system level backup of database files:
As each database will form a directory inside Base directory which consists of files representing the tables, when some tables are dropped during backup, We get error while copying since the files do not exist anymore.
So we would like to know how you recommend copying PostgreSQL database files in Windows OS to perform file system level backups.
(For Example – The recommended way in Linux is to use tar format.)
Thanks,
Yashwanth
***************************Legal Disclaimer******************** ******* "This communication may contain confidential and privileged material for thesole use of the intended recipient. Any unauthorized review, use or distributionby others is strictly prohibited. If you have received the message by mistake,please advise the sender by reply email and delete the message. Thank you."************************************************************ **********
