Although other versions are available commercially, the Together company supports the open-source version of PostgreSQL for the Linux operating system for use with DODS
PostgreSQL is a popular open-source database used with DODS however, DODS requires a special column named OID in each table. However, OID is a reserved word in PostgreSQL.
Fortunately, the column names used for OID and VERSION are configurable. To configure these names, add the following lines to your application configuration file:
DatabaseManager.ObjectIdColumnName = "<ColName_for_ObjectId>" DatabaseManager.VersionColumnName = "<ColName_for_Version>"
where <ColName_for_ObjectId> and <ColName_for_Version> are the column names you want to use instead of OID and VERSION.
Configuration example:
#------------------------------------------------------------------- # Database Manager Configuration #------------------------------------------------------------------- DatabaseManager.Databases[] = <database_id> DatabaseManager.DefaultDatabase = <database_id> DatabaseManager.Debug = true DatabaseManager.DB.<database_id>.ClassType = Standard DatabaseManager.DB.<database_id>.Connection.User = <username> DatabaseManager.DB.<database_id>.Connection.Password = <password> DatabaseManager.DB.<database_id>.Connection.MaxPoolSize = 5 DatabaseManager.DB.<database_id>.Connection.AllocationTimeout = 10000 DatabaseManager.DB.<database_id>.Connection.Logging = true DatabaseManager.DB.<database_id>.ObjectId.CacheSize = 1024 DatabaseManager.DB.<database_id>.ObjectId.MinValue = 100 DatabaseManager.DB.<database_id>.JdbcDriver = "org.postgresql.Driver" DatabaseManager.DB.<database_id>.Connection.Url ="jdbc:postgresql://<host>/<db_instance>"
To specify character encoding for Postgresql you can specify the 'charSet' parameter within the connection URL.
DatabaseManager.DB.example.Connection.Url = "jdbc:postgresql://192.168.1.1/yourDbName?charSet=iso-8859-1"
This is the link where you can find all needed information and downloads for PostgreSQL database: