is pg_standby over nfs expected to work?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "postgres general" <pgsql-general(at)postgresql(dot)org>
Subject: is pg_standby over nfs expected to work?
Date: 2007-03-01 22:11:05
Message-ID: b42b73150703011411h287bde5dla206b4c7e270ea93@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have been experimenting with pg_standby with the primay copying
files to a nfs folder mounted from a special server on the standby.
Inevitably, the following happens:

LOG: restored log file "0000000100000000000000E7" from archive
LOG: restored log file "0000000100000000000000E8" from archive
LOG: restored log file "0000000100000000000000E9" from archive
LOG: could not fsync segment 0 of relation 1663/21119/2673: No such
file or dir ectory
CONTEXT: xlog redo checkpoint: redo 0/E9047EC8; undo 0/0; tli 1; xid
0/20369249 ; oid 24584; multi 1; offset 0; online
FATAL: storage sync failed on magnetic disk: No such file or directory
CONTEXT: xlog redo checkpoint: redo 0/E9047EC8; undo 0/0; tli 1; xid
0/20369249 ; oid 24584; multi 1; offset 0; online
LOG: startup process (PID 30031) exited with exit code 1
LOG: aborting startup due to startup process failure
LOG: logger shutting down

I'm thinking one of two things is wrong, either I'm not mounting the
nfs folder in a suitable way to do this, or I have to revert to
shipping wal files with nc. anybody have any ideas?

merlin

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Johnston 2007-03-01 23:37:30 Re: Assistance with Query Optimisation?
Previous Message Tom Lane 2007-03-01 22:00:32 Re: strange behaviour with sub-select and pl/pgSQL