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
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 |