Questions tagged [file-system]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
40 views

Production filesystem is at 100%. Move the datafiles to a new filesystem?

As the title states our file system reached 100% capacity and I want to try moving the tablespaces datafiles to a new filesystem. I'm attempting to follow the steps from this link: http://www.dba-...
-1
votes
1answer
87 views

Linux PostgreSQL mount data from external ntfs disk [closed]

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
104 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
218 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
225 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
2k 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
114 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
730 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 ...