Re: FW: Setting up of PITR system. - Mailing list pgsql-admin

From Andy Shellam
Subject Re: FW: Setting up of PITR system.
Date
Msg-id !&!AAAAAAAAAAAuAAAAAAAAALfqleqaijxJlxu+E5RYF+YBAJaQ0jfg6zBFp7poaER6UCkAAAGy3PcAABAAAADL3SivwDRiRYXS5tJhonpaAQAAAAA=@mailnetwork.co.uk
Whole thread Raw
In response to Re: FW: Setting up of PITR system.  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
Responses Re: FW: Setting up of PITR system.  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
Re: FW: Setting up of PITR system.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
If pg_start_backup is used correctly, no data pages will be written to disk
until pg_stop_backup is called, so this shouldn't be an issue - HOWEVER -
check that you're excluding your pg_xlog directory (within your database
directory) from the tar backup as these will be changing.

Whatever archive utility you're using, if a file is being changed at the
time of reading, it won't be archived correctly.

Andy

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rajesh Kumar Mallah
Sent: Tuesday, 28 March, 2006 5:27 PM
To: Tom Lane
Cc: andy.shellam@mailnetwork.co.uk; pgsql-admin@postgresql.org
Subject: Re: FW: [ADMIN] Setting up of PITR system.

---

secondly , i was asking about the tool for copying the
database directory not the one for archiving the logs.
when i use tar , it gives warning that the file changed
while it was reading the file, i need a tool that does not
give warning for this kind of activity.

---



pgsql-admin by date:

Previous
From: "Andy Shellam"
Date:
Subject: Re: Bloated pg_shdepend_depender_index
Next
From: Ola Sandbu
Date:
Subject: Re: Bloated pg_shdepend_depender_index