Questions tagged [configuration]
The choice of settings for hardware, firmware, software or other components of a database system.
679
questions
0
votes
0
answers
58
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 ...
- 121
0
votes
1
answer
44
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 ...
- 945
0
votes
2
answers
16
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 ...
- 101
0
votes
1
answer
32
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 ...
- 103
-1
votes
1
answer
81
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 [...
- 15.6k
0
votes
1
answer
75
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 ...
- 193
1
vote
2
answers
114
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 ...
- 291
0
votes
1
answer
26
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?
- 257
0
votes
1
answer
34
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 ...
- 261
0
votes
1
answer
78
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 ...
- 115
0
votes
0
answers
41
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 ...
- 35
2
votes
0
answers
56
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 ...
- 121
0
votes
1
answer
49
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 ...
- 185
0
votes
1
answer
229
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 ...
- 193
2
votes
1
answer
93
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 ...
- 461
16
votes
2
answers
2k
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 ...
- 42.5k
0
votes
1
answer
450
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, ...
- 121
1
vote
1
answer
2k
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 ...
- 224
1
vote
2
answers
95
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 ...
- 23
0
votes
0
answers
28
views
phpMyAdmin reports several issues for MySQL server
When checking what advices phpMyAdmin is giving me there are several issues it is reporting to me:
Opened table rate: 2.94 per minute, this value should be less than 10 per hour
It is suggesting me ...
- 21
0
votes
0
answers
30
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 ...
- 103
0
votes
1
answer
444
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 ...
- 15.6k
-1
votes
1
answer
1k
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 ...
- 13
1
vote
1
answer
60
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',
...
- 27
0
votes
0
answers
247
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 ...
- 3
1
vote
1
answer
155
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/...
- 13
2
votes
1
answer
338
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 ...
- 15.6k
0
votes
0
answers
63
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 - ...
- 421
0
votes
1
answer
2k
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 ...
- 101
0
votes
1
answer
49
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....
- 173
1
vote
0
answers
93
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?
1
vote
2
answers
461
views
stored procedure runs fine in all sessions but one
There are procedures that run fine manually but not in a job, or fails when run from an application, or not work in SSIS SQL task
Mine works in all sessions but one.
this is the code I am running - it ...
- 15.6k
2
votes
1
answer
3k
views
SQL Server timeout on DB and into connection string
Recently i have discovered (i have to premit i am not a DBA) that there is the possibility to configure a timeout into SQL Serve property (which apply to all DB into the SQL Server instance) :
...
- 351
1
vote
0
answers
188
views
mariaDB 10.2: sql mode has changed
The Upgrading from MariaDB 10.1 to MariaDB 10.2 states:
SQL_MODE has been changed; in particular, NOT NULL fields with no
default will no longer fall back to a dummy value for inserts which do
not ...
- 151
2
votes
0
answers
204
views
mysql stopped working after no free space on file system [corruption]
I am experiencing the following error when launching MySQL.
can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket '/var/...
- 21
1
vote
1
answer
6k
views
Change SQL Server 2019 instance Collation After installation, and new problem
How to made this problem on SQL Server 2019
Install SQL Server with wrong collation 2month ago
Revived a report from SharePoint admin about has a problem with collation
Resolve problem with MSSQLTIPs ...
- 216
0
votes
1
answer
458
views
Postgres autovacuum keeps transaction id's around to 10% limit, causing aggressive vacuuming to trigger now and then which locks tables
We run multiple Postgres clusters in our infrastructure with 10-30 DB per cluster, ranging from 10 GB size to 1TB in size. I have recently noticed that on all our clusters the wraparound id is always ...
- 1
0
votes
1
answer
449
views
How to query for Amazon RDS instance configuration?
From within a plpgsql script run on an Amazon RDS Postgres instance, is it possible to get information about instance configuration? How do I retrieve the DB instance ID, ARN (Amazon Resouce Name) or ...
0
votes
1
answer
94
views
How to change default compression mode in mariaDB Columnstore?
In mariaDB there is a way to disable columnstore compression in session level (and set the disable flag in each session). Is there any way to change the default compression mode?
- 1
4
votes
3
answers
3k
views
Command to validate a postgresql configuration file?
I am generating postgresql configuration files via ansible, and putting them in /etc/postgresql/XX/main/conf.d/whatever.conf. I accidentally made a syntax error and broke my postgresql, requiring ...
- 827
0
votes
1
answer
335
views
possible to show maximum query text in trino?
We have some queries that are hundreds or thousands of lines long that create a QUERY_TEXT_TOO_LARGE error. Is there a query I can run to show the maximum query text length in Trino/hdfs? I couldn't ...
- 244
0
votes
2
answers
517
views
How to create a custom database with 32k block size via DBCA silent mode?
I am trying to create an Oracle 19c single instance (warehouse) with dbca silent mode. The problem is, when I try the command below, it gets a warning: "Ora-0058: DB_BLOCK_SIZE must be 8192 to ...
- 123
1
vote
1
answer
480
views
After a database upgrade from MariaDB 10.1 to 10.6 new ODBC connections are returning wrong values [closed]
I had a total meltdown after installing "Feature update to Windows 10, version 21H2". A month into this I am now suspect that somehow this update reconfigured the way user System is handled. ...
- 133
1
vote
1
answer
752
views
Postgres initdb with custom timezone directory
How can I run Postgres initdb with a custom timezone folder?
I've tried to use the -L flag and PGSHAREDIR env var to control where initdb searches for Postgres share data. However, those options don't ...
- 179
1
vote
1
answer
927
views
Temp files and work_mem
My Postgres instance is logging things like this:
2021-11-16 22:18:52.491 UTC [1808765]: [3-1] db=xxx,user=xxx LOG: temporary file: path "base/pgsql_tmp/pgsql_tmp1808765.0", size 262144
My ...
-2
votes
1
answer
113
views
How to recover from setting maximum server memory too low? [closed]
On SQL Server 2019, it is possible to configure the server for a smaller than minimum amount of memory (in my case, 100mb). After doing this, the server crashes on startup. Some other forums pointed ...
0
votes
2
answers
194
views
MySQL configuration. Query doesnt get returned result (DataGrip, DBeaver, PHP). Something times out [closed]
I am running a simple INSERT INTO ... SELECT ... ON DUPLICATE KEY UPDATE ... query using either DataGrip or DBeaver or PHP and it always doesnt register the result.
The SELECT inside takes about 10 ...
- 101
1
vote
0
answers
157
views
PostgreSQL 11 - Tuning of the background writer process (maxwritten_clean)
I notice that the metric maxwritten_clean in the table pg_stat_bgwriter increases (for example going from 0 to 1000 in several seconds). I guess this is understandable as it happens while there are ...
- 97
0
votes
1
answer
389
views
pg_settings.statement_timeout changing constantly between 0 and 30000?
When I run the following query constantly every few seconds over a 30 second time period, I sometimes get a value of 0 and other times a value of 30000.
The value changes constantly and I don't know ...
- 3
0
votes
1
answer
464
views
MariaDB on Ubuntu mysteriously goes away after 15 minutes [closed]
I have an issue I've never seen before...my MariaDB goes away after 1800 seconds, despite having the default configuration for wait_timeout of 28800 seconds.
I checked all my my.cnf files, and there ...
- 641