Re: How to do hot backup using postgres

Can anyone answer me ?
Thanks you very much

Tuan Hoang Anh

On Sat, Aug 14, 2010 at 10:00 AM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:

> I tried to do pitr backup using Postgres 8.3.9 on windows. So I issued
> SELECT pg_start_backup('test');
> After I put the db in backup mode I tried to zip the data directory files
> with 7z. However I encountered the following errors:
>
> The process cannot access the file because it is being used by another
> process.
> C:\...\8.3\data\global1214
> The process cannot access the file because it is being used by another
> process.
> C:\...\8.3\pg_xlog\00000001000000070000001B
> ...
> ...
> But zip file was created.
> Is it error ? How can I zip the files and perform a hot backup on windows?
>
>