Histórico da Página

...

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

está homologado para ambiente Protheus (Versões: 10 e 11) e 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 Modified Nomeação da ODBC. Após configurar os dados básicos clicar em Options / Datasource (destaque). Image Modified Advanced Options - Page 1. Image Modified Advanced Options - Page 2. Image Modified
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 Modified Image Modified	Descontinuado ou não homologado pelo fabricante e suportado pela TOTVS.
Image Modified Image Modified	Descontinuado ou não homologado pelo fabricante e pela TOTVS.
Image Modified Image Modified	Em processo de descontinuação pelo fabricante e suportado pela TOTVS.
Image Modified Image Modified	Homologado pelo fabricante.
Image Modified Image Modified	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 Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Fedora 8 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Fedora 8 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
OpenSuse 10.3 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
OpenSuse 10.3 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 4.6 AS / ES (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 4.6 AS / ES (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 5.1 AS / ES (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
RedHat 5.1 AS / ES (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES10 (X86)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified
Suse SLES10 (X86_64)	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified	Image Modified Image Modified

Árvore de páginas

Versões comparadas

Versão antiga 4

Nova versão 5

Chave

PostgreSQL