Telegram und Netgate

 In case you want your Netgate Firewall to send you TELEGRAM messages...

MENU -> Advanced -> Notification

Enable Telegram notification

Go to your Mobile and start Telegram APP

Chat with BotFaher: /newbot

Give your Bot a name

Copy the token you got in a save place and paste it into API Key flied

Send two dummy messages to your just created bot

Now comes the tricky part:

In your browser open: https://api.telegram.org/bot<HERE YOUR API KEY>/getUpdates

Search the "message":{"message_id":1,"from":{"id":<this is your ChatID>,"

Copy your ChatID to Netgate -> that's it, have fun!

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