首页 | 新闻 | 交流 | 问吧 | 文档 | 手册 | 下载 | 博客

connection string for PostgreSql

作者:  时间: 2011-05-26

http://www.mono-project.com/PostgreSQL#Some_Connection_Example

Parameter Definition Description Example
Server hostname of the PostgreSQL Server Server=localhost
Database name of the database Database=postgres
Port Network port to connect. Optional Port=54321
User ID user id User ID=postgres
Password password Password=mypass12
Encoding Encoding to be used. Possible values: ASCII(default) and UNICODE. Use UNICODE if you are getting problems with UTF-8 values Encoding=UNICODE
SSL True or False. Controls whether to attempt a secure connection. Default = False SSL=true
Pooling True or False. Controls whether connection pooling is used. Default = True Pooling=false
MinPoolSize Min size of connection pool. Default: 1 MinPoolSize=2
MaxPoolSize Max size of connection pool. Default: 20 MaxPoolSize=6
Timeout Time to wait for connection open in seconds Timeout=30
Sslmode Mode for ssl connection control. Sslmode can be one of the following values:
           Prefer - If it is possible to connect using ssl, it will be used.
           Require - If an ssl connection cannot be made, an exception is thrown.
           Allow - Not supported yet, just connects without ssl.
           Disable - No ssl connection is done.
           Default is Disable. 
Sslmode=Require
Protocol Protocol version to use, instead of automatic detection. First tries 3 and fallsback to 2; Integer 2 or 3. Protocol=2

CommandTimeout=20;Timeout=15;