Un potente sistema database relazionale open source, con più di 15 anni di sviluppo e una solida architettura che si è guadagnata una diffusa reputazione di affidabilità e integrità dati.
Il programma è distribuito come pacchetto ZIP: Scompattare in cartella temporanea e lanciare INSTALL.EXE
. Scegliere l'unità preferita ma evitare di modificare i due percorsi consigliati. Riavviare e lanciare lo script \PGSQL\BIN\INITDB.CMD
. Per default viene creata la directory \PGSQLDATA
, utilizzata per contenere tutto il DB. Non spaventatevi se durante l'init lo spazio disponibile sul vostro HD si riduce di circa 20 Mb: alla fine verrà restituito (più o meno!). Avviare il server con l'icona "Postgres SQL Server 7.1.3". Per altre informazioni vedi readme.os2.it. Vedi sotto per il(i) link di download.
Qui di seguito trovi i link di download per l'installazione manuale del software:
PostgreSQL Server v. 9.6.6 (3/1/2018, Paul Smedley (Smedles)) | Readme/What's new |
Changes in this release:
1) Updated to v9.3.17 source
2) Updated to libc066
3) minimal testing - pg_ctl doesn't seem to work
4) Rebuilt with latest pthreads and libcx from rpm
5) Updated to v9.4.15 source
5) Updated to v9.5.10 source
6) Updated to v9.6.6 source
7) Attempt to fix problem with bootstrap on machines without a functional klibc user manager
Known Issues:
- running the postgresql initialisation sometimes crashes at "running bootstrap script" if
virtualaddress limit is too large or too small. A value of 2048 appears to work well here. |
smedley.id.au/tmp/postgresql-9.6.6-os2-20180103.zip | local copy | |
PostgreSQL Server v. 9.4.15 (1/1/2018, Paul Smedley (Smedles)) | ||
smedley.id.au/tmp/postgresql-9.4.15-os2-20180101.zip | local copy | |
PostgreSQL Server v. 9.6.6 (1/1/2018, Paul Smedley (Smedles)) | Readme/What's new |
Changes in this release:
1) Updated to v9.3.17 source
2) Updated to libc066
3) minimal testing - pg_ctl doesn't seem to work
4) Rebuilt with latest pthreads and libcx from rpm
5) Updated to v9.4.15 source
5) Updated to v9.5.10 source
6) Updated to v9.6.6 source
Known Issues:
- running the postgresql initialisation sometimes crashes at "running bootstrap script" |
smedley.id.au/tmp/postgresql-9.6.6-os2-20180101.zip | local copy | |
PostgreSQL Server v. 9.3.17 (31/12/2017, Paul Smedley (Smedles)) | ||
smedley.id.au/tmp/postgresql-9.3.17-os2-20171231.zip | local copy | |
PostgreSQL Server v. 9.1.3 (17/3/2012, Paul Smedley (Smedles)) | ||
www.os2site.com/sw/apps/database/postgresql/pgsql-9.1.3-os2-20120317.zip | local copy | |
PostgreSQL Server v. 9.0.6 (29/12/2011, Paul Smedley (Smedles)) | ||
smedley.id.au/tmp/postgresql-9.0.6-os2-20111229.zip | local copy | |
PostgreSQL Server v. 9.0.3 (6/2/2011, Paul Smedley (Smedles)) | ||
www.os2site.com/sw/apps/database/postgresql/old/postgresql-9.0.3-os2-20110206.zip | local copy | |
PostgreSQL Server v. 9.0.2 (19/12/2010, Paul Smedley (Smedles)) | ||
www.os2site.com/sw/apps/database/postgresql/old/postgresql-9.0.2-os2-20101219.zip | local copy | |
PostgreSQL Server v. 9.0.1 (8/11/2010, Paul Smedley (Smedles)) | ||
www.os2site.com/sw/apps/database/postgresql/old/postgresql-9.0.1-os2-20101108.zip | local copy | |
PostgreSQL Server v. 9.0.1 (12/10/2010, Paul Smedley (Smedles)) | ||
www.os2site.com/sw/apps/database/postgresql/old/postgresql-9.0.1-os2-20101012.zip | local copy | |
PostgreSQL Server v. 8.4.1 (4/5/2010, Vincenzo Venuto) | Readme/What's new |
Compiled with gcc 4.4.2. Requires OS/2 or eComstation. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.4.1.zip | local copy | |
PostgreSQL Server v. 8.4.3 (8/4/2010, Paul Smedley (Smedles)) | ||
www.os2site.com/sw/apps/database/postgresql/old/postgresql-8.4.3-os2-20100408.zip | local copy | |
PostgreSQL Server v. 8.4.3 (6/4/2010, Paul Smedley (Smedles)) | Readme/What's new |
PostgreSQL v8.4.3 is a powerful, enterprise class, open source relational database system. Fully ACID compliant. Requires libc063.dll. |
www.os2site.com/sw/apps/database/postgresql/old/postgresql-8.4.3-os2-20100406.zip | local copy | |
PostgreSQL Server v. 8.4.3a (6/4/2010, Paul Smedley (Smedles)) | Readme/What's new |
PostgreSQL v8.4.3a is a powerful, enterprise class, open source relational database system. Fully ACID compliant. Requires libc063.dll. |
www.os2site.com/sw/apps/database/postgresql/old/postgresql-8.4.3-os2-20100406a.zip | local copy | |
PostgreSQL Server v. 8.1.17 (3/3/2009, Paul Smedley (Smedles)) | Readme/What's new |
PostgreSQL v8.1.17 is a powerful, enterprise class, open source relational database system. Fully ACID compliant, full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). Requires libc063.dll. |
www.os2site.com/sw/apps/database/postgresql/old/postgres-8.1.17-os2-20090330.zip | local copy | |
PostgresSQL JDBC Support (3/7/2007) | Readme/What's new |
PostgresSQL JDBC Support.
USING THE DRIVER
To use the driver, you must introduce it to JDBC. Again, there's two ways
of doing this:
1: Hardcoded.
This method hardcodes your driver into your application/applet. You
introduce the driver using the following snippet of code:
try {
Class.forName("org.postgresql.Driver");
} catch(Exception e) {
// your error handling code goes here
}
Remember, this method restricts your code to just the postgresql database.
However, this is how most people load the driver.
2: Parameters
This method specifies the driver from the command line. When running the
application, you specify the driver using the option:
-Djdbc.drivers=org.postgresql.Driver
eg: This is an example of running one of my other projects with the driver:
java -Djdbc.drivers=org.postgresql.Driver uk.org.retep.finder.Main
note: This method only works with Applications (not for Applets).
However, the application is not tied to one driver, so if you needed
to switch databases (why I don't know ;-) ), you don't need to
recompile the application (as long as you havent hardcoded the url's).
---------------------------------------------------------------------------
JDBC URL syntax
The driver recognises JDBC URL's of the form:
jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database
Also, you can supply both username and passwords as arguments, by appending
them to the URL. eg:
jdbc:postgresql:database?user=me
jdbc:postgresql:database?user=me&password=mypass
---------------------------------------------------------------------------
That's the basics related to this driver. You'll need to read the JDBC Docs
on how to use it. However, there are some examples included in the example
directory. To build, type: make examples
To run them, they follow the same syntax. For example, the basic example shows
how to insert data, and perform queries:
java example.basic jdbc:postgresql:test user password
---------------------------------------------------------------------------
POSTGRESQL SPECIFICS
--------------------
Large Objects:
A "feature" of PostgreSQL is that access to LargeObjects is only permitted
within a Transaction. Because of this, any use of LargeObjects (also known
as Blobs) requires that the Connection.setAutoCommit() method be called
disabling the autocommit feature.
For example:
Connection db; // open the connection here
db.setAutoCommit(false); // Turn off AutoCommit
------------------
Large Object API
Most of the time, you can use the getBytes()/setBytes() methods to read and
write small Large Objects. However, PostgreSQL's own internal api's are
available. These allow you to access the object as if it was a file.
The first thing you need to do is to open the LargeObjectManager. This class
handles the opening of existing objects, and creating new ones. To do this,
you use the following line of code:
LargeObjectManager lobj;
lobj = ((org.postgresql.Connection)db).getLargeObjectAPI();
where db is a reference to an open Connection object.
Once that is done, you can use the API for the lifetime of that Connection.
To create an object, you call the create() method. This takes an argument
with the file modes you intend to use. The following line is normally
sufficient:
int oid = lobj.create(LargeObjectManager.READ|LargeObjectManager.WRITE);
Here, lobj is the LargeObjectManager we have opened earlier, and oid is the
Large Object's oid in the database.
To open an existing object, you use the open() method. This takes an oid, and
the file permissions. It then returns a LargeObject object.
LargeObject obj = lobj.open(oid,LargeObjectManager.WRITE);
Once the LargeObject is open, you can call methods to read, write, seek etc.
Here's the supported methods:
int oid = obj.getOID(); Return the objects oid
obj.close(); Close the object
byte data[] = obj.read(int len); Read len bytes
onj.read(byte data[],int off,int len); Read into data[off] len bytes
obj.write(byte data[]); Write the array data
obj.write(byte data[],int off,int len); Write len bytes from data[off]
obj.seek(int pos,int ref); As fseek in C.
obj.seek(int pos); Move to pos (from the begining)
int pos = obj.tell(); Returns the current position
int size = obj.size(); Returns the objects size
Caveat: If you commit(), rollback() a transaction, or turn on autocommit whilst
an object is open PostgreSQL will close it. You will need to reopen the object
before using it again. Using the existing LargeObject will cause an
SQLException to be thrown.
------------------
Date datatype:
The driver now issues the "show datestyle;" query when it first connects, so
any call to ResultSet.getDate() how returns the correct date.
One caveat though: if you change the datestyle from within JDBC, you must also
issue the "show datestyle" query. Without this, the driver will not know of
the change.
ie:
Statement s = db.createStatement();
...
s.executeUpdate("set datestyle='european'");
s.executeUpdate("show datestyle");
..
s.close();
Please note: This may change later, so that the driver uses the same format
internally (similar to how the ODBC driver works).
------------------
JDBC supports database specific data types using the getObject() call. The
following types have their own Java equivalents supplied by the driver:
box, circle, line, lseg, path, point, polygon
When using the getObject() method on a resultset, it returns a PG_Object,
which holds the postgres type, and its value. This object also supports
methods to retrive these types.
Eg: column 3 contains a point, and rs is the ResultSet:
PG_Object o = (PG_Object)rs.getObject(3);
PGpoint p = o.getPoint();
System.out.println("point returned x="+p.x+", y="+p.y);
Also, when using these classes, their toString() methods return the correct
syntax for writing these to the database.
---------------------------------------------------------------------------
Peter T Mount, December 29 1998
home email: pmount at retep.org.uk http://www.retep.org.uk
work email: petermount at it.maidstone.gov.uk or peter at taer.maidstone.gov.uk
PS: Please use the home email whenever possible. If you must contact me at work
then please cc my home one at the same time. |
www.os2site.com/sw/apps/database/postgresql/old/postjar.zip | local copy | |
PostgreSQL Server v. 8.1.4 (16/7/2006, Paul Smedley (Smedles)) | Readme/What's new |
Fully ACID compliant, full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). Includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. Supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. Requires libc061.dll. |
www.os2site.com/sw/apps/database/postgresql/old/postgres-8.1.4-os2-b2.zip | local copy | |
PostgreSQL Server v. 7.4.8 (4/8/2005, Andrew MacIntyre) | Readme/What's new |
EMX -Zmt build of PostgreSQL libpq client library w/SSL. Requires EMX 0.9d runtime. Replaces libpq-7.4.5-emx.zip. |
hobbes.nmsu.edu/download/pub/os2/dev/database/libpq-7.4.8-emx.zip | local copy | |
PostgreSQL Server v. 7.4.8 (4/8/2005, Andrew MacIntyre) | Readme/What's new |
Standalone multithreaded PostgreSQL libpq client DLL w/SSL. Replaces libpq-7.4.5-emx.zip. |
hobbes.nmsu.edu/download/pub/os2/dev/database/libpq-7.4.8-zso.zip | local copy | |
PostgreSQL Server v. 8.0 (28/2/2005, Lorne Sunley) | Readme/What's new |
postgreSQL V8.0 source for os/2 port. Requires Warp 4.5, Compiler and a bunch of other things. |
hobbes.nmsu.edu/download/pub/os2/apps/database/pgsqlsrc.zip | local copy | |
PostgreSQL Server v. 8.0 GA (25/2/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 GA fix e release os/2 port. This package includes PLJava support. The compiler used is GCC 3.3.5 beta4. This program uses high memory for allocating buffers. Requires Warp 4.5, Golden Code Java 1.4.1 SDK for PLJava support. Replaces postgresqlL-8.0-os2e.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-os2e-pljava.zip | local copy | |
PostgreSQL Server v. 8.0 GA (21/2/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL v8.0 GA (FIX E) OS/2 port. The compiler used is GCC 3.3.5 beta4. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. Replaces postgresqlL-8.0-os2d.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-os2e.zip | local copy | |
PostgreSQL Server v. 8.0 GA (12/2/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 GA fix d release os/2 port. The compiler used is GCC 3.3.5 beta4. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. Replaces postgresql-8.0-os2c.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-os2d.zip | local copy | |
PostgreSQL Server v. 8.0 GA (9/2/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 GA fix c release os/2 port. The compiler used is GCC 3.3.5 beta4. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. Replaces postgresqlL-8.0-os2b.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-os2c.zip | local copy | |
PostgreSQL Server v. 8.0 GA (6/2/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 GA fix b release os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. Replaces postgresqlL-8.0-os2-a.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-os2b.zip | local copy | |
PostgreSQL Server v. 8.0 GA (23/1/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 GA fix a release os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. Replaces postgresqlL-8.0-os2.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-os2-a.zip | local copy | |
PostgreSQL Server v. 8.0 GA (19/1/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 GA release os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. Replaces postgreSQL-8.0-rc5.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-os2.zip | local copy | |
PostgreSQL Server v. 8.0 rc5 (13/1/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 release candidate 5 os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5, a processor that supports the FXSAVE instruction (fork() code uses it). Replaces postgreSQL-8.0-rc4.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-rc5.zip | local copy | |
PostgreSQL Server v. 8.0 rc4 (10/1/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 release candidate 4 os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. a processor that supports the FXSAVE instruction (fork() code uses it). Replaces postgreSQL-8.0-rc3.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-rc4.zip | local copy | |
PostgreSQL Server v. 8.0 rc3 (1/1/2005, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 release candidate 3 os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5, a processor that supports the FXSAVE instruction (fork() code uses it. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-rc3.zip | local copy | |
PostgreSQL Server v. 8.0r (30/12/2004, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 rc2+ with NLS support os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp v4.5, v14.100 kernel and TCP/IP 4.1 or better and probably a non k6-2 CPU (possible failure). |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresqlrcnls.zip | local copy | |
PostgreSQL Server v. 8.0 rc2d (27/12/2004, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 rc2d os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5, 14.100 kernel and TCP/IP 4.1 or better and probably a non k6-2 CPU (possible failure). Replaces postgreSQL-8.0-rc2.zip postgreSQL-8.0-rc2a.zip postgresSQL-8.0-rc2C.zip. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgresql-8.0-rc2d.zip | local copy | |
PostgreSQL Server v. 8.0 rc2a (26/12/2004, Lorne Sunley) | Readme/What's new |
PostgreSQL v8.0 rc2a OS/2 port update. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. 14.100 kernel and TCP/IP 4.1 or better and probably a non k6-2 CPU (possible failure). Replaces postgreSQL-8.0-rc2.zip. |
www.os2site.com/sw/apps/database/postgresql/old/postgresql-8.0-rc2a.zip | local copy | |
PostgreSQL Server v. 8.0 rc2c (26/12/2004, Lorne Sunley) | Readme/What's new |
PostgreSQL v8.0 rc2c OS/2 port update. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5. 14.100 kernel and TCP/IP 4.1 or better and probably a non k6-2 CPU (possible failure). Replaces postgreSQL-8.0-rc2a.zip. |
www.os2site.com/sw/apps/database/postgresql/old/postgresql-8.0-rc2c.zip | local copy | |
PostgreSQL Server v. 8.0 rc2 (23/12/2004, Lorne Sunley) | Readme/What's new |
PostgreSQL V8.0 rc 2 os/2 port. The compiler used is GCC 3.3.5 beta2. It is built from the 2004-12-03 rc1 code. This program uses high memory for allocating buffers. Requires Warp 4.5x. |
www.os2site.com/sw/apps/database/postgresql/old/postgresql-8.0-rc2.zip | local copy | |
PostgreSQL Server v. 7.3.2 (21/6/2003, Vincenzo Venuto) | Readme/What's new |
Upgrade release. A sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere.Includes new PM console for logging, also includes xbase tools and PDF documentation V7.3.2. |
hobbes.nmsu.edu/download/pub/os2/apps/database/postgres7.3.2-server-bin_os2d.zip | local copy | |
PostgreSQL Server v. 7.1 (8/9/2001, D. Clark) | Readme/What's new |
Modified INITDB script for initializing PostgreSQL v7.1 template database, replace the x:\pgsql\bin\initdb file with this file. |
hobbes.nmsu.edu/download/pub/os2/apps/database/initdbpg.zip | local copy | |
ODBC driver (5/6/2001, Vincenzo Venuto) | Readme/What's new |
ODBC driver + manager 3.01 for OS/2 includes drivers (postgres,db2,btrive,text,dbf,etc.), fully functional with emx and non emx apps.
ODBC by ex Intersolv 3.01 - READ.ME
------------------------
Welcome to ODBC by ex Intersolv.
This file contains information you need to install ODBC by ex Intersolv
and additional information not included in the product documentation.
This README file is divided into the following categories:
- Before You Install ODBC by ex Intersolv
-Software Requirements
-Hardware Requirements
- Getting Help
- Installing ODBC by ex Intersolv
- Late-Breaking News
- Trademarks
- Your Satisfaction
Before You Install ODBC by ex Intersolv
---------------------------------
Software Requirements
---------------------
OS/2 WARP 3.0/4.0
Hardware Requirements
---------------------
486 processor or Pentium
1MB RAM
6MB DASD
Getting Help
------------
Documentation
Service and Technical Support
Defect Reporting
Installing ODBC by ex Intersolv
-------------------------
Remove the previous ODBC installation. You must remove all ODBC files !!!
Remove also the \os2\odbc.ini and \os2\odbcinst.ini, if present.
Then execute ODBC Manager for driver setup.
Late-Breaking News
------------------
The latest source version of this software may be obtained at ???
For more information look at our WWW home page located at
http://venuto.monrif.net.
Your Satisfaction
-----------------
Your satisfaction with me is important to us. If you are not totally
satisfied with this product, please contact us at venuto@monrif.net.
Tell us what is not meeting your expectations and why you are
dissatisfied. Provide your name, your organizations's name, and
your telephone number so that we can contact you. We will work with
you to resolve your concerns.
To contact us, use any of these:
o Telephone in the Italy: +39-335-6059667
o Fax in the Italy: +39-828-397244
o Internet: venuto@monrif.net |
hobbes.nmsu.edu/download/pub/os2/apps/database/odbc3.01-bin_os2.zip | local copy | |
PostgreSQL Server v. 6.5.2 (20/9/1999, Vincenzo Venuto) | Readme/What's new |
Requires OS/2 WARP 3.0/4.0, EMX runtime v0.9d, any Bourne Shell for executing a scripts. A Shell Utils with awk, rm, cp, sed, etc. TCP/IP software installed or loopback driver. |
www.os2site.com/sw/apps/database/postgresql/old/postgres6.5.2-server-bin_os2.zip | local copy |
This work is licensed under a Creative Commons Attribution 4.0 International License.
Aggiungi un commento