Better Stack PostgreSQL logging

Start logging in 2 minutes

Collect logs from your PostgreSQL database using Vector.

1. Install

Select your platform:

Ubuntu • Debian

Configure the Vector APT repository and install Vector:

Install Vector

Copied!

curl -1sLf \
  'https://repositories.timber.io/public/vector/cfg/setup/bash.deb.sh' \
  | sudo -E bash
apt-get install vector

Configure the Vector YUM repository and install Vector:

Install Vector

Copied!

curl -1sLf \
  'https://repositories.timber.io/public/vector/cfg/setup/bash.rpm.sh' \
  | sudo -E bash
yum install vector

Install Vector using MSI installer:

Install Vector

Copied!

powershell Invoke-WebRequest https://packages.timber.io/vector/latest/vector-x64.msi \
  -OutFile vector-latest-x64.msi && \
  msiexec /i vector-latest-x64.msi /quiet

Install Vector using Vector installer:

Install Vector

Copied!

curl --proto '=https' --tlsv1.2 -sSf https://sh.vector.dev | sh -s -- -y

Create a Vector service:

Create a Vector service

Copied!

mkdir -p /etc/vector
mkdir -p /var/lib/vector/
cat <<-'SERVICE' >> /etc/systemd/system/vector.service
[Unit]
Description=Vector
Documentation=https://vector.dev
After=network-online.target
Requires=network-online.target

[Service]
User=vector
Group=vector
ExecStart=/root/.vector/bin/vector
ExecReload=/bin/kill -HUP $MAINPID
Restart=no
AmbientCapabilities=CAP_NET_BIND_SERVICE
EnvironmentFile=-/etc/default/vector

[Install]
WantedBy=multi-user.target
SERVICE

2. Setup

Download Vector configuration for your source:

Download Vector config

Copied!

wget -O ->> /etc/vector/vector.toml \
    https://logs.betterstack.com/vector-toml/postgresql/$SOURCE_TOKEN

3. Restart

Restart Vector to reload the configuration:

Restart Vector

Copied!

systemctl restart vector

You should see your logs in Better Stack -> Live tail.

Need help?

Please let us know at hello@betterstack.com.
We're happy to help! 🙏

Better Stack Ubuntu logging

Better Stack MongoDB logging

Explore documentation

Better Stack PostgreSQL logging

Start logging in 2 minutes

1. Install

2. Setup

3. Restart

Need help?

On this page