postgres.logs | Logflare | Cloudflare, Vercel & Elixir Logging

~/logs/postgres.logs

1784282641918790 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "b564e4b1-0839-4670-9d14-7667f32e87e6",
  "project": "default",
  "timestamp": 1784282641918790
}

1784282641919154 PostgreSQL Database directory appears to contain a database; Skipping initialization event body

{
  "appname": "supabase-db",
  "event_message": "PostgreSQL Database directory appears to contain a database; Skipping initialization",
  "id": "935cca59-58da-42a7-829e-4548b95b1e04",
  "project": "default",
  "timestamp": 1784282641919154
}

1784282641919169 event body

{
  "appname": "supabase-db",
  "event_message": null,
  "id": "64e852c3-4918-4a98-8404-b79ef07449ef",
  "project": "default",
  "timestamp": 1784282641919169
}

1784282643377208 172.30.0.2 2026-07-17 10:04:03.368 UTC [37] supabase_auth_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.2 2026-07-17 10:04:03.368 UTC [37] supabase_auth_admin@postgres FATAL:  the database system is starting up",
  "id": "f20f2b0e-4425-4bd2-9c52-44c52e546d7b",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:03.377208897Z"
    }
  },
  "project": "default",
  "timestamp": 1784282643377208
}

1784282643379447 172.30.0.2 2026-07-17 10:04:03.377 UTC [39] supabase_auth_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.2 2026-07-17 10:04:03.377 UTC [39] supabase_auth_admin@postgres FATAL:  the database system is starting up",
  "id": "e15cf3d8-6544-465a-8771-e2856d44565b",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:03.379447759Z"
    }
  },
  "project": "default",
  "timestamp": 1784282643379447
}

1784282643803723 172.30.0.8 2026-07-17 10:04:03.772 UTC [40] authenticator@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.8 2026-07-17 10:04:03.772 UTC [40] authenticator@postgres FATAL:  the database system is starting up",
  "id": "3bfcb52d-374e-4c6f-9c06-52e3cc910db1",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:03.803723146Z"
    }
  },
  "project": "default",
  "timestamp": 1784282643803723
}

1784282643896761 172.30.0.8 2026-07-17 10:04:03.893 UTC [41] authenticator@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.8 2026-07-17 10:04:03.893 UTC [41] authenticator@postgres FATAL:  the database system is starting up",
  "id": "8c9d9805-820a-4153-a324-891fa09a8394",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:03.896761665Z"
    }
  },
  "project": "default",
  "timestamp": 1784282643896761
}

1784282643904218 172.30.0.8 2026-07-17 10:04:03.898 UTC [42] authenticator@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.8 2026-07-17 10:04:03.898 UTC [42] authenticator@postgres FATAL:  the database system is starting up",
  "id": "2b952acf-bc8f-45c0-a090-b91f97cb4661",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:03.904218547Z"
    }
  },
  "project": "default",
  "timestamp": 1784282643904218
}

1784282643955134 172.30.0.8 2026-07-17 10:04:03.905 UTC [43] authenticator@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.8 2026-07-17 10:04:03.905 UTC [43] authenticator@postgres FATAL:  the database system is starting up",
  "id": "de17f7a5-087b-4a00-9c4a-e3de2e3e2039",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:03.955134380Z"
    }
  },
  "project": "default",
  "timestamp": 1784282643955134
}

1784282643955172 172.30.0.8 2026-07-17 10:04:03.933 UTC [44] authenticator@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.8 2026-07-17 10:04:03.933 UTC [44] authenticator@postgres FATAL:  the database system is starting up",
  "id": "4aa78a51-b9a0-4664-a290-57168e83b586",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:03.955172506Z"
    }
  },
  "project": "default",
  "timestamp": 1784282643955172
}

1784282645359885 172.30.0.9 2026-07-17 10:04:05.358 UTC [45] supabase_admin@_supabase FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:05.358 UTC [45] supabase_admin@_supabase FATAL:  the database system is starting up",
  "id": "508cae8b-d20a-40fd-98e1-b595e06e76a0",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:05.359885977Z"
    }
  },
  "project": "default",
  "timestamp": 1784282645359885
}

1784282645362128 172.30.0.9 2026-07-17 10:04:05.360 UTC [46] supabase_admin@_supabase FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:05.360 UTC [46] supabase_admin@_supabase FATAL:  the database system is starting up",
  "id": "13dc76d4-eaca-4825-9c32-612b42f85118",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:05.362128095Z"
    }
  },
  "project": "default",
  "timestamp": 1784282645362128
}

