Re: [HACKERS] proposal: option --application_name for psql
2013/5/14 Pavel Stehule pavel.steh...@gmail.com: 2013/5/14 Magnus Hagander mag...@hagander.net: On Tue, May 14, 2013 at 9:36 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 2013/5/14 Magnus Hagander mag...@hagander.net: psql in connection string mode Hi Magnus, can me send some link? http://www.postgresql.org/docs/9.2/static/app-psql.html If this parameter contains an = sign or starts with a valid URI prefix (postgresql:// or postgres://), it is treated as a conninfo string. See Section 31.1 for more information. I was blind, thank you After comments from Erik and Magnus my proposal has no sense. Regards Pavel Pavel -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] proposal: option --application_name for psql
On Tue, May 14, 2013 21:04, Pavel Stehule wrote: Hello we like to use psql in combination with bash - just like postgresql driver. Actually there is no simple possibility (from command line) to set application_name. We would to use different name than psql - for example splunk, ... I tested PGAPPNAME, but it doesn't work. It does work: $ PGAPPNAME=splunk psql -c select application_name from pg_stat_activity; application_name -- splunk (1 row) But perhaps I misunderstood your intention? Thanks, Erik Rijkers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] proposal: option --application_name for psql
2013/5/14 Erik Rijkers e...@xs4all.nl: On Tue, May 14, 2013 21:04, Pavel Stehule wrote: Hello we like to use psql in combination with bash - just like postgresql driver. Actually there is no simple possibility (from command line) to set application_name. We would to use different name than psql - for example splunk, ... I tested PGAPPNAME, but it doesn't work. It does work: $ PGAPPNAME=splunk psql -c select application_name from pg_stat_activity; application_name -- splunk (1 row) But perhaps I misunderstood your intention? I was wrong - PGAPPNAME works, thank you but command line --application_name option should be a useful option I am thinking still Regards Pavel Thanks, Erik Rijkers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] proposal: option --application_name for psql
On Tue, May 14, 2013 at 9:25 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 2013/5/14 Erik Rijkers e...@xs4all.nl: On Tue, May 14, 2013 21:04, Pavel Stehule wrote: Hello we like to use psql in combination with bash - just like postgresql driver. Actually there is no simple possibility (from command line) to set application_name. We would to use different name than psql - for example splunk, ... I tested PGAPPNAME, but it doesn't work. It does work: $ PGAPPNAME=splunk psql -c select application_name from pg_stat_activity; application_name -- splunk (1 row) But perhaps I misunderstood your intention? I was wrong - PGAPPNAME works, thank you but command line --application_name option should be a useful option I am thinking still That goes for a lot of the parameters that go in a connection string, I'm not sure application_name is common enough to have it's own argument if other parameters don't. And you can still set it as long as you use psql in connection string mode, as you can with all the libpq parameters. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] proposal: option --application_name for psql
2013/5/14 Magnus Hagander mag...@hagander.net: psql in connection string mode Hi Magnus, can me send some link? Thank you Pavel -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] proposal: option --application_name for psql
On Tue, May 14, 2013 at 9:36 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 2013/5/14 Magnus Hagander mag...@hagander.net: psql in connection string mode Hi Magnus, can me send some link? http://www.postgresql.org/docs/9.2/static/app-psql.html If this parameter contains an = sign or starts with a valid URI prefix (postgresql:// or postgres://), it is treated as a conninfo string. See Section 31.1 for more information. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] proposal: option --application_name for psql
2013/5/14 Magnus Hagander mag...@hagander.net: On Tue, May 14, 2013 at 9:36 PM, Pavel Stehule pavel.steh...@gmail.com wrote: 2013/5/14 Magnus Hagander mag...@hagander.net: psql in connection string mode Hi Magnus, can me send some link? http://www.postgresql.org/docs/9.2/static/app-psql.html If this parameter contains an = sign or starts with a valid URI prefix (postgresql:// or postgres://), it is treated as a conninfo string. See Section 31.1 for more information. I was blind, thank you Pavel -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers