Linha Microsiga Protheus

Árvore de páginas

Versões comparadas

Versão antiga 3

changes.mady.by.user admin

Gravado em

comparado com

Nova versão 4

changes.mady.by.user Carla Zidoi De Castro

Gravado em

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.
Comentário: binary and image files updated

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
 

 

Composition Setup
import.css=/download/attachments/327912/newLayout.css
English
Pagetitle
PostgreSQLPostgreSQL
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.

 

O.S.PostgreSQL 7.2PostgreSQL 7.3PostgreSQL 7.4PostgreSQL 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
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 RemovedImage Added


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


Advanced Options - Page 1.
Image RemovedImage Added


Advanced Options - Page 2.
Image RemovedImage 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 Removed Image RemovedImage Added Image Added
Descontinuado ou não homologado pelo fabricante e suportado pela TOTVS.
Image Removed Image RemovedImage Added Image Added
Descontinuado ou não homologado pelo fabricante e pela TOTVS.
Image Removed Image RemovedImage Added Image Added
Em processo de descontinuação pelo fabricante e suportado pela TOTVS.
Image Removed Image RemovedImage Added Image Added
Homologado pelo fabricante.
Image Removed Image RemovedImage Added Image Added
Homologado pelo fabricante e pela TOTVS.

 

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