is pg_standby over nfs expected to work? - Mailing list pgsql-general

From Merlin Moncure
Subject is pg_standby over nfs expected to work?
Date
Msg-id b42b73150703011411h287bde5dla206b4c7e270ea93@mail.gmail.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: strange behaviour with sub-select and pl/pgSQL
Next
From: Shaun Johnston
Date:
Subject: Re: Assistance with Query Optimisation?