Histórico da Página

...

English

Pagetitle

	PostgreSQL
	PostgreSQL

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. Image RemovedImage Added ODBC Naming. After configuring the basic data, click Options/Datasource (highlighted). Image RemovedImage Added Advanced Options - Page 1. Image RemovedImage Added Advanced Options - Page 2. Image RemovedImage Added
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
Image Removed Image RemovedImage Added Image Added	Discontinued or not approved by the manufacturer and supported by TOTVS.
Image Removed Image RemovedImage Added Image Added	Discontinued or not approved by the manufacturer and by TOTVS.
Image Removed Image RemovedImage Added Image Added	In process of discontinuation by the manufacturer and supported by TOTVS.
Image Removed Image RemovedImage Added Image Added	Approved by the manufacturer.
Image Removed Image RemovedImage Added Image Added	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)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
Fedora 8 (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
Fedora 8 (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
OpenSuse 10.3 (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
OpenSuse 10.3 (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
RedHat 4.6 AS / ES (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
RedHat 4.6 AS / ES (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
RedHat 5.1 AS / ES (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
RedHat 5.1 AS / ES (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
Suse SLES10 (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed
Suse SLES10 (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Added Image Added	Image Added Image Added	Image Added Image Added	Image Added Image AddedImage Removed Image Removed

Árvore de páginas

Versões comparadas

Versão antiga 1

Nova versão 2

Chave

PostgreSQL