Skip to content

Instantly share code, notes, and snippets.

@josefglatz

josefglatz/a-sshAndSwitch.sh

Last active July 12, 2024 20:50
Show Gist options
  • Save josefglatz/dd6ad5e6c146b6d389ab64df3b8c720d to your computer and use it in GitHub Desktop.
Save josefglatz/dd6ad5e6c146b6d389ab64df3b8c720d to your computer and use it in GitHub Desktop.
Download ZIP
Synology cheatsheet: how to query internal Synology postgresql database
Raw
a-sshAndSwitch.sh
# Connect to you NAS with YOUR admin account
ssh [email protected]
# go sudo
sudo -i
# switch to user postgres
su - postgres
Raw
b-ConnectToDatabaseServer.sh
# start psql CLI
psql
# list user and roles
\du
# Now be careful! May the force be with you
@borazuwarah
Copy link

nice

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment