Thread: Errorlog empty

Errorlog empty

From
"Rossi, Maria"
Date:

Hi,

The errorlog is empty.   I turned on ‘log_connections’, then logged-on to the instance.  But still the errorlog is empty.  I would have expected connections would  appear at the log.

Any ideas why?

I am new to Postgres,  so please excuse my questions.

 

Maria

 

Re: Errorlog empty

From
"Gilberto Castillo"
Date:

> Hi,
> The errorlog is empty.   I turned on 'log_connections', then logged-on to
> the instance.  But still the errorlog is empty.  I would have expected
> connections would  appear at the log.
> Any ideas why?
> I am new to Postgres,  so please excuse my questions.
>
> Maria

My configuration:


log_destination = 'stderr'
logging_collector = on  --necesita restart
log_min_duration_statement = 0
log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0

Saludos,
Gilberto Castillo
La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

Re: Errorlog empty

From
Shreeyansh Dba
Date:

On Thu, Mar 12, 2015 at 3:07 AM, Gilberto Castillo <gilberto.castillo@etecsa.cu> wrote:


> Hi,
> The errorlog is empty.   I turned on 'log_connections', then logged-on to
> the instance.  But still the errorlog is empty.  I would have expected
> connections would  appear at the log.
> Any ideas why?
> I am new to Postgres,  so please excuse my questions.
>
> Maria

My configuration:


log_destination = 'stderr'
logging_collector = on  --necesita restart
log_min_duration_statement = 0
log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0

Saludos,
Gilberto Castillo
La Habana, Cuba

---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hi,
In postgresql.conf file you will find some ERROR REPORTING AND LOGGING parameters.
These parameters are responsible for error log generation:

log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'

Under When to log:

log_min_error_statement = error
log_min_duration_statement = 0

Under What to log:
log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0

I think changing these parameters will start the error logs in the pg_log folder of your data directory.


Thanks & Regards,
Ajinkya Bangale
Database Administrator

Re: Errorlog empty

From
"Rossi, Maria"
Date:

The logging_collector is on, but I don’t know if it was restarted after it was turned on.  I did run a ‘pg_ctl reload’, but still it did not log any msgs.

Does it need an actual restart?  I cannot simply do that because this is production, has to be scheduled.

 

Thanks.

 

Maria

 

From: Shreeyansh Dba [mailto:shreeyansh2014@gmail.com]
Sent: Thursday, March 12, 2015 1:03 AM
To: gilberto.castillo@etecsa.cu
Cc: Rossi, Maria; Postgres Maillist
Subject: Re: [ADMIN] Errorlog empty

 

 

On Thu, Mar 12, 2015 at 3:07 AM, Gilberto Castillo <gilberto.castillo@etecsa.cu> wrote:



> Hi,
> The errorlog is empty.   I turned on 'log_connections', then logged-on to
> the instance.  But still the errorlog is empty.  I would have expected
> connections would  appear at the log.
> Any ideas why?
> I am new to Postgres,  so please excuse my questions.
>
> Maria

My configuration:


log_destination = 'stderr'
logging_collector = on  --necesita restart
log_min_duration_statement = 0
log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0

Saludos,
Gilberto Castillo
La Habana, Cuba

---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hi,

In postgresql.conf file you will find some ERROR REPORTING AND LOGGING parameters.

These parameters are responsible for error log generation:

 

log_destination = 'stderr'

logging_collector = on

log_directory = 'pg_log'         

 

Under When to log:

 

log_min_error_statement = error

log_min_duration_statement = 0

 

Under What to log:

log_line_prefix = '%t [%p]: [%l-1] [%r]: user=%u '
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0

 

I think changing these parameters will start the error logs in the pg_log folder of your data directory.

 

 

Thanks & Regards,
Ajinkya Bangale
Database Administrator

 

Re: Errorlog empty

From
Igor Neyman
Date:
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rossi, Maria
Sent: Thursday, March 12, 2015 11:29 AM
To: 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
Cc: Postgres Maillist
Subject: Re: [ADMIN] Errorlog empty

The logging_collector is on, but I don’t know if it was restarted after it was turned on.  I did run a ‘pg_ctl reload’,
butstill it did not log any msgs.
 
Does it need an actual restart?  I cannot simply do that because this is production, has to be scheduled.

Thanks. 

Maria 


After ‘pg_ctl reload’ you can check current value of any parameter (including logging_collector) by issuing:

Show <parameter_name>

i.e.: show logging_collector;


Regards,
Igor Neyman

Re: Errorlog empty

From
"Rossi, Maria"
Date:
It is 'on'.

postgres=# show logging_collector;
 logging_collector
-------------------
 on
(1 row)

postgres=#



Maria 

-----Original Message-----
From: Igor Neyman [mailto:ineyman@perceptron.com] 
Sent: Thursday, March 12, 2015 11:52 AM
To: Rossi, Maria; 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
Cc: Postgres Maillist
Subject: RE: [ADMIN] Errorlog empty

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rossi, Maria
Sent: Thursday, March 12, 2015 11:29 AM
To: 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
Cc: Postgres Maillist
Subject: Re: [ADMIN] Errorlog empty

The logging_collector is on, but I don’t know if it was restarted after it was turned on.  I did run a ‘pg_ctl reload’,
butstill it did not log any msgs.
 
Does it need an actual restart?  I cannot simply do that because this is production, has to be scheduled.

Thanks. 

Maria 


After ‘pg_ctl reload’ you can check current value of any parameter (including logging_collector) by issuing:

Show <parameter_name>

i.e.: show logging_collector;


Regards,
Igor Neyman

Re: Errorlog empty

From
Igor Neyman
Date:

> -----Original Message-----
> From: Rossi, Maria [mailto:maria.rossi@us.pgds.com]
> Sent: Thursday, March 12, 2015 11:55 AM
> To: Igor Neyman; 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
> Cc: Postgres Maillist
> Subject: RE: [ADMIN] Errorlog empty
> 
> It is 'on'.
> 
> postgres=# show logging_collector;
>  logging_collector
> -------------------
>  on
> (1 row)
> 
> postgres=#
> 
> 
> 
> Maria
> 
> -----Original Message-----
> From: Igor Neyman [mailto:ineyman@perceptron.com]
> Sent: Thursday, March 12, 2015 11:52 AM
> To: Rossi, Maria; 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
> Cc: Postgres Maillist
> Subject: RE: [ADMIN] Errorlog empty
> 
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-
> owner@postgresql.org] On Behalf Of Rossi, Maria
> Sent: Thursday, March 12, 2015 11:29 AM
> To: 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
> Cc: Postgres Maillist
> Subject: Re: [ADMIN] Errorlog empty
> 
> The logging_collector is on, but I don’t know if it was restarted after it was
> turned on.  I did run a ‘pg_ctl reload’, but still it did not log any msgs.
> Does it need an actual restart?  I cannot simply do that because this is
> production, has to be scheduled.
> 
> Thanks.
> 
> Maria
> 
> 
> After ‘pg_ctl reload’ you can check current value of any parameter (including
> logging_collector) by issuing:
> 
> Show <parameter_name>
> 
> i.e.: show logging_collector;
> 
> 
> Regards,
> Igor Neyman

What about other parameters?
Log_destination
Log_filename
Log_directory
Log_connections
Log_disconnections

Regards,
Igor Neyman


Re: Errorlog empty

From
"Rossi, Maria"
Date:
Igor,

Here's the other  'log' configs:   Thanks.

postgres=# show log_destination;
 log_destination
-----------------
 stderr
(1 row)

postgres=# show log_filename;
 log_filename
---------------
 gp07error.log
(1 row)

postgres=# show log_directory;
        log_directory
-----------------------------
 /dba/pgsql/gp07/pg_errorlog
(1 row)

postgres=# show log_connections;
 log_connections
-----------------
 on
(1 row)

postgres=# show log_disconnections;
 log_disconnections
--------------------
 on
(1 row)

postgres=#


Maria A Rossi
Database Administration
PGDS (US)
email: maria.rossi@us.pgds.com
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

-----Original Message-----
From: Igor Neyman [mailto:ineyman@perceptron.com] 
Sent: Thursday, March 12, 2015 12:11 PM
To: Rossi, Maria; 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
Cc: Postgres Maillist
Subject: RE: [ADMIN] Errorlog empty



> -----Original Message-----
> From: Rossi, Maria [mailto:maria.rossi@us.pgds.com]
> Sent: Thursday, March 12, 2015 11:55 AM
> To: Igor Neyman; 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
> Cc: Postgres Maillist
> Subject: RE: [ADMIN] Errorlog empty
> 
> It is 'on'.
> 
> postgres=# show logging_collector;
>  logging_collector
> -------------------
>  on
> (1 row)
> 
> postgres=#
> 
> 
> 
> Maria
> 
> -----Original Message-----
> From: Igor Neyman [mailto:ineyman@perceptron.com]
> Sent: Thursday, March 12, 2015 11:52 AM
> To: Rossi, Maria; 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
> Cc: Postgres Maillist
> Subject: RE: [ADMIN] Errorlog empty
> 
> From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin- 
> owner@postgresql.org] On Behalf Of Rossi, Maria
> Sent: Thursday, March 12, 2015 11:29 AM
> To: 'Shreeyansh Dba'; gilberto.castillo@etecsa.cu
> Cc: Postgres Maillist
> Subject: Re: [ADMIN] Errorlog empty
> 
> The logging_collector is on, but I don’t know if it was restarted 
> after it was turned on.  I did run a ‘pg_ctl reload’, but still it did not log any msgs.
> Does it need an actual restart?  I cannot simply do that because this 
> is production, has to be scheduled.
> 
> Thanks.
> 
> Maria
> 
> 
> After ‘pg_ctl reload’ you can check current value of any parameter 
> (including
> logging_collector) by issuing:
> 
> Show <parameter_name>
> 
> i.e.: show logging_collector;
> 
> 
> Regards,
> Igor Neyman

What about other parameters?
Log_destination
Log_filename
Log_directory
Log_connections
Log_disconnections

Regards,
Igor Neyman


Re: Errorlog empty

From
"Gilberto Castillo"
Date:

> Igor,
>
> Here's the other  'log' configs:   Thanks.
>
> postgres=# show log_destination;
>  log_destination
> -----------------
>  stderr
> (1 row)
>
> postgres=# show log_filename;
>  log_filename
> ---------------
>  gp07error.log
> (1 row)
>
> postgres=# show log_directory;
>         log_directory
> -----------------------------
>  /dba/pgsql/gp07/pg_errorlog
> (1 row)

Check is exist this directry pg_errorlog and permission

Saludos,
Gilberto Castillo
La Habana, Cuba
---
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

Re: Errorlog empty

From
Scott Ribe
Date:
On Mar 12, 2015, at 11:12 AM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:
>
> Igor,
>
> Here's the other  'log' configs:   Thanks.
>
> postgres=# show log_destination;
> log_destination
> -----------------
> stderr
> (1 row)
>
> postgres=# show log_filename;
> log_filename
> ---------------
> gp07error.log
> (1 row)
>
> postgres=# show log_directory;
>        log_directory
> -----------------------------
> /dba/pgsql/gp07/pg_errorlog
> (1 row)
>
> postgres=# show log_connections;
> log_connections
> -----------------
> on
> (1 row)
>
> postgres=# show log_disconnections;
> log_disconnections
> --------------------
> on
> (1 row)
>

What about logging_collector? If that's not set, I think your log filename will be ignored and messages will go to
stderr.See: <http://www.postgresql.org/docs/9.4/static/runtime-config-logging.html> 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






Re: Errorlog empty

From
Shreeyansh Dba
Date:


On Thu, Mar 12, 2015 at 11:09 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Mar 12, 2015, at 11:12 AM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:
>
> Igor,
>
> Here's the other  'log' configs:   Thanks.
>
> postgres=# show log_destination;
> log_destination
> -----------------
> stderr
> (1 row)
>
> postgres=# show log_filename;
> log_filename
> ---------------
> gp07error.log
> (1 row)
>
> postgres=# show log_directory;
>        log_directory
> -----------------------------
> /dba/pgsql/gp07/pg_errorlog
> (1 row)
>
> postgres=# show log_connections;
> log_connections
> -----------------
> on
> (1 row)
>
> postgres=# show log_disconnections;
> log_disconnections
> --------------------
> on
> (1 row)
>

What about logging_collector? If that's not set, I think your log filename will be ignored and messages will go to stderr. See: <http://www.postgresql.org/docs/9.4/static/runtime-config-logging.html>

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice






--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


Hi,

Reload is fine no need to restart.
you can check whether parameters are configured using 

SHOW <parameter-name>;


May be there some permission issue to the log_destination folder.So once check the permissions and
Try 

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_file_mode = 0600

And let me know the output.


--
Thanks & Regards
Ajinkya Bangale
Database Administrator
Ph: +91-9552688400 / 7400

Email ID: ajinkya.bangale@shreeyansh.com
www.shreeyansh.com

Re: Errorlog empty

From
"Rossi, Maria"
Date:

Shreeyansh,  Scott,

 

Thanks for responding.  Here’s the value of a couple  log parms

 

gp07> psql -d postgres -c"show log_file_mode"

log_file_mode

---------------

0600

(1 row)

 

gp07> psql -d postgres -c"show log_filename"

log_filename

---------------

gp07error.log

(1 row)

 

gp07> psql -d postgres -c"show logging_collector"

logging_collector

-------------------

on

(1 row)

 

Also, we have a monitor that checks the errorlog.  This monitor appends the current log to an archive file (example,  errorlog.201503), then touch a new ‘error.log’.  After  the touch, the new errorlog is not written to anymore, until postgres is bounced.     I should also note that  new error.log is owned by the monitor ID:

 

-rw-rw-r-- 1 psgdba dbagroup     298 Mar 13 05:43 gl07error.log

 

dbagroup members are:  psgdba and instance-owner.

 

Thanks.

 

 

Maria A Rossi

Database Administration

PGDS (US)

email: maria.rossi@us.pgds.com
cell phone: 517.256.4392

work phone: 517.367.3099
work phone extension: 23099

 

From: Shreeyansh Dba [mailto:shreeyansh2014@gmail.com]
Sent: Friday, March 13, 2015 1:14 AM
To: Scott Ribe
Cc: Rossi, Maria; Postgres Maillist
Subject: Re: [ADMIN] Errorlog empty

 

 

 

On Thu, Mar 12, 2015 at 11:09 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:

On Mar 12, 2015, at 11:12 AM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:
>
> Igor,
>
> Here's the other  'log' configs:   Thanks.
>
> postgres=# show log_destination;
> log_destination
> -----------------
> stderr
> (1 row)
>
> postgres=# show log_filename;
> log_filename
> ---------------
> gp07error.log
> (1 row)
>
> postgres=# show log_directory;
>        log_directory
> -----------------------------
> /dba/pgsql/gp07/pg_errorlog
> (1 row)
>
> postgres=# show log_connections;
> log_connections
> -----------------
> on
> (1 row)
>
> postgres=# show log_disconnections;
> log_disconnections
> --------------------
> on
> (1 row)
>

What about logging_collector? If that's not set, I think your log filename will be ignored and messages will go to stderr. See: <http://www.postgresql.org/docs/9.4/static/runtime-config-logging.html>

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice







--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

 

 

Hi,

 

Reload is fine no need to restart.

you can check whether parameters are configured using 

 

SHOW <parameter-name>;

 

 

May be there some permission issue to the log_destination folder.So once check the permissions and

Try 

 

log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'

log_file_mode = 0600

 

And let me know the output.

 

 

--

Thanks & Regards
Ajinkya Bangale
Database Administrator
Ph: +91-9552688400 / 7400

Email ID: ajinkya.bangale@shreeyansh.com
www.shreeyansh.com

Re: Errorlog empty

From
Matheus de Oliveira
Date:

On Fri, Mar 13, 2015 at 7:02 AM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:

Also, we have a monitor that checks the errorlog.  This monitor appends the current log to an archive file (example,  errorlog.201503), then touch a new ‘error.log’.  After  the touch, the new errorlog is not written to anymore, until postgres is bounced.     I should also note that  new error.log is owned by the monitor ID:


That is a very important bit of information that you seem to have hidden from the list since the beginning. If an external process is moving the file that PostgreSQL is currently writting to, then it must somehow make the PostgreSQL's logger process aware of that. To do that you can call pg_rotate_logfile function:

    $ psql -c "SELECT pg_rotate_logfile()"

Although if you remove the file before calling it, you can lose some information in between, so I recommend using a log_filename that has date/time information (like the default one), so you can call pg_rotate_logfile, wait for PostgreSQL to create a new one, then you are safe to move the old ones to whatever location you want.

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

Re: Errorlog empty

From
"Rossi, Maria"
Date:

Matheus,

 

Thanks for the response.     I disabled the errorlog monitor and after the postgres was bounced, errorlog is growing  again!!     I will revise the monitor script to run the pg_rotate_logfile function. 

BTW,  I did not purposely hid that piece of information.  I just found out about it as I dug  more into the problem.

 

Thanks.

 

Maria A Rossi

Database Administration

PGDS (US)

email: maria.rossi@us.pgds.com
cell phone: 517.256.4392

work phone: 517.367.3099
work phone extension: 23099

 

From: Matheus de Oliveira [mailto:matioli.matheus@gmail.com]
Sent: Friday, March 13, 2015 7:55 AM
To: Rossi, Maria
Cc: Shreeyansh Dba; Scott Ribe; Postgres Maillist
Subject: Re: [ADMIN] Errorlog empty

 

 

On Fri, Mar 13, 2015 at 7:02 AM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:

Also, we have a monitor that checks the errorlog.  This monitor appends the current log to an archive file (example,  errorlog.201503), then touch a new ‘error.log’.  After  the touch, the new errorlog is not written to anymore, until postgres is bounced.     I should also note that  new error.log is owned by the monitor ID:

 

That is a very important bit of information that you seem to have hidden from the list since the beginning. If an external process is moving the file that PostgreSQL is currently writting to, then it must somehow make the PostgreSQL's logger process aware of that. To do that you can call pg_rotate_logfile function:

    $ psql -c "SELECT pg_rotate_logfile()"

Although if you remove the file before calling it, you can lose some information in between, so I recommend using a log_filename that has date/time information (like the default one), so you can call pg_rotate_logfile, wait for PostgreSQL to create a new one, then you are safe to move the old ones to whatever location you want.

 

Regards,

--

Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

Re: Errorlog empty

From
Matheus de Oliveira
Date:

On Sun, Mar 15, 2015 at 9:38 PM, Rossi, Maria <maria.rossi@us.pgds.com> wrote:

Thanks for the response.     I disabled the errorlog monitor and after the postgres was bounced, errorlog is growing  again!!     I will revise the monitor script to run the pg_rotate_logfile function. 

BTW,  I did not purposely hid that piece of information.  I just found out about it as I dug  more into the problem.


No problem. It happens... ;-)

Regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres