Re: Query tool - file browser

On Wed, Sep 13, 2017 at 11:26 AM, Johann Spies <jspies(at)sun(dot)ac(dot)za> wrote:

> pts rule name description
> ---- ---------------------- ------------------------------
> --------------------
> -1.0 ALL_TRUSTED Passed through trusted hosts only via SMTP
> 0.5 RP_MATCHES_RCVD Envelope sender domain matches handover relay
> domain
> 2.5 BAYES_50 BODY: Bayes spam probability is 40 to 60%
> [score: 0.5000]
> X-Pg-Spam-Score: -4.2 (----)
>
>
> > I am struggling to find out how to use sql-files from the query-tool.
> > When I try to open my home directory (with file type "All files") it
> > does not find my home directory. The gui seems to start at /. Why?
> >
>
> After deleting the database in ~/pgadmin and restarting pgadmin4 and
> reconfiguring the settings I can now open files and the server seems to
> find my filesystem. Earlier it told me that my home directory did not
> exist.

If you're running in Server mode (SERVER_MODE=True), then file storage is
(by default) on the server, in a per-user directory. This is so that you
have access to your files no matter where you login to pgAdmin from and to
prevent users from browsing the filesystem on your server.

If you're running in Desktop mode (SERVER_MODE=False), then you should have
access to the entire local filesystem.

See the STORAGE_DIR parameter in config.py (if you need to change it,
create - if needed - config_local.py in the same directory, and override
the setting there).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company