Re: PG over NFS - Mailing list pgsql-general

From Steve Atkins
Subject Re: PG over NFS
Date
Msg-id 305A4978-99BC-47E0-BCFB-C58C9B83988E@blighty.com
Whole thread Raw
In response to Re: PG over NFS  ("Yang" <jkfe7q002@sneakemail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PG over NFS
Next
From: "Robert James"
Date:
Subject: pg_dump without psql rights