Configuration with PostgreSQL

Difference between version 3 and 4 - Previous - Next

[https://web.archive.org/web/20161211211830/naviserver.sourceforge.net/ns_logobig.gif]

[NaviServer%|%Main%|%]
✸ http://naviserver.sourceforge.net/w/NaviServer%|%Home Page%|%
✸ http://bitbucket.org/naviserver/naviserver/%|%Source Code %|%
✸ http://sourceforge.net/project/showfiles.php?group_id=130646%|%Downloads %|%
✸ http://naviserver.sourceforge.net/n/toc.html%|%API Documentation %|%
✸ http://sourceforge.net/mail/?group_id=130646%|%Mailing Lists%|%
✸ http://sourceforge.net/tracker/?group_id=130646&atid=719006%|%Bugs %|%
✸ https://www.ohloh.net/p/naviserver/contributors%|%Developers %|%

----

This is an example Naviserver configuration file with PostgreSQL.

This example would require the following setup in PostgreSQL:

database: demo

user: nsd

password: nsd-password-123


======tcl
set        homedir                /usr/lib/naviserver

set        server_name            alpha

set        address                192.168.1.128
set        port                   80


ns_section      "ns/server/${server_name}/modules"
   ns_param     nssock            ${homedir}/bin/nssock.so
   ns_param     nsdb              ${homedir}/bin/nsdb.so


ns_section      "ns/parameters"
   ns_param     home              $homedir


ns_section      "ns/servers"
   ns_param     $server_name      "Naviserver $server_name"


ns_section      "ns/server/${server_name}/fastpath"
   ns_param     pagedir           /var/www/alpha.co.uk/


ns_section      "ns/module/nssock"
   ns_param     port              $port
   ns_param     address           $address
   ns_param     defaultserver     $server_name


ns_section      "ns/module/nssock/servers"
   ns_param     $server_name      alpha.co.uk


ns_section      "ns/db/drivers"
   ns_param     postgres          ${homedir}/bin/nsdbpg.so


ns_section      "ns/db/pools"
   ns_param     main              "Main Pool"


ns_section      "ns/db/pool/main"
   ns_param     driver            postgres
   ns_param     datasource        127.0.0.1:5432:demo
   ns_param     user              nsd
   ns_param     password          "nsd-password-123"
   ns_param     connections       1


ns_section      "ns/server/${server_name}/db"
   ns_param     pools             "*"
   ns_param     defaultpool       "main"


ns_section      "ns/server/${server_name}/tcl"
   ns_param     library           /var/www/alpha.co.uk/tcl
======


<<categories>>NaviServer