Re: PostgreSQL server embedded in NAS firmware?

On 09/06/2012 04:19 PM, Scott Marlowe wrote:
> That shouldn't really matter. Either the db is just on the NAS in
> which case as long as pg compiles on it then the client on the main
> unit shouldn't matter, or the data is just stored there and the db is
> on the main unit, client and all and again it wouldn't matter.
>
> But the client and server do NOT have to be the same architecture to
> work for sure.

If I understood the OP, it is not client <--> server, it is:
main server <--> replication server

In that case architecture would matter.

>
> On Thu, Sep 6, 2012 at 4:40 PM, Andrew Barnham <andrew(dot)barnham(at)gmail(dot)com> wrote:
>> Scratch that. An immediate show stopping pitfall occurs to me: the necessity
>> to match CPU/OS Architecture between primary server and replicate target.
>> Doubtful that there are any consumer NAS products out there running linux on
>> 64bit/intel
>>
>>
>> On Fri, Sep 7, 2012 at 8:23 AM, Andrew Barnham <andrew(dot)barnham(at)gmail(dot)com>
>> wrote:
>>>
>>> Hi
>>>
>>> I currently run a modest streaming replication target on a cheap, single
>>> disk ASUS media center; replicating a 100GB PG database.
>>>
>>> I want to add RAID via a consumer grade NAS device.
>>>
>>> As far as I can tell consumer grade NAS devices these days appear to be
>>> fairly rich & flexible embedded lniux/freebsd systems.
>>>
>>> Has anyone had any experience with running postgresql on the NAS device
>>> itself? Which products? Any traps or pitfalls or integrity concerns about
>>> such an arrangement?
>>>
>>> Andrew
>>
>>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com