Re: Errors in messages file

You could trace it in the log file by setting the following in
postgresql.conf


log_connections = true
log_timestamp = true
log_pid = true

You should be getting entries in the log file as -

2002-10-23 20:26:53 [18117]  DEBUG:  proc_exit(1)
2002-10-23 20:26:53 [18117]  DEBUG:  shmem_exit(1)
2002-10-23 20:26:53 [18117]  DEBUG:  exit(1)
2002-10-23 20:28:51 [18070]  DEBUG:  BackendStartup: forked pid=18130
socket=8
2002-10-23 20:28:51 [18130]  DEBUG:  connection: host=192.168.1.62
user=admin database=template1
/var/local/pgsql/bin/postmaster child[18130]: starting with
(postgres -d3 -v131072 -p template1 )

Hope this helps.


----- Original Message -----
From: "Patrick Meylemans" <Patrick.Meylemans@wtcm.be>
To: <pgsql-admin@postgresql.org>
Sent: Thursday, October 24, 2002 6:06 PM
Subject: [ADMIN] Errors in messages file


> Dear,
>
> I'm receiving the following messages in the /var/log/message file :
>
> -> logger: verify_password: user 'Admin' not found in password file.
>
> We are running on RedHat7.0
> Postgresql7.1.3
>
> How can I trace the IP adres of the client trying to connect as Admin to
> our database ?
>
> Kind Regards
>
> Patrick Meylemans
>
> Manager ICS CRIF-WTCM
> Celestijnenlaan 300C
> 3001 Heverlee
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>