Skip to content

Instantly share code, notes, and snippets.

@josefglatz

josefglatz/a-sshAndSwitch.sh

Last active January 8, 2024 18:07
Show Gist options
  • Star 5 You must be signed in to star a gist
  • Fork 4 You must be signed in to fork a gist
  • 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 yourAdminUserAccount@nas.ip
# 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