477 reputation
313
bio website blog.teksol.info
location Sherbrooke, Canada
age 41
visits member for 2 years, 10 months
seen Jun 27 at 16:14

I am a web developer based in Sherbrooke, QC, Canada. I have been doing Rails development since it's 0.13 days, or 2005.

I currently do big data analysis using PostgreSQL for Seevibes.


Jul
2
awarded  Curious
Jun
27
comment What configuration to use for PGbouncer over a WAN link
I agree that IDLE transactions is an application problem, except that when I connect directly, after weeks of use, I have no idle in transactions. It really seems like a network problem: missed heartbeats or some such. I was looking for a way to let PG kill off those transactions. That patch looks promising, although a bit far off. Thanks!
Mar
20
accepted How to access NEW or OLD field given only the field's name?
Mar
19
comment How to access NEW or OLD field given only the field's name?
Cross posted to the PostgreSQL general mailing list postgresql.org/message-id/…
Mar
19
revised How to access NEW or OLD field given only the field's name?
Posted the question too early - it was incomplete
Mar
19
asked How to access NEW or OLD field given only the field's name?
Jan
25
awarded  Tumbleweed
Jan
18
asked What configuration to use for PGbouncer over a WAN link
Nov
6
awarded  Nice Question
Oct
18
awarded  Yearling
Sep
24
awarded  Popular Question
Aug
9
awarded  Notable Question
Jan
29
awarded  Popular Question
Dec
7
accepted Advantages of using PgBouncer vs HAProxy?
Dec
6
revised Teaching Slony replication to select slave nodes
Fixed "Slon" => "Slony"
Dec
6
suggested suggested edit on Teaching Slony replication to select slave nodes
Dec
6
comment What is the purpose of PGBouncer's parameter server_reset_query?
Using check_postgres, it should connect directly to the database cluster, and not through the connection pooler. You should have a separate check for the connection pooler itself, something like check_pgbouncer.
Dec
5
revised Advantages of using PgBouncer vs HAProxy?
grammar
Dec
5
asked Advantages of using PgBouncer vs HAProxy?
Nov
30
comment Postgres replication/replication to server outside firewall
You might want to take a look at github.com/omniti-labs/omnipitr for archiving. That's what I use, and I'm satisfied.