1784282646095790 ::1 2026-07-17 10:04:06.095 UTC [53] postgres@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "::1 2026-07-17 10:04:06.095 UTC [53] postgres@postgres FATAL:  the database system is starting up",
  "id": "d58f9d4d-9d82-45bd-aa11-37c463cfda3a",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:06.095790638Z"
    }
  },
  "project": "default",
  "timestamp": 1784282646095790
}

1784282646262898 172.30.0.11 2026-07-17 10:04:06.261 UTC [55] supabase_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.11 2026-07-17 10:04:06.261 UTC [55] supabase_admin@postgres FATAL:  the database system is starting up",
  "id": "4b35863a-777e-4a2e-a79b-9fb0316f7a0a",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:06.262898867Z"
    }
  },
  "project": "default",
  "timestamp": 1784282646262898
}

1784282646267406 172.30.0.11 2026-07-17 10:04:06.263 UTC [54] supabase_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.11 2026-07-17 10:04:06.263 UTC [54] supabase_admin@postgres FATAL:  the database system is starting up",
  "id": "d084a89b-73b3-4c03-837a-c51f4bd3ff00",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:06.267406398Z"
    }
  },
  "project": "default",
  "timestamp": 1784282646267406
}

1784282646850836 172.30.0.9 2026-07-17 10:04:06.824 UTC [56] supabase_admin@_supabase FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:06.824 UTC [56] supabase_admin@_supabase FATAL:  the database system is starting up",
  "id": "fffd7107-ab0c-41d6-bd36-fe4fe5cff919",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:06.850836372Z"
    }
  },
  "project": "default",
  "timestamp": 1784282646850836
}

1784282647306961 172.30.0.2 2026-07-17 10:04:07.304 UTC [58] supabase_auth_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.2 2026-07-17 10:04:07.304 UTC [58] supabase_auth_admin@postgres FATAL:  the database system is starting up",
  "id": "f9f30075-a7eb-4f3f-9545-cf6080f92b84",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:07.306961997Z"
    }
  },
  "project": "default",
  "timestamp": 1784282647306961
}

1784282647341445 172.30.0.2 2026-07-17 10:04:07.331 UTC [60] supabase_auth_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.2 2026-07-17 10:04:07.331 UTC [60] supabase_auth_admin@postgres FATAL:  the database system is starting up",
  "id": "f810dbc7-eb3f-423d-9002-a331e33e6e53",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:07.341445688Z"
    }
  },
  "project": "default",
  "timestamp": 1784282647341445
}

1784282647411348 172.30.0.9 2026-07-17 10:04:07.409 UTC [61] supabase_admin@_supabase FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:07.409 UTC [61] supabase_admin@_supabase FATAL:  the database system is starting up",
  "id": "09aecb68-286f-4465-9e2e-e534155d657f",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:07.411348093Z"
    }
  },
  "project": "default",
  "timestamp": 1784282647411348
}

1784282648095402 172.30.0.11 2026-07-17 10:04:07.950 UTC [62] supabase_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.11 2026-07-17 10:04:07.950 UTC [62] supabase_admin@postgres FATAL:  the database system is starting up",
  "id": "71bb8457-d55b-440e-b3cb-2a5b725d9781",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:08.095402403Z"
    }
  },
  "project": "default",
  "timestamp": 1784282648095402
}

1784282652699594 172.30.0.11 2026-07-17 10:04:09.437 UTC [63] supabase_admin@postgres FATAL: the database system is starting up event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.11 2026-07-17 10:04:09.437 UTC [63] supabase_admin@postgres FATAL:  the database system is starting up",
  "id": "b08b6ce6-0397-4acf-b480-90d3729147d6",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:12.699594643Z"
    }
  },
  "project": "default",
  "timestamp": 1784282652699594
}

1784282652699606 172.30.0.9 2026-07-17 10:04:10.341 UTC [64] supabase_admin@_supabase FATAL: the database system is not accepting connections event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:10.341 UTC [64] supabase_admin@_supabase FATAL:  the database system is not accepting connections",
  "id": "21babfdb-80c6-45b7-854d-7b7388c4935a",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:12.699606212Z"
    }
  },
  "project": "default",
  "timestamp": 1784282652699606
}

1784282652699610 172.30.0.9 2026-07-17 10:04:10.341 UTC [64] supabase_admin@_supabase DETAIL: Hot standby mode is disabled. event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:10.341 UTC [64] supabase_admin@_supabase DETAIL:  Hot standby mode is disabled.",
  "id": "a7562e0f-d7a7-40da-a45d-ea51c257a551",
  "project": "default",
  "timestamp": 1784282652699610
}

1784282652699615 172.30.0.9 2026-07-17 10:04:10.600 UTC [65] supabase_admin@_supabase FATAL: the database system is not accepting connections event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:10.600 UTC [65] supabase_admin@_supabase FATAL:  the database system is not accepting connections",
  "id": "b658f09c-4802-46d2-b01d-f873c8822438",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:12.699615104Z"
    }
  },
  "project": "default",
  "timestamp": 1784282652699615
}

1784282652699619 172.30.0.9 2026-07-17 10:04:10.600 UTC [65] supabase_admin@_supabase DETAIL: Hot standby mode is disabled. event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.9 2026-07-17 10:04:10.600 UTC [65] supabase_admin@_supabase DETAIL:  Hot standby mode is disabled.",
  "id": "a2784a64-32f7-4e11-955f-02d54c22d126",
  "project": "default",
  "timestamp": 1784282652699619
}

1784282657504591 172.30.0.11 2026-07-17 10:04:13.237 UTC [66] supabase_admin@postgres FATAL: the database system is not accepting connections event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.11 2026-07-17 10:04:13.237 UTC [66] supabase_admin@postgres FATAL:  the database system is not accepting connections",
  "id": "1c2eeb3c-6f7e-4c6c-9ed5-9e6d9feb8c48",
  "metadata": {
    "host": "db-default",
    "parsed": {
      "error_severity": "FATAL",
      "timestamp": "2026-07-17T10:04:17.504591157Z"
    }
  },
  "project": "default",
  "timestamp": 1784282657504591
}

1784282657504628 172.30.0.11 2026-07-17 10:04:13.237 UTC [66] supabase_admin@postgres DETAIL: Hot standby mode is disabled. event body

{
  "appname": "supabase-db",
  "event_message": "172.30.0.11 2026-07-17 10:04:13.237 UTC [66] supabase_admin@postgres DETAIL:  Hot standby mode is disabled.",
  "id": "c7e59e6f-1922-4d1e-90b6-1ee81d6026fa",
  "project": "default",
  "timestamp": 1784282657504628
}

random(tips): Match a field with regex (e.g. `m.browser:~"Firefox 5\d"`).

Source ID

You'll need this source ID for some integrations or libraries.

4887d8ed-29e0-41d6-b47e-196d23434c0c

If you're hosted on Vercel setup our Vercel integration!

Install the Vercel integration

Gigalixir

Install the Gigalixir command line tool, and navigate to your project directory.

          
    gigalixir drains:add "http://localhost:4000/logs/logplex?api_key=PSRzt-H4UjBP&source=4887d8ed-29e0-41d6-b47e-196d23434c0c"

Cloudflare App

Already on Cloudflare? Install the Cloudflare app and start sending logs now.

Heroku

Add our log drain with a simple command.

          
    heroku drains:add "http://localhost:4000/logs/logplex?api_key=PSRzt-H4UjBP&source=4887d8ed-29e0-41d6-b47e-196d23434c0c"

Elixir Logger

Using Elixir? Use our Logger backend to send your structured logs.

Setup the Logger backend

Elixir Agent

Watch log files on a server with our Elixir agent.

Install the agent

Javascript

Use our official Pino transport to send log events from your Javascript project.

Setup the Pino transport

Github Webhook

Set your Github webhook to this Logflare endpoint and we'll ingest Github webhooks for you. This endpoint drops all keys ending in _url so it keeps your Github payloads in check.

        
http://localhost:4000/logs/github?api_key=PSRzt-H4UjBP&source=4887d8ed-29e0-41d6-b47e-196d23434c0c

Github Action

Use our Github Action (thanks @gr2m) to easily log events coming from your repositories.

Setup the Github Action

Fluent Bit

Watch log files on a server with this Fluent Bit output config.

          
    [INPUT]
        Name        tail
        Path        /var/log/syslog

    [OUTPUT]
        Name             http
        Match            *
        tls              On
        Host             api.logflare.app
        Port             443
        URI              /logs/json?api_key=PSRzt-H4UjBP&source=4887d8ed-29e0-41d6-b47e-196d23434c0c
        Format           json
        Retry_Limit      5
        json_date_format iso8601
        json_date_key    timestamp

Generic Webhook

Use the generic JSON ingest endpoint to generate log events from an external webhook.

e.g. you can set a Github webhook to send events to:

          
http://localhost:4000/logs/json?api_key=PSRzt-H4UjBP&source=4887d8ed-29e0-41d6-b47e-196d23434c0c

Or send generic JSON events yourself.

          
    curl -X "POST" "http://localhost:4000/logs/json?source=4887d8ed-29e0-41d6-b47e-196d23434c0c" \
         -H 'Content-Type: application/json; charset=utf-8' \
         -H 'X-API-KEY: PSRzt-H4UjBP' \
         -d $'[
      {
        "yellow": true,
        "tags": [
          "popular, tropical, organic"
        ],
        "store": {
          "state": "AZ",
          "city": "Phoenix",
          "zip": 85016,
          "address": "123 W Main St"
        },
        "type": "fruit",
        "name": "banana",
        "qty": 12
      }
    ]'

Custom API Request

Send logs via an HTTP request. This request body payload lets you send over a human readable event message in the message field.

          
    curl -X "POST" "http://localhost:4000/logs?source=4887d8ed-29e0-41d6-b47e-196d23434c0c" \
    -H 'Content-Type: application/json' \
    -H 'X-API-KEY: PSRzt-H4UjBP' \
    -d $'{
      "event_message": "This is another log message.",
      "metadata": {
        "ip_address": "100.100.100.100",
        "request_method": "POST",
        "custom_user_data": {
          "vip": true,
          "id": 38,
          "login_count": 154,
          "company": "Apple",
          "address": {
            "zip": "11111",
            "st": "NY",
            "street": "123 W Main St",
            "city": "New York"
          }
        },
        "datacenter": "aws",
        "request_headers": {
          "connection": "close",
          "user_agent": "chrome"
        }
      }
    }'

Custom Cloudflare Worker

Customize the Cloudflare worker using the template below.

          
    const makeid = length => {
        let text = ""
        const possible = "ABCDEFGHIJKLMNPQRSTUVWXYZ0123456789"
        for (let i = 0; i < length; i += 1) {
            text += possible.charAt(Math.floor(Math.random() * possible.length))
        }
        return text
    }

    const buildMetadataFromHeaders = headers => {
        const responseMetadata = {}
        Array.from(headers).forEach(([key, value]) => {
            responseMetadata[key.replace(/-/g, "_")] = value
        })
        return responseMetadata
    }

    const WORKER_ID = makeid(6)

    async function handleRequest(event) {
        const {
            request
        } = event;
        const rMeth = request.method
        const rUrl = request.url
        const uAgent = request.headers.get("user-agent")
        const rHost = request.headers.get("host")
        const cfRay = request.headers.get("cf-ray")
        const cIP = request.headers.get("cf-connecting-ip")
        const rCf = request.cf

        const requestMetadata = buildMetadataFromHeaders(request.headers)

        const sourceKey = "4887d8ed-29e0-41d6-b47e-196d23434c0c"
        const apiKey = "PSRzt-H4UjBP"

        const t1 = Date.now()
        const response = await fetch(request)
        const originTimeMs = Date.now() - t1

        const statusCode = response.status

        const responseMetadata = buildMetadataFromHeaders(response.headers)

        const logEntry = `${rMeth} | ${statusCode} | ${cIP} | ${cfRay} | ${rUrl} | ${uAgent}`

        const logflareEventBody = {
            source: sourceKey,
            log_entry: logEntry,
            metadata: {
                response: {
                    headers: responseMetadata,
                    origin_time: originTimeMs,
                    status_code: response.status,
                },
                request: {
                    url: rUrl,
                    method: rMeth,
                    headers: requestMetadata,
                    cf: rCf,
                },
                logflare_worker: {
                    worker_id: WORKER_ID,
                },
            },
        }

        const init = {
            method: "POST",
            headers: {
                "X-API-KEY": apiKey,
                "Content-Type": "application/json",
                "User-Agent": `Cloudflare Worker via ${rHost}`
            },
            body: JSON.stringify(logflareEventBody),
        }

        event.waitUntil(fetch("http://localhost:4000/logs", init))

        return response
    }

    addEventListener("fetch", event => {
        event.passThroughOnException()

        event.respondWith(handleRequest(event))
    })