Re: minimum hardware requirements for small postgres db - Mailing list pgsql-novice

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.smithy987@gmail.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@efji.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@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Paul Smith
Sent: Wednesday, February 20, 2013 7:50 AM
To: pgsql-novice@postgresql.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.