Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

[no subject]


  • From: "Mikko Partio" <dun(at)haisuli(dot)net>
  • To: "Nico Sabbi" <nsabbi(at)officinedigitali(dot)it>
  • Cc: pgsql-general(at)postgresql(dot)org
  • Subject:
  • Date: Mon, 16 Apr 2007 18:41:20 +0300 (EEST)
  • Message-id: <59813.2001:14b8:1b0:0:216:d4ff:fe03:2af0(dot)1176738080(dot)squirrel(at)haisuli(dot)net>

Nico Sabbi wrote:
>
>
> but "cp /tmp/pg//000000010000000000000021 pg_xlog/RECOVERYXLOG" looks
suspicious to me.
>

Works for me [clip from process listing]:

postgres 12864 12863  0 18:36 ?        00:00:00     cp
/wal/00000001000000E100000035 pg_xlog/RECOVERYXLOG

I think RECOVERYXLOG should be overwritten every time (the -l mode also
recreates RECOVERYXLOG link that points to the latest wal).

BTW thanks to Simon Riggs for pg_standby, it works very well!

Regards

MP





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group