You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Dan Sosedoff edited this page Jun 17, 2023
·
6 revisions
When using pgweb you might find that there's no way to quickly
establish connection to a server even if you've connected to it
many times before. Thats's correct, pgweb does not keep track of
those connections. So bookmarks feature comes into play.
It basically allows you to keep connection settings to your most
frequent servers as a bookmarks with credentials stored in a file
on your local filesystem, encoded as TOML. Bookmark files are stored
in ~/.pgweb/bookmarks directory.
Here's an example of a bookmark file (~/.pgweb/bookmarks/local-server.toml):
Here's an example of a bookmark file with SSH options (~/.pgweb/bookmarks/ssh-tunnel-to-db.toml). Use this to create an SSH connection through a "Jump server" using an SSH credential file, to another database (such as AWS RDS):
Keeping server bookmarks as files is very handy, you can sync those
as git repository or in Dropbox. TOML format is also very simple and
similar to INI format. Other formats, such as YAML or JSON, could also
be supported in future.