[Csql-users] Newbie needs help with caching Postgres tables in CSQL

[Barney, K. L <Ker...@us...>]

# CSQL System Configuration File

#####################################Server Section########################

# Site ID for this CSQL server
SITE_ID=1

#Important: For Server section parameters, make sure that the value is same for the 
#           server process and all the csql client process which connects to it. otherwise, 
#           behavior is undefined

# Page size. Each database is logically divided into pages and allocation happens 
# in this unit of pages. Increasing this value will reduce frequent allocation of pages. 
PAGE_SIZE= 8192

#Total number of client process which can connect and work with the 
# database concurrently
MAX_PROCS = 100

# Maximum size of the system database.
MAX_SYS_DB_SIZE=1048576

#Maximum size of the user database file.
MAX_DB_SIZE=10485760

#Shared memory key to be used by the system to create and locate system database.
SYS_DB_KEY=2222

#Shared memory key to be used by the system to create and locate user database.
USER_DB_KEY=3333

#Log level 0->no logging 1->Fine 2->Finer 3->Finest
LOG_LEVEL=0

#Give full path for the log file where important system actions are stored.
LOG_FILE=/tmp/csql/log/log.out

#The virtual memory start address at which the shared memory segment 
# will be created and attached. 
MAP_ADDRESS=400000000

# Whether to enable durability
DURABILITY=false

# Whether to enable memory map architecture for user database
MMAP=false

# Specifies the durability mode for redo log generation
# Valid values are 
# 1 ->uses standard redo logging with O_APPEND mode
# 2 ->uses standard logging with serialization
# 3 ->uses O_SYNC flag
# 4 ->uses O_DIRECT flag

DURABLE_MODE=1

#Give full path for the database file where table and record information will
#be stored for durability
DATABASE_FILE=/tmp/csql/db

#Important: For Server section parameters, make sure that the value is same for the server process and all the csql client process which connects to it. otherwise, behavior is undefined

# Give full path for the std error file to store all the errors during database operations
STDERR_FILE=stderr

#####################################Client Section########################

#Mutex timeout interval seconds
MUTEX_TIMEOUT_SECS=0
MUTEX_TIMEOUT_USECS=5000
MUTEX_TIMEOUT_RETRIES=10

#Lock timeout interval seconds
LOCK_TIMEOUT_SECS=0
LOCK_TIMEOUT_USECS=5000
LOCK_TIMEOUT_RETRIES=10

#Statement Cache Size
STMT_CACHE_SIZE=10

#Enable statement cache for statements with no parameters
STMT_CACHE_NOPARAM=false

#####################################Cache Section########################

#Whether to enable caching of tables from target database
CACHE_TABLE=true

#DSN Name to connect to the target database.
#This should be present in ~/odbc.ini file
DSN=psql

USER=postgres
PASSWORD=

# Whethere to enable bidirectional updates for cached tables.
ENABLE_BIDIRECTIONAL_CACHE=false

CACHE_RECEIVER_WAIT_SECS=10

#Mode of operation SYNC or ASYNC
CACHE_MODE=SYNC

##########################SqlNetworkServer Section########################

# Whether to enable SqlNetwork server
CSQL_SQL_SERVER=false

#Set port for Network access
PORT=5678

# Max number of seconds that the network layer waits to receive a pkt
NETWORK_RESPONSE_TIMEOUT=3

# Max number of seconds that the network layer waits to connect to sql server
NETWORK_CONNECT_TIMEOUT=5 

#Give full path for the file where all the table information is stored
TABLE_CONFIG_FILE=/tmp/csql/csqltable.conf

#Give full path of the file where all the DSN information is stored
DS_CONFIG_FILE=/tmp/csql/csqlds.conf

# Give full path for conflict Resolution file
CONFL_RESOL_FILE=/tmp/csql/conflResoFile.txt

# MSGKEY for creating msg queue for MsgQueue Server
MSG_KEY=2525

# Maximum message that the message queue server is able to handle for 
# asynchronous updates.  This value is is default value of 'kernel.msgmax'
# parameter. 
ASYNC_MSGMAX=8192

# Maximum number of messages that the message queue server will hold for a site
# that is down in the replication group.
MAX_QUEUE_LOGS=100

# Shared memory key for id generators
ID_SHM_KEY=1947
#####################################End Section########################