As posted to C.O.L.A.
New changes in Release 4 i.e postgresql-6.4.2-4*.rpm :
--------------------------------------------------------
The following are added:
1. Python interface - "import _pg" improvements: Added -lcrypt in
makefile to eliminate 'crypt errors' during "import _pg" command
Note: Other interfaces like Perl, "C", "C++", Tcl/Tk,
and ecpg (Embedded C-SQL) are already included.
PostgreSQL Version 6.4.2 Release 4 RPMs are now available
-----------------------------------------------------------
PostgreSQL is a very advanced "Open Source Code" SQL server. It is
"tremendously sophisticated" and is a very powerful SQL server. It is a
"superb" SQL database system and is the default SQL server for most of the
Linux distributions - Redhat, Debian, Slackware, etc... It's "status rank"
is same as what Apache, gcc, Linux is to Webserver, compiler, OS. It is
very fast becoming the "STANDARD SQL SERVER" engine for this world.
PostgreSQL runs on most flavors of unix - Solaris, HPUX, AIX, BSD, SCO etc.
Port to Microsoft Windows NT/95 is also taking place at a rapid pace. For
WinNT port see - http://www.askesis.nl/AskesisPostgresIndex.html
RPMS source and binaries of PostgreSQL Version 6.4.2 release 4 is at:
http://aldev.8m.com
http://aldev.webjump.com
http://www3.bcity.com/aldev/
http://members.spree.com/technology/aldev/
And at - ftp://ftp.postgresql.org/pub/.incoming
Files are postgresql-6.4.2-4*.rpm
and will be soon available at official redhat site ftp://ftp.redhat.com
More details about PostgreSQL is at http://www.postgresql.org
Instructions - Only 8 Steps !!:
--------------------------------Login as root.
# rpm -qpl postgre*.rpm (to see list of files. For docs 'man rpm')
# rpm -qpi postgre*.rpm (to see info of package)
# cat /etc/passwd | grep postgres
Note: If you see a 'postgres' user, you may need to backup and clean
up the home directory ~postgres and delete the unix user 'postgres'
or rename the unix user 'postgres' to something like 'postgres2'.
Install must be "clean slate"
# rpm -i postgre*.rpm (Must install all packages clients, devel, data
and main for pgaccess to work )
# chkconfig --add postgresql (to start pg during booting, see 'man chkconfig')
# cp /usr/lib/pgsql/python/_pg.so /usr/lib/python1.5/lib-dynload (for python)
# /etc/rc.d/init.d/postgresql start (to start up postgres)
# su - postgres
$ createdb mydatabase (this will create a database by name 'mydatabase')
(for doc 'man createdb')
$ psql mydatabase (for doc 'man psql')
For command-line history editing press UP/Down arrow keys
$ pgaccess mydatabase (for docs 'man pgaccess')
Now you can start banging away at SQL commands at pgaccess or psql !!
$ cd /usr/doc/postgresql*
Here read all the FAQs, User, Programmer, Admin guides and tutorials.
More details about PostgreSQL is at http://www.postgresql.org
**************************************************
To verify the top quality of PostgreSQL, run the Regression test package
:-
Login as root -# rpm -i postgresql*.src.rpm
# cd /usr/src/redhat/SPECS
# more postgresql*.spec (to see what system RPM packages you need to install)
# rpm -bp postgresql*.spec (.. this will prep the package)
Regression test needs the Makefiles and some header files like *fmgr*.h
which can be built by -
# rpm --short-circuit -bc postgresql*.spec ( .. use short circuit to bypass!)
Abort the build by CTRL+C, when you see 'make -C common SUBSYS.o'
By this time configure is successful and all makefiles and headers
are created. You do not need to proceed any further
# cd /usr/src/redhat/BUILD
# chown -R postgres postgresql*
# su - postgres$ cd /usr/src/redhat/BUILD/postgresql-6.4.2/src/test/regress
$ more README
$ make clean; make all runtest
$ more regress.out
alavoor@yahoo.com