Re: PGAdmin Installed As Server Mode on Windows Apache Cannot Do Backup-Restore with Access Denied Message

Hi,

On Thu, May 7, 2020 at 6:04 AM Surya Widyanto <ayrus02(at)gmail(dot)com> wrote:

> Hi,
>
> Recently I've successfully upgraded to PGAdmin v4.21 as Server Mode, but I
> had some problem when do Database Backup/Restore from PGAdmin.
> When I try to browse the directory/folder to store my backup file, the
> PGAdmin4 give Access Denied message. I cannot view the directory content
> which I try to save the backup file.
>
> Is there any config or setup file I missed to configure the directory
> permission on Windows?
>
> Another problem is after I upgraded to v4.21, I cannot refresh my
> materialized view using the right click context menu with error
> *Failed to create materialized view refresh job. [WinError 2] The system
> cannot find the specified file*
>
> What can I do so I can refresh my materialized view except from running it
> manually in Query Editor?
>
> FYI: I run the PGAdmin4 on Windows Server 2016 Standard (x64) and
> Apache/2.4.41 (Win64) mod_wsgi/4.7.1 Python/3.8
>
> Have you changed any config settings related to PATH (DATA_DIR,
SESSION_DB_PATH etc)?
On Windows, the DATA_DIR is set to %APPDATA%\pgAdmin by default.
Reference:
https://www.pgadmin.org/docs/pgadmin4/4.21/server_deployment.html#configuration

> Regards,
> Surya
>