import.css=/download/attachments/327912/newLayout.css

PostgreSQL

IMPORTANT INFORMATION

Collation: UTF8

Procedures are NOT approved with PostgreSQL.

 

Postgresql 8.2.6 database is ONLY approved for TSS - TOTVS SPED product, which connects the database through TOTVSDBAccess.

 

Approved to be used with up to 10 simultaneous users.


TOP Connect 4 is not approved for the platform: OpenSuse, Fedora, and Conectiva.


Important Links:
http://www.postgresql.org/
http://www.postgresql.org/docs/8.0/interactive/multibyte.html
ODBC Configuration
Postgre ODBC - ANSI standard.


ODBC Naming. After configuring the basic data, click Options/Datasource (highlighted).


Advanced Options - Page 1.


Advanced Options - Page 2.

 
PostgreSQL 8.2.6
Use TOPConnect/TOTVSDBAccess with build equal to or longer than 20071226.
PostgreSQL 8.2.6 - Installation Procedures (Linux).
./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb --lc-collate=C -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb -E LATIN1 nomedb
/usr/local/pgsql/bin/psql nomedb

NOTE: Add the key MaxLongVarcharSize to odbc.ini file with the value 2000.

See below the snippet of odbc.ini file with a highlighted example of how to use the key MaxLongVarcharSize:
[ODBC Data Sources]
Ambiente=Data Source for Ambiente tests

[Ambiente]
ServerName=Localhost
DataBase=DBTST
Driver=/usr/lib/libpsqlodbc.so
Port=5432
ReadOnly=0
MaxLongVarcharSize=2000
 

 

Caption
Discontinued or not approved by the manufacturer and supported by TOTVS.
Discontinued or not approved by the manufacturer and by TOTVS.
In process of discontinuation by the manufacturer and supported by TOTVS.
Approved by the manufacturer.
Approved by the manufacturer and by TOTVS.

 

O.S. PostgreSQL 7.2 PostgreSQL 7.3 PostgreSQL 7.4 PostgreSQL 8.2.6
Windows 2003 (X86)
Fedora 8 (X86)
Fedora 8 (X86_64)
OpenSuse 10.3 (X86)
OpenSuse 10.3 (X86_64)
RedHat 4.6 AS / ES (X86)
RedHat 4.6 AS / ES (X86_64)
RedHat 5.1 AS / ES (X86)
RedHat 5.1 AS / ES (X86_64)
Suse SLES10 (X86)
Suse SLES10 (X86_64)