seeking PITR archive_command advice

From: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: seeking PITR archive_command advice
Date: 2007-04-17 09:56:44
Message-ID: 006c01c780d6$b925d710$170211ac@LIONKING.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello All,

I am trying to set up continues archiving of WAL files.
I have some doubt about the archive command %p and %f parameter.

I am havining all 5/6 WAL files in following directory.

usr/local/pgsql/data/pg_xlog

My questions are

1) what will be the value for %p parameter
will it be
/usr/local/pgsql/data/pg_xlog ?

is yes it is giving me following error
cp: omitting directory `/usr/local/pgsql/data/pg_xlog/

2)
which file name i should give in place of %f parameter as there are 5/6 files already?

Thanks in Advance

With Regards
Ashish Karalkar

Browse pgsql-general by date

  From Date Subject
Next Message Ketema 2007-04-17 11:35:46 Re: Dynamic DDL
Previous Message garry saddington 2007-04-17 09:33:48 Re: delete with self join