PostgreSQL Version 6.4.2 Release 4 RPMs are now available

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


Get the Free Newsletter!

Subscribe to Developer Insider for top news, trends, & analysis