Re: minimum hardware requirements for small postgres db

In this mailing list, please add replies at the end, like I have done -
thanks.

On 23/02/13 02:12, jody wrote:
> A friend of mine who works mainly on Windows installed a virtual Linux
> Machine (i think with VirtualBox) to make use of linux applications.
> However, i don't know if postgres would like this...
>
> jody
>
> On Fri, Feb 22, 2013 at 7:13 AM, Paul Smith <paul(dot)smithy987(at)gmail(dot)com> wrote:
>> Thanks for your advice. It is very interesting you were able to run pg on a
>> SD card in a RasPi ! In addition to Wolgang's last reply, that confirms I
>> was misinformed last year when I originally settled on pg as my 1st choice,
>> hsqldb being 2nd choice, but then rejected pg in favour of hsqldb, as told
>> the former needs stronger hw than I use.
>>
>> Regarding yours and Gavin's recommendation I change to Linux, I have made
>> such an investment in Windows ever since it overlayed DOS, use so many
>> Windows dependant programs, it would be a major investment in time to start
>> again in Linux.
>>
>> I have monitored the progress of Linux, particularly Ubuntu over the
>> decades, and sadly have always found some reason not to change. I stopped
>> using big desktops years ago due to travel needs, and read a big problem
>> using Linux on new laptops/nettops was lack of Driver support from
>> manufacturers ... causing lots of headaches. Recently, I read the change of
>> 'Desktop' to Unity needs maturing. I do realise open-source encourages
>> healthy creativity, and so diversity, but just the other week I read
>> 'fragmentation' of Linux into so many flavours causes big problems
>> supporting Apps.
>>
>> Another reason your mention of pg on RasPi was so interesting, is I am
>> thinking to buy something smaller than a Nettop, to use primarily as a
>> media-streamer to TV, but also be a 'backup computer' in case my Nettop
>> breaks - as it just has. The choice on ARM hw has to be Linux or the
>> Android fork. If ARM, I was thinking of the Tegra3 based OUYA, unless a T4
>> or other faster SoC alternative becomes available. So following the news on
>> development of Ubuntu for ARM devices with interest.
>>
>> So as per my last post to Wolfgang, I will install pg once my Nettop
>> repaired or replaced.
>>
>> Thanks, Paul
>>
>> On 21 February 2013 15:00, Matt Musgrove <MMusgrove(at)efji(dot)com> wrote:
>>> I regularly use PostgreSQL on a system with an Atom processor and 4GB of
>>> RAM and running CentOS (no problems even on the one box with only 2GB of
>>> RAM). I have even tinkered with PostgreSQL on a Raspberry Pi with 256 MB of
>>> RAM running off of an 8 GB SD card.
>>>
>>>
>>>
>>> I agree with everyone else that moving to Linux will be a wise decision
>>> both for security and usability.
>>>
>>>
>>>
>>> HTH,
>>>
>>> Matt
>>>
>>>
>>>
>>> From: pgsql-novice-owner(at)postgresql(dot)org
>>> [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Paul Smith
>>> Sent: Wednesday, February 20, 2013 7:50 AM
>>> To: pgsql-novice(at)postgresql(dot)org
>>> Subject: [NOVICE] minimum hardware requirements for small postgres db
>>>
>>>
>>>
>>> I am having difficulty finding documentation stating the minimum hardware
>>> requirements to run pg under Windows. (I did look in the FAQ & User Manual)
>>>
>>>
>>>
>>> I seek an open source RDBMS with close adherance to ANSI standards, good
>>> free graphic design tools for drawing of the ER Diagram, validation of the
>>> ERD model, and generation of the SQL required to build the DB.
>>>
>>>
>>>
>>> I only want to design a few small DB Apps using about 20 tables, for
>>> single-user offline environment, hopefully runnable on Nettop class hardware
>>> under WinXP or Win7 32bit.
>>>
>>>
>>>
>>> I want to access the db via a Forms driven GUI and a Report-writer with
>>> features comparable to old versions of Access, but preferably also
>>> open-source.
>>>
>>>
>>>
>>> If Atom class nettop not sufficient, would like to know the minimum class
>>> of CPU, RAM, GPU required.
>>>
>>>
>>>
>>> Thank you in advance for any assistance
>>>
>>> This e-mail transmission, and any documents, files or previous e-mail
>>> messages attached to it, may contain confidential information. If you are
>>> not the intended recipient, or a person responsible for delivering it to the
>>> intended recipient, you are hereby notified that any disclosure,
>>> distribution, review, copy or use of any of the information contained in or
>>> attached to this message is STRICTLY PROHIBITED. If you have received this
>>> transmission in error, please immediately notify us by reply e-mail, and
>>> destroy the original transmission and its attachments without reading them
>>> or saving them to disk. Thank you.
>>
>
You might find running a MIcorosoft O/S under KVM in Linux more useful.