If you need to pre-generate a scram-sha256 password hash for use with postgres, e.g. for using it with...

When you are using PgBouncer with e.g. a Ruby on Rails application which uses different application_names for the PostgreSQL...

You can use pg_repack to do a VACUUM FULL without holding an exclusive lock during processing. There is still...

For some reason you have to pass the password hash if you want to create a role in postgres. To...

Attention This is an edge-case. You probably don't want to mix different database dumps. It also requires that...

When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?

When changing the glibc version, it's possible that the upgrade also includes changes to how locales work.

If you use third party APT sources you might end up with unmaintained packages after removing the external source or...

If your postgres database is only accessible from inside a kubernetes cluster, e.g. if it's configured in AWS RDS...

There is an issue with when restoring a PostgreSQL dump created with pg_dump < v11 with pg_restore > v10:

If you have a PostgreSQL dump in the custom format you can can view the text format dump (plain SQL...

This card is just about creating simple PostgreSQL dumps. This is no instruction for a backup strategy nor a guide...

Hint This applies only to distributions based on Debian. Requirement You need to setup the PostgreSQL Apt Repository first.

on the bash (issued as postgres user) Start/Stop/Restart PostgreSQL pg_ctl -D $configdir start|stop|restart Start/Stop/Restart the corresponding PostgreSQL...