Questions tagged [configuration]

The choice of settings for hardware, firmware, software or other components of a database system.

Filter by
Sorted by
Tagged with
0 votes
1 answer
16 views

Mongod starting issue on ubuntu

When I try to check the status of mongodb I get the following: × mongod.service - MongoDB Database Server Loaded: loaded (/lib/systemd/system/mongod.service; enabled; vendor preset: enabled) ...
Rime Tazi's user avatar
0 votes
1 answer
47 views

Problem with saving data SQL

For some time now I have had a problem with saving data in the database. The problem is that after a sudden shutdown of the server, the data that was sent a minute earlier from the application was not ...
DanPil's user avatar
  • 1
0 votes
0 answers
16 views

MySQL 5.7 on Amazon Aurora - how to read the IO Cache vs. Disk Read metric?

I'm trying to determine how often InnoDB is hitting RAM vs. disk. Does db.Cache.innoDB_buffer_pool_hits.avg mean InnoDB went to the buffer pool? Does db.Cache.Innodb_buffer_pool_reads.avg mean that ...
mstrom's user avatar
  • 133
0 votes
0 answers
53 views

Why does a DPM protection group configured for Sync work for some databases in simple recovery model but not others?

I'm using System Center Data Protection Manager 10.22.197.0 to back up SQL Server 2022 CU 10 on Windows Server 2022. DPM agent is also 10.22.197.0 on these SQL servers. The SQL Server instance was ...
M Herbener's user avatar
0 votes
1 answer
62 views

why there are differences between sql server max memory and the actual utilization?

