ФТС

Настройки на реальном сервере

• ip сервера: 10.25.13.95
• computername: WIN-PI61J5M88QH
• ОС: windows server 2012 standart
• ОЗУ 24ГБб DEPO COPMUTERS X9DBL-3F/X9DBL-iF
• Настройки postresql
  • PGPASSWORD="sys1okan"
  • PGDATABASE="ibis"
  • PGUSER="postgres"
  • PG_ROOT="C:\Program Files\PostgreSQL\9.2"
  • DB_ROOT="C:\PGDATA\IBIS"
  • PGPORT=5432
  • EXPDPDIR="C:\BackUp\IBIS\DUMP"
  • STACKDIR="C:\BackUp\IBIS\STACK"

postgresql.conf

max_connections = 300
shared_buffers = 512MB
effective_cache_size = 4GB
work_mem = 3009kB
maintenance_work_mem = 1GB
checkpoint_segments = 3
checkpoint_completion_target = 0.5
wal_buffers = 16MB
default_statistics_target = 100

Локальная база

восстановлена по состоянию на 25.10.2014

[Postgresql]
server=192.168.1.100
port=5444
database=fts