On Thu, May 7, 2020 at 3:54 PM Surya Widyanto <ayrus02@gmail.com> wrote:
On 07-05-2020 11:01, Khushboo Vashi wrote:
Hi,
On Thu, May 7, 2020 at 6:04 AM Surya Widyanto <ayrus02@gmail.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.
BTW, on the link you gave above there is no mentioning about DATA_DIR variable on config file...?? Is there something I miss about the config?
For information, the LOG_FILE and SQLITE_PATH are working fine... I can see the log file and view the pgadmin4.db file and it's content. The SESSION_DB_PATH and STORAGE_DIR are both I check exists and inside it some folder are created acording to the account and session logged in to PGAdmin4 Server Mode.
Please check the permission of the file/directory you have changed. It should be 0700.