Questions tagged [file-system]

The tag has no usage guidance.

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

What kind of hardware / software architecture would be preferable for petabyte size data storage and replication? [closed]

For an upcoming feature, I got the task to develop a solution that would store data for years in a separate machine (let's call it master), while also replicating for disaster recovery. I'd like to ...
csttomi's user avatar
0 votes
2 answers
72 views

SQL Account cannot access file system

I have an issue with a service account that is used to import several files on its D: drive. In the past SA was used for this process, but of course it needed to be replaced by a service account. So I'...
El_Macho84's user avatar
0 votes
1 answer
435 views

How to keep Image data in file system with Postgres database?

I am wondering is there any way to store image type data (binary data) in postgresql not directly into the columns but resides in the file system but not gonna store the path link as text in database ...
Saadman Karim's user avatar
1 vote
1 answer
665 views

mariabackup system file permissions

I have an instance of mariadb 10.6.7 on an Ubuntu 22.04 Server and I am trying to do backups of a specific database with mariabackup. mariabackup --backup --user="my_test_user" --target-dir=/...
badlands's user avatar
-3 votes
1 answer
58 views

Maintenance : File system vs Database

I'm comparing the advantages and disadvantages of File system (journaling and COW) and Database (SQL and Non-SQL). Not only from the developer's point of view, I also want to know further what are the ...
naomikim's user avatar
0 votes
1 answer
1k views

Can PostgreSQL save an image to file system?

I'm using Postgraphile to interact with PostgreSQL, and I need upload images to server from my Android app. I plan to send an image as a base64 encoded string by using a mutation, this mutation is a ...
Ουιλιαμ Αρκευα's user avatar
0 votes
1 answer
63 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-...
Phillip's user avatar
  • 11
-1 votes
1 answer
519 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 ...
PAXMA's user avatar
  • 1
1 vote
1 answer
902 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 ...
Peter Krauss's user avatar
3 votes
1 answer
481 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 ...
atevm's user avatar
  • 337
12 votes
1 answer
7k 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 ...
Solomon Rutzky's user avatar
0 votes
2 answers
349 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 ...
Marcus's user avatar
  • 378
1 vote
1 answer
870 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 ...
full98's user avatar
  • 11