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.

Section

border	true

VERSÕES ANTERIORES DESCONTINUADAS PELA FABRICANTE

Column

width	50%

Versão

PostgreSQL 8.2.6

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

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

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

English

Pagetitle
PostgreSQL	PostgreSQL
IMPORTANT INFORMATION
ODBC Configuration
PostgreSQL 8.2.6
Use TOPConnect/TOTVSDBAccess with build equal to or longer than 20071226.
PostgreSQL 8.2.6 - Installation Procedures (Linux).

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.

Árvore de páginas

Versões comparadas

Versão antiga 1

Nova versão Atual

Chave

PostgreSQL