How to SET postgres application_name in a basic PHP script

Question

I'm trying to develop a script to SET application_name log feature in PHP application.

pg_query("SET application_name = 'Test log line'");

What I tried it above code. But it give following error,

Warning: pg_query(): Query failed: ERROR: unrecognized configuration parameter "application_name" in ...

This means I can't simply execute SET application_name query from pg_query() function.

Can anyone help me to find a way to set this from a PHP script.

Thank you!

Weird looks ok to me. What version of postgres are you using? — Eelke
– Eelke, Commented Apr 8, 2014 at 5:22

Craig Ringer · Accepted Answer · 2014-04-08 05:41:49Z

4

You're on an old PostgreSQL version.

application_name was introduced in 9.0. Compare to the 8.4 documentation with the link at the top.

You need to upgrade or skip using the feature.

In general, if you get errors that indicate that PostgreSQL has no idea what you're talking about - functions not found, views missing, syntax errors on what looks like the documented syntax, etc - then you should be thinking "am I reading the manual for my version".

answered Apr 8, 2014 at 5:41

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yasiru G Over a year ago

Thanks! Let me check on that :)

Collectives™ on Stack Overflow

How to SET postgres application_name in a basic PHP script

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related