Re: Recommended way to copy database files on Windows OS (to performfile system level backup)

Поиск
Список
Период
Сортировка
От Allan Kamau
Тема Re: Recommended way to copy database files on Windows OS (to performfile system level backup)
Дата
Msg-id CAF3N6oT2rVvTujm7Zho0JVa8duEx9nZO0V4X5xkk3iEEn2je6A@mail.gmail.com
обсуждение исходный текст
Ответ на Recommended way to copy database files on Windows OS (to perform filesystem level backup)  (Yashwanth Govinda Setty <ygovindasetty@commvault.com>)
Ответы Re: Recommended way to copy database files on Windows OS (to perform file system level backup)  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general


On Mon, May 14, 2018 at 2:22 PM, Yashwanth Govinda Setty <ygovindasetty@commvault.com> 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 the
sole use of the intended recipient. Any unauthorized review, use or distribution
by 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."
**********************************************************************

An easy way to perform backup of your data is to use PostgreSQL's very own pg_dump utility.

В списке pgsql-general по дате отправления:

Предыдущее
От: James Keener
Дата:
Сообщение: Re: Recommended way to copy database files on Windows OS (to performfile system level backup)
Следующее
От: Christoph Moench-Tegeder
Дата:
Сообщение: Re: Recommended way to copy database files on Windows OS (to performfile system level backup)