Skip to content

Instantly share code, notes, and snippets.

@borazuwarah

borazuwarah/a-sshAndSwitch.sh

Forked from josefglatz/a-sshAndSwitch.sh
Created January 18, 2023 12:27
Show Gist options
  • Save borazuwarah/896279f11a6c9a12117df9258a6b4649 to your computer and use it in GitHub Desktop.
Save borazuwarah/896279f11a6c9a12117df9258a6b4649 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment