pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedConnections to the Database
5+ messages / 4 participants
[nested] [flat]
* Connections to the Database
@ 2012-02-16 13:21 Reinhard Asmus <reinhard.asmus@spdfraktion.de>
2012-02-17 08:29 ` Re: Connections to the Database Adarsh Sharma <adarsh.sharma@orkash.com>
2012-02-17 15:02 ` Re: Connections to the Database lst_hoe02@kwsoft.de
0 siblings, 2 replies; 5+ messages in thread
From: Reinhard Asmus @ 2012-02-16 13:21 UTC (permalink / raw)
To: pgsql-admin
I install a new database and want to check which connections will be used.
How can i see which application from which host is connecting the database?
Any help is appreciated.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Connections to the Database
2012-02-16 13:21 Connections to the Database Reinhard Asmus <reinhard.asmus@spdfraktion.de>
@ 2012-02-17 08:29 ` Adarsh Sharma <adarsh.sharma@orkash.com>
1 sibling, 0 replies; 5+ messages in thread
From: Adarsh Sharma @ 2012-02-17 08:29 UTC (permalink / raw)
To: Reinhard Asmus <reinhard.asmus@spdfraktion.de>; +Cc: pgsql-admin
Issue the below command :-
select * from pg_stat_activity
& check the results.
Reinhard Asmus wrote:
> I install a new database and want to check which connections will be
> used.
>
> How can i see which application from which host is connecting the
> database?
>
> Any help is appreciated.
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Connections to the Database
2012-02-16 13:21 Connections to the Database Reinhard Asmus <reinhard.asmus@spdfraktion.de>
@ 2012-02-17 15:02 ` lst_hoe02@kwsoft.de
1 sibling, 0 replies; 5+ messages in thread
From: lst_hoe02@kwsoft.de @ 2012-02-17 15:02 UTC (permalink / raw)
To: pgsql-admin
Zitat von Reinhard Asmus <reinhard.asmus@spdfraktion.de>:
> I install a new database and want to check which connections will be used.
>
> How can i see which application from which host is connecting the database?
>
> Any help is appreciated.
Hello
if you only want to check from time to time use something like PGAdmin
(http://www.pgadmin.org/). The connections are shown in the statistics
pane for the database in question.
Regards
Andreas
Attachments:
smime.p7s (application/pkcs7-signature, 6.0K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Connections to the Database
@ 2012-02-17 08:48 Reinhard Asmus <reinhard.asmus@spdfraktion.de>
2012-02-20 07:33 ` Re: Connections to the Database Raghavendra <raghavendra.rao@enterprisedb.com>
0 siblings, 1 reply; 5+ messages in thread
From: Reinhard Asmus @ 2012-02-17 08:48 UTC (permalink / raw)
To: pgsql-admin
select * from pg_stat_activity show me informations to working connections
but i will see informations (application and ip-address) to failed
connections
in this situation i can see problems in my pg_log but not the
information to application and ip-address
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Connections to the Database
2012-02-17 08:48 Re: Connections to the Database Reinhard Asmus <reinhard.asmus@spdfraktion.de>
@ 2012-02-20 07:33 ` Raghavendra <raghavendra.rao@enterprisedb.com>
0 siblings, 0 replies; 5+ messages in thread
From: Raghavendra @ 2012-02-20 07:33 UTC (permalink / raw)
To: Reinhard Asmus <reinhard.asmus@spdfraktion.de>; +Cc: pgsql-admin
On Fri, Feb 17, 2012 at 2:18 PM, Reinhard Asmus <
reinhard.asmus@spdfraktion.de> wrote:
> select * from pg_stat_activity show me informations to working connections
>
> but i will see informations (application and ip-address) to failed
> connections
>
> in this situation i can see problems in my pg_log but not the information
> to application and ip-address
>
>
>
pg_stat_activity is standard statistic view which is dynamically updated.
Very true, failed connection's information can be pull from
pg_logs. However, you need to tune your logging setting to write
information about connections. See log_connections & log_disconnections
http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-admin<http://www.postgresql.org/mailpref/pgsql-admin;
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2012-02-20 07:33 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-02-16 13:21 Connections to the Database Reinhard Asmus <reinhard.asmus@spdfraktion.de>
2012-02-17 08:29 ` Adarsh Sharma <adarsh.sharma@orkash.com>
2012-02-17 15:02 ` lst_hoe02@kwsoft.de
2012-02-17 08:48 Re: Connections to the Database Reinhard Asmus <reinhard.asmus@spdfraktion.de>
2012-02-20 07:33 ` Raghavendra <raghavendra.rao@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox