Обсуждение: Application name and psql in 9.0

I am logging application name in 9.0, and noticed the following issue.
First, I produced an error with psql:

bash-3.2$ psql nonexistent
psql: FATAL:  database "nonexistent" does not exist

Looking at the logs, I see:

10338 [unknown] 2010-08-06 07:38:00 EEST FATAL:  database "nonexistent"
does not exist

Why can't I see psql there? Is it just because that logging is performed
just before detecting application name?

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

2010/8/6 Devrim GÜNDÜZ <devrim@gunduz.org>:
> Why can't I see psql there? Is it just because that logging is performed
> just before detecting application name?

Yes. The backend checks whether target database exists, before
processing application name.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

On Fri, 2010-08-06 at 14:49 +0900, Fujii Masao wrote:
> > Why can't I see psql there? Is it just because that logging is
> performed
> > just before detecting application name?
>
> Yes. The backend checks whether target database exists, before
> processing application name.


Thanks.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz