PostgreSQL logs
/var/log/postgresql
Configuration
show log_destination ; log_destination ----------------- stderr (1 row) show syslog_facility ; syslog_facility ----------------- local0 (1 row) show syslog_ident ; syslog_ident -------------- postgres (1 row)
Messages
ERROR: duplicate key value violates unique constraint "YOUR_TEXT_HERE" LOG: autovacuum: found orphan temp table "TABLENAME"."duplicate_file_name$" in database "DATABASE_NAME"
ERROR: duplicate key value violates unique constraint "YOUR_TEXT_HERE" DETAIL: Key (XXXXX, YYYYY)=(#####, -#######) already exists. STATEMENT: insert into ZZZZXXXSS (xx_id, yy_id, zz_value) values ($1,$2,$3) LOG: received smart shutdown request LOG: autovacuum launcher shutting down
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
WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command.
See also
- PostgreSQL:
pg_dump, pg_restore,pgAdmin, pg_config, psql, pg_ctl, pg_isready, initdb, Role, Schema, DBeaver, Navicat, DataGrip, OmniDB,Adminer, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs,postgresql.conf,pg_hba.conf, $HOME/.pg_service.conf, Create database (PostgreSQL), Create user,createdb,GRANT,pg_stat, PostgreSQL VACUUM, EXPLAIN,pg stat activity, Autovacuum, ALTER DATABASE, PostgreSQL statistics collector, Shared buffers, EXPLAIN (PostgreSQL),EXPLAIN ANALYZE, Bitmap scan,EXPLAIN VERBOSE,EXPLAIN VERBOSE (PostgresSQL),WAL,ALTER USER,CREATE ROLE, CREATE USER,\du,show users,\l, The Statistics Collector, pganalyze,cron.schedule, Master,pg_tables, PostgreSQL replication,CREATE, SET, TOAST, PgBouncer, Restore DB, Index, meta-commands, Table, foreign table, Schema, Sequence, Views, materialized view, Table Partitioning, monitoring, PostgreSQL System Administration Functions, PostgreSQL extension, privileges, logging, PGTune, PostgreSQL parameter tunning, PostgreSQL modules, pgbench, PostgreSQL users, catalogs
Advertising:
