Re: minimum hardware requirements for small postgres db

Поиск
Список
Период
Сортировка
От jody
Тема Re: minimum hardware requirements for small postgres db
Дата
Msg-id CAKbzMGfzwPGVXgQzFn21Ea1zhsAXxsSQB-otizchVLrsK1mxjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: minimum hardware requirements for small postgres db  (Paul Smith <paul.smithy987@gmail.com>)
Ответы Re: minimum hardware requirements for small postgres db  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Список 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 по дате отправления:

Предыдущее
От: Paul Smith
Дата:
Сообщение: Re: minimum hardware requirements for small postgres db
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: PostgreSQL Query Speed Issues