Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [file-system]

12 questions
12
votes
1 answer

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 that has been around for years? Does it replace…
Solomon Rutzky
  • 70,048
  • 8
  • 160
  • 306
3
votes
1 answer

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 necessary for reliable storage of the data files or WAL…
atevm
  • 337
  • 2
  • 7
1
vote
1 answer

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=/tmp/mdb_test --verbose But always end up with [00]…
badlands
  • 11
  • 2
1
vote
1 answer

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 need to export/import JSON files, CSV files, XML,…
Peter Krauss
  • 476
  • 1
  • 7
  • 13
1
vote
1 answer

SQL Server DB Restore Unable to browse directory

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 have the necessary security privileges and tha the…
full98
  • 11
  • 3
0
votes
1 answer

Is there any practice to align file system block size with database block size?

This topic has already been discussed here: Understanding block sizes But I have few more things to add for my use case. Generally, most database systems use a default block size of 8 KB, though some allow it to be modified. On the other hand,…
goodfella
  • 589
  • 4
  • 14
0
votes
1 answer

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 but store as binary type data using any kind of…
Saadman Karim
  • 21
  • 1
  • 3
0
votes
1 answer

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 PostgreSQL function that when is called will take…
Ουιλιαμ Αρκευα
  • 269
  • 1
  • 3
  • 10
0
votes
1 answer

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-oracle.com/t_linux_oracle_move_datafiles.htm My…
Phillip
  • 11
  • 2
  • 8
0
votes
2 answers

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 form of WAL (ZIL, in the case of ZFS). On a…
Marcus
  • 390
  • 1
  • 4
  • 15
-1
votes
1 answer

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 on my external disk, which is accessible for…
PAXMA
  • 1
  • 1
-3
votes
1 answer

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 challenges and difficulties in maintaining these…
naomikim
  • 1