Обсуждение: logging connections
i want to know, how i can log connections to postgres.
the sample log file is:
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2006-01-17 18:18:24 CST
LOG: checkpoint record is at 0/B035D0
LOG: redo record is at 0/B035D0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 1267; next OID: 17728
LOG: database system is ready
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: received fast shutdown request
LOG: aborting any active transactions
FATAL: terminating connection due to administrator command
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2006-01-20 11:00:00 CST
LOG: checkpoint record is at 0/3C339CB4
LOG: redo record is at 0/3C339CB4; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 2283381; next OID: 1159413
LOG: database system is ready
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
however, i am still not able to know how to log into the above file,
who has connected etc
if i can log something like " LOG: connection received: host=client1
> port=3775"
and also if i shut down postmaster, using pg_ctl stop, no logging takes place to the above log file.
How to enable the above,
thanks,
regards
Surabhi
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of Tom Lane
Sent: Fri 1/20/2006 3:13 AM
To: Nik
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Connections not closing
***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********
"Nik" <XLPizza@gmail.com> writes:
> Ok, I simplified the problem. I tried just running psql from the
> command line, and I noticed that it opens two connection on two
> different ports, and it closes only one.
> For example I do the following in the command prompt:
> C:\> psql -h host_name -p 5432 -d db_name -U user_name
> Password:
> 2006-01-19 09:50:29 [unknown] LOG: connection received: host=client1
> port=3775
> 2006-01-19 09:50:31 [unknown] LOG: connection received: host=client1
> port=3778
> 2006-01-19 09:50:31 test LOG: connection authorized: user=user_name
> database=db_name
It tries to connect, gets told it needs a password (the log verbosity
level is not high enough to record the rejection), asks you for the
password, and connects again. I don't see anything funny here.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
i want to know, how i can log connections to postgres.
the sample log file is:
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2006-01-17 18:18:24 CST
LOG: checkpoint record is at 0/B035D0
LOG: redo record is at 0/B035D0; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 1267; next OID: 17728
LOG: database system is ready
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: received fast shutdown request
LOG: aborting any active transactions
FATAL: terminating connection due to administrator command
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2006-01-20 11:00:00 CST
LOG: checkpoint record is at 0/3C339CB4
LOG: redo record is at 0/3C339CB4; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 2283381; next OID: 1159413
LOG: database system is ready
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
LOG: unexpected EOF on client connection
however, i am still not able to know how to log into the above file,
who has connected etc
if i can log something like " LOG: connection received: host=client1
> port=3775"
and also if i shut down postmaster, using pg_ctl stop, no logging takes place to the above log file.
How to enable the above,
thanks,
regards
Surabhi
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of Tom Lane
Sent: Fri 1/20/2006 3:13 AM
To: Nik
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Connections not closing
***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********
"Nik" <XLPizza@gmail.com> writes:
> Ok, I simplified the problem. I tried just running psql from the
> command line, and I noticed that it opens two connection on two
> different ports, and it closes only one.
> For example I do the following in the command prompt:
> C:\> psql -h host_name -p 5432 -d db_name -U user_name
> Password:
> 2006-01-19 09:50:29 [unknown] LOG: connection received: host=client1
> port=3775
> 2006-01-19 09:50:31 [unknown] LOG: connection received: host=client1
> port=3778
> 2006-01-19 09:50:31 test LOG: connection authorized: user=user_name
> database=db_name
It tries to connect, gets told it needs a password (the log verbosity
level is not high enough to record the rejection), asks you for the
password, and connects again. I don't see anything funny here.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
i did the above, however still no looging is being done.
for eg if i have a c++ program where i establish a connection to postgres and does some activity.
the postgres log should log the above connection to postgres when i run the program.
similarly say if i do psql database_name
this is also another connection, and shd get logged.
however by the changes u suggested, i am not able to do so.
thanks,
reagrds
surabhi
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of Nikola Ivanov
Sent: Fri 1/20/2006 7:41 PM
To: surabhi.ahuja
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logging connections
***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********
You need to edit your postgresql.conf file and in the "Error reporting and
logging" section set "log_connections=true", "log_disconnections=true", and
"log_hostname=true"
On 1/20/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
>
> i want to know, how i can log connections to postgres.
>
> the sample log file is:
> LOG: shutting down
> LOG: database system is shut down
> LOG: database system was shut down at 2006-01-17 18:18:24 CST
> LOG: checkpoint record is at 0/B035D0
> LOG: redo record is at 0/B035D0; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 1267; next OID: 17728
> LOG: database system is ready
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: received fast shutdown request
> LOG: aborting any active transactions
> FATAL: terminating connection due to administrator command
> LOG: shutting down
> LOG: database system is shut down
> LOG: database system was shut down at 2006-01-20 11:00:00 CST
> LOG: checkpoint record is at 0/3C339CB4
> LOG: redo record is at 0/3C339CB4; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 2283381; next OID: 1159413
> LOG: database system is ready
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
>
>
>
> however, i am still not able to know how to log into the above file,
> who has connected etc
>
>
> if i can log something like " LOG: connection received: host=client1
> > port=3775"
>
> and also if i shut down postmaster, using pg_ctl stop, no logging takes
> place to the above log file.
>
> How to enable the above,
>
> thanks,
> regards
> Surabhi
>
>
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org on behalf of Tom Lane
> Sent: Fri 1/20/2006 3:13 AM
> To: Nik
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Connections not closing
>
> ***********************
> Your mail has been scanned by iiitb VirusWall.
> ***********-***********
>
>
> "Nik" <XLPizza@gmail.com> writes:
> > Ok, I simplified the problem. I tried just running psql from the
> > command line, and I noticed that it opens two connection on two
> > different ports, and it closes only one.
> > For example I do the following in the command prompt:
>
> > C:\> psql -h host_name -p 5432 -d db_name -U user_name
> > Password:
>
> > 2006-01-19 09:50:29 [unknown] LOG: connection received: host=client1
> > port=3775
>
> > 2006-01-19 09:50:31 [unknown] LOG: connection received: host=client1
> > port=3778
>
> > 2006-01-19 09:50:31 test LOG: connection authorized: user=user_name
> > database=db_name
>
> It tries to connect, gets told it needs a password (the log verbosity
> level is not high enough to record the rejection), asks you for the
> password, and connects again. I don't see anything funny here.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>
please clarify the following:
log_destination (string)
PostgreSQL supports several methods for logging server messages, including stderr and syslog. On Windows, eventlog is also supported. Set this option to a list of desired log destinations separated by commas. The default is to log to stderr only. This option can only be set at server start or in the postgresql.conf configuration file.
can u please tell what do "stderr" and "syslog" mean?
thanks,
regards
Surabhi Ahuja
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of surabhi.ahuja
Sent: Mon 1/23/2006 2:04 PM
To: Nikola Ivanov
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logging connections
***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********
i did the above, however still no looging is being done.
for eg if i have a c++ program where i establish a connection to postgres and does some activity.
the postgres log should log the above connection to postgres when i run the program.
similarly say if i do psql database_name
this is also another connection, and shd get logged.
however by the changes u suggested, i am not able to do so.
thanks,
reagrds
surabhi
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of Nikola Ivanov
Sent: Fri 1/20/2006 7:41 PM
To: surabhi.ahuja
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logging connections
***********************
Your mail has been scanned by iiitb VirusWall.
***********-***********
You need to edit your postgresql.conf file and in the "Error reporting and
logging" section set "log_connections=true", "log_disconnections=true", and
"log_hostname=true"
On 1/20/06, surabhi.ahuja <surabhi.ahuja@iiitb.ac.in> wrote:
>
> i want to know, how i can log connections to postgres.
>
> the sample log file is:
> LOG: shutting down
> LOG: database system is shut down
> LOG: database system was shut down at 2006-01-17 18:18:24 CST
> LOG: checkpoint record is at 0/B035D0
> LOG: redo record is at 0/B035D0; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 1267; next OID: 17728
> LOG: database system is ready
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: received fast shutdown request
> LOG: aborting any active transactions
> FATAL: terminating connection due to administrator command
> LOG: shutting down
> LOG: database system is shut down
> LOG: database system was shut down at 2006-01-20 11:00:00 CST
> LOG: checkpoint record is at 0/3C339CB4
> LOG: redo record is at 0/3C339CB4; undo record is at 0/0; shutdown TRUE
> LOG: next transaction ID: 2283381; next OID: 1159413
> LOG: database system is ready
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
> LOG: unexpected EOF on client connection
>
>
>
> however, i am still not able to know how to log into the above file,
> who has connected etc
>
>
> if i can log something like " LOG: connection received: host=client1
> > port=3775"
>
> and also if i shut down postmaster, using pg_ctl stop, no logging takes
> place to the above log file.
>
> How to enable the above,
>
> thanks,
> regards
> Surabhi
>
>
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org on behalf of Tom Lane
> Sent: Fri 1/20/2006 3:13 AM
> To: Nik
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Connections not closing
>
> ***********************
> Your mail has been scanned by iiitb VirusWall.
> ***********-***********
>
>
> "Nik" <XLPizza@gmail.com> writes:
> > Ok, I simplified the problem. I tried just running psql from the
> > command line, and I noticed that it opens two connection on two
> > different ports, and it closes only one.
> > For example I do the following in the command prompt:
>
> > C:\> psql -h host_name -p 5432 -d db_name -U user_name
> > Password:
>
> > 2006-01-19 09:50:29 [unknown] LOG: connection received: host=client1
> > port=3775
>
> > 2006-01-19 09:50:31 [unknown] LOG: connection received: host=client1
> > port=3778
>
> > 2006-01-19 09:50:31 test LOG: connection authorized: user=user_name
> > database=db_name
>
> It tries to connect, gets told it needs a password (the log verbosity
> level is not high enough to record the rejection), asks you for the
> password, and connects again. I don't see anything funny here.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>