This is what I was looking for! .... oh, and I don't personally care much
for the URL syntax, that was more of just a desperation attempt.
DB = Sequel.connect(:adapter=>'postgres', :host=> 'localhost',
:database=>'blah', :user=>'gator', :max_connections => 10,
:after_connect=>(proc do |conn| conn.execute("SET application_name TO
'blahwebapp'") end))
and I was then able to see the entry in select * from pg_stat_activity
where application_name = 'blahwebapp';
Thanks Jeremy!
On Monday, September 30, 2013 12:10:20 AM UTC-5, Jeremy Evans wrote:
>
> On Saturday, September 28, 2013 7:39:51 PM UTC-7, Rob Sullivan wrote:
>
>> gems:
>> pg (0.17.0)
>> sequel_pg (1.6.8)
>> sequel (4.2.0)
>>
>> I'm trying to set my application_name in my connection string like so:
>>
>> DB = Sequel.connect(:adapter=>'postgres', :host=> 'localhost',
>> :database=>'blah', :user=>'gator', :application_name => 'blahwebapp')
>>
>> Even if I use the connection url (that works in psql) it still won't
>> register the application name properly in pg_stat_activity:
>>
>> DB =
>> Sequel.connect('postgres://gator@localhost/blah?application_name=blahwebapp')
>>
>> Regardless of what I do, the application_name defaults to the path of the
>> webserver:
>> /Users/gator/.rvm/gems/rub...47@blahwebapp/bin/shotgun
>>
>> Any thoughts on what I can do or what I'm doing wrong on this?
>>
>
> Sequel's postgres adapter doesn't pass the URL directly to PostgreSQL. It
> can't really do so and keep backwards compatibility.
>
> It looks like you can just set application_name at runtime. The best way
> to do this with Sequel is via after_connect:
>
> DB = Sequel.connect('postgres://gator@localhost/blah',
> :after_connect=>{|c| c.execute("SET application_name TO 'blahwebapp'")})
>
> It is possible to integrate this feature into sequel so that using it
> inside the postgres:// URL would work correctly. I'm open to that if other
> people think it would be useful.
>
> Thanks,
> Jeremy
>
--
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 post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/groups/opt_out.
