PostGRESQL

 some easy hints for PostGRESQL

First: change user to postgres: sudo su postgres

Start the client: psql

Have a look on available databases: \l

Connect to a database: \c <databasename>

Reindex: reindex database <databasename>;

List of database users: \du

ATTENTION when upgrading to postgresql 14

You need to re-set user passwords as the hash algorithm changed:

\password "user_name"

VG is using an old PV header, modify the VG to update

 In case you get this error:

WARNING: PV /dev/sda5 in VG NameOfYourVolume is using an old PV header, modify the VG to update.

try: sudo vgck

then

sudo vgck --updatemetadata NameOfYourVolume

that's it