Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.
Composition Setup
import.css=/download/attachments/327912/newLayout.css
PostgreSQLODBC 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
 
Portuguese
Pagetitle
PostgreSQLPostgreSQL
INFORMAÇÕES IMPORTANTES

Encoding: WIN1252

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

C

Character type: C

Stored Procedures são suportadas para o banco PostgreSQL a partir da versão Protheus® 12.

PostgreSQL 12

Suportado a partir da versão Protheus® 12.

PostgreSQL 15

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
bordertrue

VERSÕES ANTERIORES DESCONTINUADAS PELA FABRICANTE


Column
width50%

Versão

PostgreSQL 8.2.6

PostgreSQL 9.1.1

PostgreSQL 9.3.2

PostgreSQL 10.6

Column
width50%

Data do término de suporte

Estado
subtletrue
colourRed
title31/07/2013

Estado
subtletrue
colourRed
title30/09/2016

Estado
subtletrue
colourRed
title30/09/2018

Estado
subtletrue
colourRed
title30/09/2022



 

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.

 

S.O.PostgreSQL 7.2PostgreSQL 7.3PostgreSQL 7.4PostgreSQL 8.2.6Windows 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