I have just asked infrastructure to add memory to a sql server box, the total memory now is 16Gb I have set the maximum memory in sql server to 12GB. when I run the memory query below: SELECT [...
Marcello Miorelli's user avatar
0 votes
1 answer
82 views

Best practices when customizing PostgreSQL configuration files

I am customizing my configuration files, both pg_hba.conf to allow LAN clients to access the DB on the machine and postgresql.conf to tweak my DB engine. By now I am just editing the files I've seen ...
Kodeeo's user avatar
  • 101
0 votes
1 answer
19 views

Network bottlenecks is concentrated on a specific host during query

I have deployed a CoC version of PieCloudDB in a private cloud environment. My S3 service consists of a cluster of three machines. During the deployment of PieCloudDB database, I specified one of the ...
Joe's user avatar
  • 1
0 votes
1 answer
100 views

In an Always On configuration, why do I have to open ports of the listener as well for the sql server engine itself for the listener ips?

We use an SQL Server 2019 Always On setup. 2 sql server 2019 nodes in same subnet : server01, server02 1 sql server 2019 node in other subnet : server03 We decided to create only 1 availability group ...
PekeDBA's user avatar
0 votes
0 answers
23 views

Ho to stop SSMS from reverting font settings

(Is this the correct forum for this question?) I teach Microsoft SQL for a training organisation. For teaching purposes, we’re using SQL Server Express and SSMS. I don’t like some of the defaults in ...
Manngo's user avatar
  • 2,819
2 votes
0 answers
57 views

What’s the penalty if I enable `track_commit_timestamp`?

I just learned about PostgreSQL’s xmin system column, pg_xact_commit_timestamp(xid) function and track_commit_timestamp option. I’m considering enabling this option on my PostgreSQL databases, as a ...
user2233709's user avatar
0 votes
1 answer
29 views

SSRS with remote ReportServer db - where to focus cpus/memory for processing

On an SSRS instance with a remote ReportServer db, where is the processing done? Should the SSRS instance vm get additional cpus and memory or the sql instance where the ReportServer db is? The ...
Bobogator's user avatar
1 vote
0 answers
211 views

macos ventura postgres 15 remote connections server closed the connection unexpectedly

macos ventura 13.5.1 postgresql (15.4 (Homebrew)) Remote connections for the server are closed "unexpectedly". I have done all the steps that are needed for postgres to be happy with remote ...
boar's user avatar
  • 13
0 votes
0 answers
55 views

How to check Default Isolation Level at server/instance level

We have installed SQL Server 2017 in 2 servers. Then created 2 databases same way in both servers. In one server I see my database snapshot isolation level is ON and another server its OFF. So, how ...
Imran Qadir Baksh - Baloch's user avatar
0 votes
1 answer
138 views

Manage PostgreSQL client backend

To get currently runnig processes, I run these queries : I have some questions about outputs: What is client backend? Why there are a lot of client backend? What does it mean? How to manage client ...
Mofarah's user avatar
  • 15
0 votes
1 answer
920 views

Configuration of max_worker_processes in PostgreSQL

We are going to run Hot-Standby Replication for our environment. In this YouTube link at 24:54, it was mentioned that, to run READ-ONLY queries in Hot-Standby we must increase max_worker_processes ...
Mofarah's user avatar
  • 15
0 votes
1 answer
95 views

How to enhance (the speed of) my database

First of all, I need to say that I have not much formal training for SQL, especially the backend, so anything I tested was a trial and error of advice found on the internet. I have a DB which stores ...
herhor67's user avatar
0 votes
1 answer
156 views

How much memory using for adaptive hash indexes in MariaDB?

I'm reading about adaptive hash indexes in MariaDB. It is created in memory, so it will be logically to know how much memory usually used for the index table. For example, my local development ...
rzlvmp's user avatar
  • 111
-3 votes
1 answer
43 views

Good training on shrinking / growing files on SQL Server

I am looking for basic file shrinking / growing training for SQL Server. I see a number of similar questions as I post this - will read those answers now
Debbie S's user avatar
0 votes
0 answers
115 views

Cannot change logging settings per-user in Postgresql

I have a special database role that only handles passwords, and I want to exclude it from database logs, but include logs from all other users. In my postgresql.conf file I have these custom settings: ...
Primordial_Hamster's user avatar
1 vote
2 answers
759 views

Why is the "startup" configuration different with SQL Server 2022

From the Microsoft web page: SQL Server services are set to Automatic (Delayed Start) start mode In SQL Server 2022 (16.x), setting the Start Mode for a SQL Server service to Automatic in ...
Dominique Boucher's user avatar
0 votes
1 answer
802 views

How to change query tool font and colors in PgAdmin 4?

In PgAdmin III, it is possible to change the font and colors for the query tool editor window in the options menu: I can't find any similar settings in the preferences window for PgAdmin 4. How and ...
Joe M's user avatar
  • 121
0 votes
1 answer
82 views

Which SQL Server database settings fall under ALTER DATABASE SCOPED CONFIGURATION vs ALTER DATABASE SET syntax?

I have noticed that there are two command syntaxes to change database configuration settings in SQL Server - ALTER DATABASE SCOPED CONFIGURATION and ALTER DATABASE SET. However, I am unclear on which ...
Fajela Tajkiya's user avatar
0 votes
2 answers
36 views

Setting parameter of other connection

I can set log_statement parameter to 'all' on the current connection. I want to do it for a few other connections on my database that are controlled by a connected web application. I know that I can ...
Trismegistos's user avatar
0 votes
1 answer
45 views

What is the suggested value for guardrail fields_per_udt_warn_threshold?

Cassandra has added guardrails feature some time ago, bust none of the guardrails have any default value set in the configuration file (see cassandra.yaml). I generally wonder how can a db admin know ...
Piotr Smaroń's user avatar
-1 votes
1 answer
323 views

how to get database settings such as LEGACY_CARDINALITY_ESTIMATION and INTERLEAVED_EXECUTION_TVF

I am moving some database finally to compatibility level 150 using the script below USE [master] GO ALTER DATABASE [DB1] SET COMPATIBILITY_LEVEL = 150 GO USE [...
Marcello Miorelli's user avatar
0 votes
3 answers
204 views

How to detect pending settings on db2set, dbm and db cfg level?

On Db2 v11.5.8.0 on Linux x86_64 I have several instances and databases. I would like to find out if there is some pending setting on: db2set variables dbm cfg dg cfg level? Questions: Is there a ...
folow's user avatar
  • 339
1 vote
2 answers
436 views

Registration of SPNs for Availability Groups

Manually registering SPNs for Availability group - Do I need to register SPNs for the AG Listener as well as the individual nodes, for both the instance name and the listening ports for the managed ...
PTL_SQL's user avatar
  • 329
0 votes
1 answer
81 views

postgresl.conf vs conf.d/*: which has greater precedence

If the same parameter it's set on ./postgresql.conf and on ./conf.d/something.conf which one has preference or which one overwrites the other one?
Héctor's user avatar
  • 297
0 votes
1 answer
292 views

Does it make sense to enlarge "shared_buffers" for writing Postgresql?

I'm using Postgresql-11, with a traditional HDD as the physical storing device. I need to optimize the performance for writing. I have changed the wal_buffers from -1 to 512MB, that means that ...
Leon's user avatar
  • 347
0 votes
1 answer
262 views

Where is Oracle TNS redirection configured?

The short version, I need to connect to an Oracle server and I am getting redirected to an IP address that is blocked by the firewall. What do I need to ask to find out what IP addresses I will be ...
user1683793's user avatar
0 votes
0 answers
110 views

How can i configure server in firebird.conf?

I want to connect an FDB database. However, no permission for all paths for this. And my FDB files are not in a path with permission. That's why I wanna make some changes in firebird.conf for server ...
sunShine's user avatar
2 votes
0 answers
110 views

Set custom postgresql.conf for one database on Mac using Postgres.app

I have ~20 PostgreSQL 14 databases on my local development machine running on Postgres.app. I am trying to pg_restore a single 100GB database to Amazon RDS, but I'm getting some inconsistencies with ...
sscirrus's user avatar
  • 121
0 votes
1 answer
79 views

Is replication on by default on MySQL 8.0.30 ? How to stop it?

I am running MySQL 8.0.30 on Rocky Linux 9. While importing some ~100GB sql files, I noticed the /var/lib/mysql is filled with binlog.000123 files, over 100GB. I assume these are created because ...
adrianTNT's user avatar
  • 195
0 votes
1 answer
608 views

Catalog cache too small - any method to determinate size?

On Db2/Linux_x86_64 in db2diag.log I constantly see warning about CATALOGCACHE_SZ parameter to be too small like: 2022-12-02-14.40.53.536711+060 E5979903E769 LEVEL: Warning PID : 4508 ...
folow's user avatar
  • 339
2 votes
1 answer
206 views

MySQL 8 replication: is it possible to specify master side a specific port for replication, and only replication (different than the default 3306)

Master side. In MySQL 8 for the replication, is it possible to specify master side a specific port for replication, and only replication that is different than the default 3306 where regular clients ...
Déjà vu's user avatar
  • 473
16 votes
2 answers
3k views

Why is SQL Server setup recommending MAXDOP 8 here?

I'm running SQL Server 2022 RC1 setup on an AWS i3.16xlarge with 2 sockets, 2 NUMA nodes, 32 logical processors per node, 64 logical processors altogether. Setup is recommending MAXDOP 8: But if you ...
Brent Ozar's user avatar
0 votes
1 answer
1k views

Setting custom MariaDB max_allowed_packet value in Debian 11?

[This is more of an OS config file question, but I have had no response on Unix.SE, so I am hoping that the 'join' of DB admins and sysadmins here may result in better luck…] Our Moodle server, ...
dave559's user avatar
  • 121
1 vote
1 answer
3k views

password authentication failed for user "postgres"

The sample.sql is simple. create database test; The settings on /etc/postgresql/13/main/pg_hba.conf. local all postgres md5 local all all ...
showkey's user avatar
  • 334
1 vote
2 answers
189 views

Make data rotation with MariaDB database

We have a small local computer that we use as a temporary database backup to automatically recover data from sensors when we lost connection to the main cloud server or when we have to make ...
Afaeld's user avatar
  • 23
0 votes
0 answers
35 views

Postgres - basic security settings

I'm setting up a PostgreSQL instance for some logging data (non-critical). It will be accessible from internet. It's hosted on an azure VM. I'm wondering what would be a decent setup to have basic ...
user49126's user avatar
  • 103
0 votes
1 answer
1k views

Server 'repl_distributor' is not configured for DATA ACCESS

I have enabled my repl_distributor linked server for data access in both publisher_server and distributor_server. Both servers are also configured to allow remote connections On both servers I have ...
Marcello Miorelli's user avatar
-1 votes
1 answer
4k views

The conversion of a varchar data type to a datetime data type resulted in an out-of-range value when running T-SQL query

Please note I am not a coder by any means, I am simply trying to assist with a migration from SQL Server 2008 R2 and 2008 to SQL Server 2022 and 2019. When I execute the following T-SQL query: select ...
Mark de Wet's user avatar
1 vote
1 answer
72 views

Mysql: sorting rows of a subquery generated table not working working

I have a subquery (generated by an ORM for pagination purposes) that generates a table that is then sorted by the parent query. SELECT DISTINCT `distinctAlias`.`invoice_id` AS 'ids_invoice_id', ...
Yousif's user avatar
  • 27
0 votes
0 answers
358 views

Optimized MariaDB configuration on my Server to prevent lock wait timeouts

I'm having issues recently with my galera cluster getting desync after multiple lock wait timeouts, is there any way I can improve my galera cluster configuration to prevent more lock wait timeouts ...
Glen G's user avatar
  • 3
1 vote
1 answer
629 views

Oracle 19 - RMAN can't connect to database

I have troubles with starting RMAN and connecting to target database. I start RMAN ($ORACLE_HOME & $ORACLE_SID env variables are set) [oracle@MY_MACHINE /]$ /u01/app/oracle/product/19.0.0/dbhome_1/...
MBi's user avatar
  • 13
2 votes
1 answer
412 views

simulate case sensitive collation in ssms

I know that it is not possible to set a collation for a session in sql server. I have different servers with different collations, however, one of them is a case sensitive collation and that can be ...
Marcello Miorelli's user avatar
0 votes
0 answers
80 views

SQL Server - Measuring impact of CTFP change....at server level

I have a SQL Server 2017 server and CTFP has been set to 5 since it was set up. I'm considering changing it. I'm comfortable in monitoring the impact of this change at the individual query level - ...
FrugalShaun's user avatar
0 votes
1 answer
4k views

docker mariadb ignores to read my.cnf files from mounted volume

This problem is annoying me very much, it might be something stupidly simple to a good system admin but i've wasted many hours without success, i've tried many answer from SO and other websites and ...
Rafael Lima's user avatar
0 votes
1 answer
96 views

Valid characters for PostgreSQL session parameters

Where can I find the list of characters which are valid for PostgreSQL configuration parameter names? By trial and error I found that '.' and '_' are valid, but ':' isn't. Quoting doesn't seem to help....
Isac Casapu's user avatar
2 votes
0 answers
208 views

Does pgAdmin4 allow session recovery?

I'm used to HeidiSQL, where your tabs and their states are always remembered and come back when you reopen the program. Can pgAdmin4 automatically reopen the tabs used in its last run?
Federico Matonte's user avatar

1
2 3 4 5
14