-----BEGIN PGP SIGNED MESSAGE-----
PostgreSQL Version 6.4.2 Release 3 RPMs are now
available
---------------------------------------------
New changes in Release 3 i.e postgresql-6.4.2-3*.rpm. The following are
added:
1. Python interface module is now included
2. JDBC interface is now included - "Java lovers" will like this
3. ODBC interface is now included
4. RPM spec file now has code for building RPMs on solaris
Note: Other interfaces like Perl, "C", "C++", Tcl/Tk and ecpg (Embedded
C-SQL) are already included.
What is it?
- ---------
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.
RPMS source and binaries of PostgreSQL Version 6.4.2 release 3 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-3*.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')
$ 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
Al Dev Email: alavoor _at_ yahoo.com
- --
This article has been digitally signed by the moderator, using PGP.
http://www.iki.fi/mjr/cola-public-key.asc has PGP key for validating signature.
Send submissions for comp.os.linux.announce to: linux-announce _at_ news.ornl.gov
PLEASE remember a short description of the software and the LOCATION.
This group is archived at http://www.iki.fi/mjr/linux/cola.html
-----BEGIN PGP SIGNATURE-----
Version: 2.6.3ia
Charset: latin1
iQCVAgUBNtnT2VrUI/eHXJZ5AQGorwP+PJ8nQRQ69p7IdEmv98Y8tKR66zl5evKc
LlWmJ1qN0s5MtNC1Gk0mtVJKbZ2mHj8nLVrD1kFJqo1s+rAaLtG1eQUlEI5Gx4E5
VjQOCHI3ndtlTQwaf3Dt7jncq+T72LuKIlT8o7KFlXYvtdyYqc4duVrtdxc17IOB
D/p/pDbx2z0=
=jHAG
-----END PGP SIGNATURE-----
