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