[Klone-users] DB connections for users

Alex Effractor effractor at gmail.com
Fri Jun 19 06:23:20 EDT 2009


Hi,
I have a question about DB connections. Is it real to make connection for
each logined user or for each child? Now I create a new DB connection in
child_init() hook:

PGconn *conn;
 int child_init()
 {
conn = PQconnectdb(conn_str);
  return 0;
 }

 int pg_connect()
 {
  if(conn)
  PQreset(conn);
  else
  conn = PQconnectdb(conn_str);

  if(conn && PQstatus(conn) == CONNECTION_OK)
  {
  info("Connected to PostgreSQL. Server version %d",
  PQserverVersion(conn));
  info("conn = %p", conn);
  return 0;
  }

  pg_finish();
  err("Connection to PostgreSQL failed");
  return 1;
 }
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://koanlogic.com/pipermail/klone-users/attachments/20090619/bc3033b5/attachment.html


More information about the Klone-users mailing list