This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

PostgreSQL log clear

/etc/init.d/postgresql92 rebuild - builds new fresh database, but how to delete entries from PostgreSQL where user authentication entries are stored, which are related to last 20 sessions displayed when you click on 'Management'?

This thread was automatically locked due to age.

0 Michael_Kuerschner over 4 years ago

Hello Menen,

why?

but you can switch on CLI to user postgres and start the command psql. The requested database for this information is reporting. The rest you should see...

Regards,

Michael
Cancel
Vote Up 0 Vote Down

Cancel
0 emmosophos over 4 years ago

Hello Menen,

Thank you for contacting the Sophos Community!

Yes, that command would rebuild the database but that won't delete entries from Postgres.

As Michael mentioned What are you trying to achieve?

Regards,

Emmanuel (EmmoSophos)

Technical Team Lead, Global Community Support
Sophos Support Videos | Product Documentation | @SophosSupport | Sign up for SMS Alerts
If a post solves your question use the 'Verify Answer' link.
Cancel
Vote Up 0 Vote Down

Cancel
0 Menen over 4 years ago in reply to Michael_Kuerschner

Hello,
I should open FireWall CLI with user postgres? What is the password for it? And type psql? No other parameters?
Cancel
Vote Up 0 Vote Down

Cancel
0 Menen over 3 years ago in reply to emmosophos

I'm trying to delete 10 last logins from 20 list.
Cancel
Vote Up 0 Vote Down

Cancel
0 emmosophos over 3 years ago in reply to Menen

Hello Menen,

Thank you for the follow-up!

As far as I know, this is not possible or supported via postgres command.

Regards,

Emmanuel (EmmoSophos)

Technical Team Lead, Global Community Support
Sophos Support Videos | Product Documentation | @SophosSupport | Sign up for SMS Alerts
If a post solves your question use the 'Verify Answer' link.
Cancel
Vote Up 0 Vote Down

Cancel