Home Original page

Better Stack PostgreSQL logging | Better Stack Documentation

Start logging in 2 minutes

What you would like to collect from your PostgreSQL?

Collect logs & metrics

Collect logs and metrics from your PostgreSQL database using Vector and Prometheus postgres exporter.

1. Set up PostgreSQL exporter

Create a dedicated PostgreSQL user for Vector to securely scrape metrics:

Create a new user

Copied!

Fill in your password

Replace your_password_here with password of your choice.

Create /etc/postgres_exporter.conf config file using PostgreSQL user password you've just set:

/etc/postgres_exporter.conf

Copied!

2. Install PostgreSQL exporter

Install latest postgres exporter:

Install postgres exporter

Copied!

3. Run exporter

Start the PostgreSQL exporter:

4. Set up Vector

Select your platform:

Install and configure Vector on Ubuntu or Debian:

Install and configure Vector on any Red Hat-based Linux:

Install and configure Vector on macOS:

Curious about what the script does?

  • Installs Vector using official package.
  • Configures Vector for your Better Stack source.
  • Enables and restarts Vector.

The script will ask for confirmation before making any changes.

You should see your logs in Better Stack → Live tail.

Collect only logs

Collect logs from your PostgreSQL database using Vector.

Select your platform:

Install and configure Vector on Ubuntu or Debian:

Install and configure Vector on any Red Hat-based Linux:

Install and configure Vector on macOS:

Curious about what the script does?

  • Installs Vector using official package.
  • Configures Vector for your Better Stack source.
  • Enables and restarts Vector.

The script will ask for confirmation before making any changes.

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! 🙏

Additional information

Looking for manual instructions to set up Vector?

Find step-by-step instructions in our dedicated Vector guide.