Re: minimum hardware requirements for small postgres db - Mailing list pgsql-novice
From | jody |
---|---|
Subject | Re: minimum hardware requirements for small postgres db |
Date | |
Msg-id | CAKbzMGfzwPGVXgQzFn21Ea1zhsAXxsSQB-otizchVLrsK1mxjw@mail.gmail.com Whole thread Raw |
In response to | Re: minimum hardware requirements for small postgres db (Paul Smith <paul.smithy987@gmail.com>) |
Responses |
Re: minimum hardware requirements for small postgres db
|
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. > >
pgsql-novice by date: