Postgresql "Connection reset by peer"

[HellmannK]

Hi,

my paperless-ng is working fine and I think i have no real issues, at least non I know of. The only thing is my postgresql server is messing its error.log up with this message: "LOG: could not receive data from client: Connection reset by peer"... But the data is received, is that maybe a worker or something who isnt closing connection by itself and postgresql is doing it for paperless-ng?

greetings :)

[GameWatchProjects]

Here an example for a docker installation. You can use docker compose or portainer stack. Create the folders on your volume and enjoy ... (tip: wait few minutes (arround 10 Minutes for the first start) when all conatiners are done ...

` version: "3.4"

services:

broker: container_name: paperless-redis image: redis:6.0 restart: unless-stopped

webserver: container_name: paperless image: jonaswinkler/paperless-ng:latest restart: unless-stopped depends_on:

• db
• broker
• gotenberg
• tika ports:
• 80:8000 healthcheck: test: ["CMD", "curl", "-f", "http://localhost:8000"] interval: 30s timeout: 10s retries: 5 volumes:
• /home/docker/paperless/data:/usr/src/paperless/data
• /home/docker/paperless/media:/usr/src/paperless/media
• /home/docker/paperless/export:/usr/src/paperless/export

• /home/docker/paperless/consume:/usr/src/paperless/consume environment: PAPERLESS_REDIS: redis://broker:6379 PAPERLESS_DBHOST: db USERMAP_UID: 1000 USERMAP_GID: 100 PAPERLESS_OCR_LANGUAGES: eng deu PAPERLESS_SECRET_KEY: ADD_HERE_AN_VERY_LONG_PASSPHRASE_WITH_SIGNS_AND_NUMBERS PAPERLESS_TIME_ZONE: Europe/Berlin PAPERLESS_OCR_LANGUAGE: deu PAPERLESS_FILENAME_FORMAT: "{created_year}/{correspondent}/{document_type}/{created_day}-{created_month}-{createdyear}{asn}_{title}" #Use here your owen file structure PAPERLESS_LOGROTATE_MAX_SIZE: 1MiB PAPERLESS_LOGROTATE_MAX_BACKUPS: 20 PAPERLESS_TIKA_ENABLED: 1 PAPERLESS_TIKA_GOTENBERG_ENDPOINT: http://gotenberg:3000/forms/libreoffice/convert# PAPERLESS_TIKA_ENDPOINT: http://tika:9998

  gotenberg: image: thecodingmachine/gotenberg:latest restart: unless-stopped environment: DISABLE_GOOGLE_CHROME: 1 DEFAULT_WAIT_TIMEOUT: 30

  tika: image: apache/tika:latest restart: unless-stopped

  db: container_name: paperless-db image: postgres:13 restart: unless-stopped volumes:

  • /home/docker/paperless/db:/var/lib/postgresql/data environment: POSTGRES_DB: paperless POSTGRES_USER: paperless POSTGRES_PASSWORD: paperless

  db-backup: image: postgres:13 volumes:

• /home/docker/paperless/database-dump:/dump
• /etc/localtime:/etc/localtime:ro environment: PGHOST: db PGDATABASE: paperless PGUSER: paperless PGPASSWORD: paperless BACKUP_NUM_KEEP: 10 BACKUP_FREQUENCY: 1d entrypoint: | bash -c 'bash -s <<EOF trap "break;exit" SIGHUP SIGINT SIGTERM sleep 2m while /bin/true; do pgdump -Fc > /dump/dump`date +%d-%m-%Y""%H%M_%S`.psql (ls -t /dump/dump.psql|head -n $$BACKUP_NUM_KEEP;ls /dump/dump.psql)|sort|uniq -u|xargs rm -- {} sleep $$BACKUP_FREQUENCY done EOF' `