Questions tagged [file-system]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
28 views

Linux PostgreSQL mount data from external ntfs disk

I have similar problem as here: Postgres tablespace on mounted usb I want to have access to my DB on external hard drive from Raspbian and Windows 10. Not simultaneously. I just want cross-platform DB ...
0
votes
0answers
62 views

SSAS cube processing failed: File system error: Insufficient system resources exist to complete the requested service

Have a mysterious problem with SSAS, may be related to SSAS itself or to PKWare Smartcrypt TDE that we have installed on the server. PKWare should encrypt the data for all users outside the domain, ...
0
votes
1answer
124 views

Can I use `base/pgsql_tmp` directory for non-admin applications?

(( edit after answer: this is a typical XY question/problem, there are no restriction on use absolute path, on PostgreSQL's FileSystem functions. As @LaurenzAlbe comment, "just try". )) I ...
3
votes
1answer
168 views

Should I disable filesytem journaling for MS SQL Server (Linux/Windows)

For a PostgreSQL server installation on Linux, it is beneficial to disable filesystem journaling. Tip: Because WAL restores database file contents after a crash, journaled filesystems are not ...
12
votes
1answer
1k views

How is the new system stored procedure sys.xp_delete_files different from sys.xp_delete_file?

SQL Server 2019 introduced a new (and undocumented) system stored procedure: sys.xp_delete_files What, exactly, does this new extended stored procedure do? How does it differ from xp_delete_file ...
0
votes
2answers
96 views

On a typical COW filesystem, is the database WAL redundant (in theory)?

EDIT: I was incorrectly assuming that all COW filesystems have a WAL. IT seems that BTRFS doesn't, so this question essentially applies only to ZFS. Typical COW filesystems, like ZFS, have their own ...
1
vote
1answer
643 views

SQL Server DB Restore Unable to browse directory [closed]

I have a problem with SQL Server 2008. When I try to restore a backup (located in the default location). This error appears. Cannot access the specified path of file on the server. Verify that you ...