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. 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)

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

Portuguese

Pagetitle

	PostgreSQL
	PostgreSQL

PostgreSQL

INFORMAÇÕES IMPORTANTES
Collation: UTF8 Procedures NÃO são homologadas com PostgreSQL. O banco de dados Postgresql 8.2.6 está homologado para o produto TSS – TOTVS SPED, que realiza conexão com o banco através do TOTVSDBAccess. Homologado para uso com até 10 usuários simultâneos. O TOP Connect 4 não é homologado para plataforma: OpenSuse, Fedora e Conectiva. Links importantes: http://www.postgresql.org/ http://www.postgresql.org/docs/8.0/interactive/multibyte.html
Configuração ODBC
ODBC Postgre padrão ANSI. Image Added Nomeação da ODBC. Após configurar os dados básicos clicar em Options / Datasource (destaque). Image Added Advanced Options - Page 1. Image Added Advanced Options - Page 2. Image Added
PostgreSQL 8.2.6
É necessário utilizar o TOPConnect / TOTVSDBAccess com build igual ou superior a 20071226.
PostgreSQL 8.2.6 - Procedimentos para instalação (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 OBS: Aconselhamos que seja incluido no arquivo .odbc.ini a chave 'MaxLongVarcharSize', com o valor 2000. Vide abaixo trecho do arquivo 'odbc.ini' com exemplo do uso da chave 'MaxLongVarcharSize' destacado: [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

Legenda
Image Added Image Added	Descontinuado ou não homologado pelo fabricante e suportado pela TOTVS.
Image Added Image Added	Descontinuado ou não homologado pelo fabricante e pela TOTVS.
Image Added Image Added	Em processo de descontinuação pelo fabricante e suportado pela TOTVS.
Image Added Image Added	Homologado pelo fabricante.
Image Added Image Added	Homologado pelo fabricante e pela TOTVS.

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

Árvore de páginas

Versões comparadas

Versão antiga 2

Nova versão 3

Chave

PostgreSQL

PostgreSQL