Re: minimum hardware requirements for small postgres db

Yes, I do remember Gary Kildall, S100 Bus, breadboarding and hex keyboard
programming and am glad to have left it behind long ago. I just want my
computer as a tool, and to look under the bonnet as little as is necessary,
hence my attraction to the Windows environment for its onset, where the
most obvious UI choices are clearly presented. I try not to pour money
into anything, have not invested in new MS software for a while now, and
will probably not invest in Windows 8 judging for the initial reviews.
will be offline for maybe a week now due to travel.

On 22 February 2013 16:36, Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>wrote:

> On 22/02/13 19:13, Paul Smith 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.
>>
>
> Microsoft is on the way out: it has already lost the mobile & servers
> wars to Linux, and with Metro it is trying hard (& succeeding) in losing
> the Laptop&Desktop wars! So Linux is the future. In 20 years Microsoftwill be as well
> known as CP/M (http://www.digitalresearch.biz/CPM.HTM) is now - at one
> stage CP/M was the dominant O/S for business use. I predict that the start
> of the demise of Microsoft will be well established and common knowledge
> by Christmas 2014.
>
> So I suggest you have a migration strategy, as pouring more money into
> Microsoft is beginning to be counter productive. The Microsoft ecosystem
> is already fragmented, if you look carefully. Some major games companies
> are already abandoning Microsoft in favour of Linux.
>
> I am typing this on a Linux Laptop from ZaReason:
> http://zareason.co.nz/Verix-530.html
> You could look at: http://zareason.com
>
> I currently use the Mate Desktop Environment in Fedora 17.
>
>
> Cheers,
> Gavin
>