[done] PostgreSQL

[damNageHack]

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.

[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

[damNageHack]

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

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.

[Duncan_Idaho]

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

Code: Select all

groupadd 209 postgres

-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

[damNageHack]

Nice. Thx. Will try it next week.

[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 )

[gapan]

- 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...