Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Export Postgres Database schema using pgAdmin 4 on Mac OS X (using SSH Tunneling)
- Assuming the SSH tunnel has been previously created.i.e.
- ```
- ssh -f server-user@hostname -L 54329:localhost:5432 -N
- ```
- The schema can be exported as follows:
- ```
- /Applications/pgAdmin 4.app/Contents/SharedSupport/pg_dump --file "/path/to/export/file.sql" --host "localhost" --port "54329" --username "dbuser" --no-password --verbose --format=p --schema-only "dbname"
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement