Histórico da Página

Portuguese

INFORMAÇÕES IMPORTANTES
Encoding: WIN1252 Collation: C Character type: C Stored Procedures são suportadas para o banco PostgreSQL a partir da versão Protheus® 12.
PostgreSQL 12.3
Suportado a partir da versão Protheus® 12.
PostgreSQL 15.2
Suportado a partir da versão Protheus® 12. É possível utilizar esta versão com processador ARM! Consulte a documentação para maiores informações.

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

PostgreSQL

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.htmlPostgre ODBC - ANSI standard.

Image Removed

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

Image Removed

Advanced Options - Page 1.

Image Removed

Advanced Options - Page 2.

Image Removed

English

Pagetitle
PostgreSQL	PostgreSQL
IMPORTANT INFORMATION
ODBC Configuration

Section

border	true

VERSÕES ANTERIORES DESCONTINUADAS PELA FABRICANTE

Column

width	50%

Versão

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 Removed	Discontinued or not approved by the manufacturer and supported by TOTVS.
Image Removed Image Removed	Discontinued or not approved by the manufacturer and by TOTVS.
Image Removed Image Removed	In process of discontinuation by the manufacturer and supported by TOTVS.
Image Removed Image Removed	Approved by the manufacturer.
Image Removed Image Removed	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 Removed Image Removed
Fedora 8 (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
Fedora 8 (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
OpenSuse 10.3 (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
OpenSuse 10.3 (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
RedHat 4.6 AS / ES (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
RedHat 4.6 AS / ES (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
RedHat 5.1 AS / ES (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
RedHat 5.1 AS / ES (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
Suse SLES10 (X86)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed
Suse SLES10 (X86_64)	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed	Image Removed Image Removed

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

PostgreSQL

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.htmlODBC Postgre padrão ANSI.

Image Removed

Nomeação da ODBC. Após configurar os dados básicos clicar em Options / Datasource (destaque).

Image Removed

Advanced Options - Page 1.

Image Removed

Advanced Options - Page 2.

Image Removed

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

PostgreSQL 9.1.1

PostgreSQL 9.3.2

PostgreSQL 10.6

Column

width	50%

Data do término de suporte

Estado


subtle	true
colour	Red
title	31/07/2013

Estado

subtle	true
colour	Red
title	30/09/2016

Estado

subtle	true
colour	Red
title	30/09/2018

Estado


subtle	true
colour	Red
title	30/09/2022

Acesso ao Link: Bancos de dados homologados para TOTVS DBAccess

Portuguese

Pagetitle

PostgreSQL

INFORMAÇÕES IMPORTANTES

Configuração ODBC

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

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

Árvore de páginas

Versões comparadas

Versão antiga 3

Nova versão Atual

Chave

PostgreSQL

PostgreSQL