Page 1 of 1
[done] PostgreSQL
Posted: 23. Jan 2010, 16:45
by damNageHack
http://www.postgresql.org/ wrote:PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
(...)
An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.
Comparison of features, PostgreSQL vs. MySQL:
http://www.enterprisedb.com/openDownloa ... erDownload
Please no flamewar about the "best" DBMS on the world here, thanks.
Download:
http://www.enterprisedb.com/products/pg ... d.do#linux
Possibly I will build this package for my own. But maybe somebody is faster than me
And there is an installer available, I don't know how dirty it is.
Re: PostgreSQL
Posted: 23. Jan 2010, 19:51
by Duncan_Idaho
why not use the slackbuild.org script?
it works fine for me
http://slackbuilds.org/repository/13.0/ ... ostgresql/
a package in the repos would be nice too
Re: PostgreSQL
Posted: 23. Jan 2010, 21:17
by damNageHack
Could you please then provide one?
BTW: It is not so difficult to port a SlackBuild to SLKBUILD and then use slkbuild. But the SlackBuild itself is also okay, but then harder to fix bugs with it.
Re: PostgreSQL
Posted: 24. Jan 2010, 21:27
by Duncan_Idaho
damNageHack wrote:Could you please then provide one?
BTW: It is not so difficult to port a SlackBuild to SLKBUILD and then use slkbuild. But the SlackBuild itself is also okay, but then harder to fix bugs with it.
I'll make a package using the slackbuild first, and then I'm gonna try porting it to SLKBUILD and submit it to inclusion in te repo, but It gonna take a while
things you need to do before install:
-install tcl
-create a postgres group
-create a postgres user
Code: Select all
useradd -u 209 -g 209 -d /var/lib/pgsql postgres
after install you need to do
Code: Select all
su postgres -c "initdb -D /var/lib/pgsql/data"
here is a package por salix64:
http://informatica.utem.cl/~rrojas/sali ... -1_SBo.tgz
I'll do one for i486 later
Re: PostgreSQL
Posted: 24. Jan 2010, 21:34
by damNageHack
Nice. Thx. Will try it next week.
Re: PostgreSQL
Posted: 26. Jan 2010, 21:07
by damNageHack
Your package looks nice, but you should consider about following suggestions if you want to provide it for official repository. Gapan will possibly tell you similiar things
- All files under etc/rc.d and etc/logrotate.d should not be dot new threaded. Users should not edit those files generally.
- What is the purpose of these code in install/doinst.sh? I think it can be done directly in SlackBuild (build() if you use SLKBUILD) and then symlinks will be handled by makepkg?
( cd usr/bin ; rm -rf postmaster )
( cd usr/bin ; ln -sf postgres postmaster )
( cd usr/lib64 ; rm -rf libpgtypes.so.3 )
( cd usr/lib64 ; ln -sf libpgtypes.so.3.1 libpgtypes.so.3 )
( cd usr/lib64 ; rm -rf libecpg_compat.so.3 )
( cd usr/lib64 ; ln -sf libecpg_compat.so.3.1 libecpg_compat.so.3 )
( cd usr/lib64 ; rm -rf libpgtypes.so )
( cd usr/lib64 ; ln -sf libpgtypes.so.3.1 libpgtypes.so )
( cd usr/lib64 ; rm -rf libecpg.so.6 )
( cd usr/lib64 ; ln -sf libecpg.so.6.1 libecpg.so.6 )
( cd usr/lib64 ; rm -rf libecpg.so )
( cd usr/lib64 ; ln -sf libecpg.so.6.1 libecpg.so )
( cd usr/lib64 ; rm -rf libpq.so )
( cd usr/lib64 ; ln -sf libpq.so.5.2 libpq.so )
( cd usr/lib64 ; rm -rf libecpg_compat.so )
( cd usr/lib64 ; ln -sf libecpg_compat.so.3.1 libecpg_compat.so )
( cd usr/lib64 ; rm -rf libpq.so.5 )
( cd usr/lib64 ; ln -sf libpq.so.5.2 libpq.so.5 )
Re: PostgreSQL
Posted: 26. Jan 2010, 21:34
by gapan
damNageHack wrote:- What is the purpose of these code in install/doinst.sh? I think it can be done directly in SlackBuild (build() if you use SLKBUILD) and then symlinks will be handled by makepkg?
( cd usr/bin ; rm -rf postmaster )
( cd usr/bin ; ln -sf postgres postmaster )
( cd usr/lib64 ; rm -rf libpgtypes.so.3 )
( cd usr/lib64 ; ln -sf libpgtypes.so.3.1 libpgtypes.so.3 )
( cd usr/lib64 ; rm -rf libecpg_compat.so.3 )
( cd usr/lib64 ; ln -sf libecpg_compat.so.3.1 libecpg_compat.so.3 )
( cd usr/lib64 ; rm -rf libpgtypes.so )
( cd usr/lib64 ; ln -sf libpgtypes.so.3.1 libpgtypes.so )
( cd usr/lib64 ; rm -rf libecpg.so.6 )
( cd usr/lib64 ; ln -sf libecpg.so.6.1 libecpg.so.6 )
( cd usr/lib64 ; rm -rf libecpg.so )
( cd usr/lib64 ; ln -sf libecpg.so.6.1 libecpg.so )
( cd usr/lib64 ; rm -rf libpq.so )
( cd usr/lib64 ; ln -sf libpq.so.5.2 libpq.so )
( cd usr/lib64 ; rm -rf libecpg_compat.so )
( cd usr/lib64 ; ln -sf libecpg_compat.so.3.1 libecpg_compat.so )
( cd usr/lib64 ; rm -rf libpq.so.5 )
( cd usr/lib64 ; ln -sf libpq.so.5.2 libpq.so.5 )
That's fine damnagehack...