DB archiving - Mailing list pgsql-admin

From Victor Yegorov
Subject DB archiving
Date
Msg-id 20030317103331.GM7181@pirmabanka.lv
Whole thread Raw
Responses Re: DB archiving
List pgsql-admin
Hello.

I was speaking with my colleague about PostgreSQL maintenance and he asked
me a question which I wasn't able to answer.

Is it possible to make a full DB backup (one database, say 'test') online
and be sure, that after restoring it it'll contain ALL and ONLY data at the
time of backuping routine start.

I want to be sure, that nothing additional will get into dump after I'll
start pg_dump.

Is this possible? Or, may be, such behaviour is on by default (I
didn't find anything concerning my problem in the docs about pg_dump).

Thank you.

--

Victor Yegorov

Attachment

pgsql-admin by date:

Previous
From: R Blake
Date:
Subject: Re: CREATELANG in pgsql 7.3.2 failing
Next
From: Ragnar KjÞrstad
Date:
Subject: Re: LVM snapshots