Jump to content
XPEnology Community

CHAT database


trek102

Recommended Posts

Synology stores it in a Postgres SQL DB, including data from the MediaServer, NoteStation, etc.

 

Enable SSH/Terminal access and connect with PuTTy (or similar tools).

 

enter:

 

sudo -u postgres psql

 

followed by your admin password.

 

Your input cursor should change to "postgres=#".

 

The command

 

\l (<- little L)

 

shows a list of all databases. To connect to the synochat DB type

 

\c synochat

 

With

 

\q

 

you'll quit the session.

 

 

 

 

Link to comment
Share on other sites

thanks for this! Very helpful.

Do you happen to know if actual chat messages can be retrieved (after they are purged inside the app)? Or do we have to remove the records from the SQL database to be sure?

Also, are the messages from encrypted chats also encrypted in the DB or can they be read?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...