Re: PG over NFS

On Mar 26, 2007, at 5:19 PM, Yang wrote:

> On 3/26/07, A.M. agentm-at-themactionfaction.com |postgresql|
> <...> wrote:
>>
>> On Mar 26, 2007, at 19:29 , Yang wrote:
>>
>> >
>> > The environments involve two small devices - one with a flash disk
>> > (the NFS server), and a slave which network-boots off that. Hence
>> > these suggestions don't address the problem. (Would all the
>> > alternative protocols listed at the top be able to coexist with the
>> > described environment? Both devices must be able to boot into
>> Linux.)
>>
>> Since you're booting from the NFS server, it would make more sense to
>> have your boot process start a postgresql instance from a copy of the
>> data directory instead of over NFS, no? Certainly, that way, you can
>> have multiple instances booted and running. Do you need to sync back
>> to the NFS server?
>
> The second device has no non-volatile storage. (Sorry I should've
> explicitly stated this.)

I might have missed something in the thread, but is there any
reason why you can't run the database on the first device, using
the local storage, and then connect to it from the second?

Cheers,
Steve