Обсуждение: PostgreSQL on Embeded Systems

Hi,

I am sory for my bad English :)


We try to use PostgreSQL on an Embeded System.

Plan to use this PC/104 Module
http://www.icop.com.tw/products_detail.asp?ProductID=106


and this EmbedDisk
http://www.icop.com.tw/products_detail.asp?ProductID=185


There is a Linux version (X-Linux) for the PC/104 Module.
http://www.dmp.com.tw/tech/os-xlinux/

This Linux looks enough for our project.

We instal X-Linux on PC/104 Module.

Now, We want to install PostgreSQL

but there are some problems

1 - Firstly,  Can we install PostgreSQL on this X-Linux?

2 - Our EmbedDisk capacity is 128 Mb.
    X-Linux size approximately 32Mb.

    Our expectation, PostgreSQL operate standart query on basic tables
    and listen 5432 port.

    A program collect data from peripheral devices, insert this data
    into PostgreSQL database. Another program access this database by use 5432
    port, read and delete data.

    We want to use PostgreSQL on PC/104 Module  because we already use
    PostgreSQL for other part of the project.

    We have a capacity problem, so PostgreSQL installation and
    database tables must be configure to smaller size.

    How can we do this? suggestion,information, document...

    How much the PostgreSQL installation size?


    Thanks,

On Tuesday 18 July 2006 05:50 am, Adem HUR <ademhur@gmail.com> thus
communicated:
--> Hi,
-->
--> I am sory for my bad English :)
-->
-->
--> We try to use PostgreSQL on an Embeded System.
-->
--> Plan to use this PC/104 Module
--> http://www.icop.com.tw/products_detail.asp?ProductID=106
-->
-->
--> and this EmbedDisk
--> http://www.icop.com.tw/products_detail.asp?ProductID=185
-->
-->
--> There is a Linux version (X-Linux) for the PC/104 Module.
--> http://www.dmp.com.tw/tech/os-xlinux/
-->
--> This Linux looks enough for our project.
-->
--> We instal X-Linux on PC/104 Module.
-->
--> Now, We want to install PostgreSQL
-->
--> but there are some problems
-->
--> 1 - Firstly,  Can we install PostgreSQL on this X-Linux?
-->
--> 2 - Our EmbedDisk capacity is 128 Mb.
-->     X-Linux size approximately 32Mb.
-->
-->     Our expectation, PostgreSQL operate standart query on basic tables
-->     and listen 5432 port.
-->
-->     A program collect data from peripheral devices, insert this data
-->     into PostgreSQL database. Another program access this database by use
 5432 -->     port, read and delete data.
-->
-->     We want to use PostgreSQL on PC/104 Module  because we already use
-->     PostgreSQL for other part of the project.
-->
-->     We have a capacity problem, so PostgreSQL installation and
-->     database tables must be configure to smaller size.
-->
-->     How can we do this? suggestion,information, document...
-->
-->     How much the PostgreSQL installation size?
-->
-->
-->     Thanks,
-->
-->
-->
--> ---------------------------(end of broadcast)---------------------------
--> TIP 3: Have you checked our extensive FAQ?
-->
-->                http://www.postgresql.org/docs/faq
-->
From the 7.4.6 documentation:
Also check that you have sufficient disk space. You will need about 65 MB for
the source tree during compilation and about 15 MB for the installation
directory. An empty database cluster takes about 25 MB, databases take about
five times the amount of space that a flat text file with the same data would
take. If you are going to run the regression tests you will temporarily need
up to an extra 90 MB. Use the df command to check for disk space.

This includes space required for compiling the application. Looks like about
40 MB for the installation and an empty cluster.

On Tuesday 18 July 2006 07:18, Terry Lee Tucker wrote:
> On Tuesday 18 July 2006 05:50 am, Adem HUR <ademhur@gmail.com> thus
> communicated:
> --> Hi,
> -->
> --> I am sory for my bad English :)
> -->
> -->
> --> We try to use PostgreSQL on an Embeded System.
> -->
> --> Plan to use this PC/104 Module
> --> http://www.icop.com.tw/products_detail.asp?ProductID=106
> -->
> -->
> --> and this EmbedDisk
> --> http://www.icop.com.tw/products_detail.asp?ProductID=185
> -->
> -->
> --> There is a Linux version (X-Linux) for the PC/104 Module.
> --> http://www.dmp.com.tw/tech/os-xlinux/
> -->
> --> This Linux looks enough for our project.
> -->
> --> We instal X-Linux on PC/104 Module.
> -->
> --> Now, We want to install PostgreSQL
> -->
> --> but there are some problems
> -->
> --> 1 - Firstly,  Can we install PostgreSQL on this X-Linux?
> -->
> --> 2 - Our EmbedDisk capacity is 128 Mb.
> -->     X-Linux size approximately 32Mb.
> -->
> -->     Our expectation, PostgreSQL operate standart query on basic tables
> -->     and listen 5432 port.
> -->
> -->     A program collect data from peripheral devices, insert this data
> -->     into PostgreSQL database. Another program access this database by
> use 5432 -->     port, read and delete data.
> -->
> -->     We want to use PostgreSQL on PC/104 Module  because we already use
> -->     PostgreSQL for other part of the project.
> -->
> -->     We have a capacity problem, so PostgreSQL installation and
> -->     database tables must be configure to smaller size.
> -->
> -->     How can we do this? suggestion,information, document...
> -->
> -->     How much the PostgreSQL installation size?
> -->
> -->
> -->     Thanks,
> -->
> -->
> -->
> --> ---------------------------(end of
> broadcast)--------------------------- --> TIP 3: Have you checked our
> extensive FAQ?
> -->
> -->                http://www.postgresql.org/docs/faq
> -->
> From the 7.4.6 documentation:
> Also check that you have sufficient disk space. You will need about 65 MB
> for the source tree during compilation and about 15 MB for the installation
> directory. An empty database cluster takes about 25 MB, databases take
> about five times the amount of space that a flat text file with the same
> data would take. If you are going to run the regression tests you will
> temporarily need up to an extra 90 MB. Use the df command to check for disk
> space.
>
> This includes space required for compiling the application. Looks like
> about 40 MB for the installation and an empty cluster.

Well, certainly you aren't going to want to be compiling from source and
running full regression on each install... I'd think you would want some type
of imaged configuration set up... for example dropping the template0,
template1, and postgres databases once you have your database installed.
There are other things that can be done too... check the archives as others
have wieghed in on this topic before.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL