Difference between revisions of "PostgreSQL logs"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 38: Line 38:
 
  LOG:  [[MultiXact]] member wraparound protections are now enabled
 
  LOG:  [[MultiXact]] member wraparound protections are now enabled
 
  LOG:  database system is ready to accept connections
 
  LOG:  database system is ready to accept connections
 +
 +
ERROR:  could not extend file "base/16385/t17_174219": [[No space left on device]]
  
  

Revision as of 09:42, 15 April 2020

 show log_destination ;
 log_destination 
-----------------
 stderr
(1 row)



show syslog_facility ;
 syslog_facility 
-----------------
 local0
(1 row)



show syslog_ident ;
 syslog_ident 
--------------
 postgres
(1 row)


ERROR:  duplicate key value violates unique constraint "YOUR_TEXT_HERE"
LOG:  autovacuum: found orphan temp table "TABLENAME"."duplicate_file_name$" in database "DATABASE_NAME"


LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up at 2020-04-15 09:03:50 UTC
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  redo starts at 5/50DC63D0
LOG:  invalid record length at 5/50EC7A60
LOG:  redo done at 5/50EC7A28
LOG:  last completed transaction was at log time 2020-04-15 09:07:19.636273+00
LOG:  MultiXact member wraparound protections are now enabled
LOG:  database system is ready to accept connections
ERROR:  could not extend file "base/16385/t17_174219": No space left on device


See also

Advertising: