Sorry, getting back to this.
OK, good to know the checkin/checkout status.
I've set this up for a DB server on the LAN.
DBNS = Sequel.connect('postgres://myun:[email protected]:5432/alpha')
DBNS.extension(:connection_validator)
DBNS.pool.connection_validation_timeout = -1
DBNS.log_connection_info = true
p DBNS.get(1)
# Drop the connection socket:
/([\d.]+:\d+) --> ([\d.]+:\d+)/ =~ `fstat -n | fgrep 5432`
system('tcpdrop', $1, $2)
p DBNS.get(1)
Result:
LOG: statement: SET standard_conforming_strings = ON
LOG: statement: SET client_min_messages = 'WARNING'
LOG: statement: SET standard_conforming_strings = ON
LOG: statement: SET client_min_messages = 'WARNING'
1
sh: fstat: command not found
Traceback (most recent call last):
1: from /users/rich/app2.rb:28:in `<main>'
/users/rich/app2.rb:28:in `system': no implicit conversion of nil into
String (TypeError)
Can't find fstat for some reason. There's a man page.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/f2120076-e26c-4855-bf9c-8ac1f6080a24%40googlegroups.com.