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
18 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 ...
  • 188
1 vote
2 answers
46 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
11 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 ...
  • 1
0 votes
0 answers
24 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
28 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 ...
-1 votes
1 answer
178 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 ...
1 vote
1 answer
18 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
43 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
36 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
297 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 ...
0 votes
0 answers
43 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 - ...
0 votes
1 answer
334 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 ...
0 votes
1 answer
24 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....
0 votes
0 answers
34 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
103 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 ...
2 votes
1 answer
1k 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) : ...
  • 287
0 votes
0 answers
13 views

Is it possible to automate importing vssettings in SSMS?

I have a few settings which I distribute to students as a .vssettings file to be imported into SSMS. Importing the file isn’t too difficult, but I wondered whether it is possible to somehow automate ...
  • 2,377
1 vote
0 answers
97 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
41 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
2k 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 ...
0 votes
1 answer
156 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 ...
0 votes
1 answer
133 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
55 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?
3 votes
2 answers
818 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 ...
0 votes
1 answer
116 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 ...
  • 234
0 votes
1 answer
230 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 ...
1 vote
1 answer
233 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
329 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 ...
  • 149
1 vote
1 answer
293 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
66 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
96 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 ...
1 vote
0 answers
84 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 ...
0 votes
1 answer
151 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 ...
0 votes
1 answer
237 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 ...
0 votes
1 answer
31 views

MySql Important Linux System Configuration [closed]

Last month I'm trying to find a "formula" for optimal Linux system configuration for MySql installation. But I didn't find anything related in those fields: Should I disable swapping ? ...
0 votes
2 answers
258 views

changing SSMS settings via Powershell

in order to enable the dark theme to SSMS (not available on the picture below as you see): following this webpage: SQL SERVER Management Studio 18 - Enable Dark Theme - SQL Authority with Pinal Dave ...
0 votes
1 answer
87 views

Should I change parallelism (MaxDop and Threshold)?

Seems like I have problems with parallelism because largest wait types are CXCONSUMER and CXPACKET. Server has 8 cores. So I am planning to bump up Cost Threshold to 50 and MaxDop to 4 Currently I ...
  • 637
0 votes
1 answer
67 views

Storage configuration for faster queries [closed]

Please advise on setting up storage allocation for a new SQL Server 2019 machine. Ryzen 7 8Core with 64GB Ram 4 local drives (2TBNVMe PCIe4 + 1TBNVMe PCIe3 + 2TBSSD + 4TBHDD) I am going to allocate ...
0 votes
1 answer
167 views

What is the proper configuration for max open connection, max idle connection and max connection life postgreSQL?

We have an app that serves small to moderate kinds of traffic. our server spec: 6 node of micro/small aws ec2 for client 1 db.r5.2xlarge for writer 1 db.r5.large for reader our app/client setting: ...
  • 1
0 votes
1 answer
448 views

MongoDB: F CONTROL [main] Failed global initialization: FileNotOpen: Failed to open "/data1/mongodb/log/mongod.log"

I am trying to install mongodb 3.4 on Redhat 7.9. When I start mongodb systemctl start mongod I get the below error FileNotOpen: Failed to open "/data1/mongodb/log/mongod.log, But when I start ...
  • 101
0 votes
5 answers
201 views

mysqld process performance [closed]

I'm running in problems that I can't solve by myself. Mysqld process go over 100%, sometimes over 500% in web peaks. Idk why mysql running only one process, websites works fast without any problem ...
0 votes
1 answer
150 views

How can the size of the notification queue be configured?

The documentation for NOTIFY states The queue is quite large (8GB in a standard installation) and should be sufficiently sized for almost every use case Is it possible to configure the size of the ...
0 votes
1 answer
68 views

Configure listen_addresses automatically in custom installation

I have included Postgres in a custom installer for a Windows application. I do not use the installer binary, but extract the Postgres zip archive for installation and then run initdb from a batch ...
  • 111
0 votes
0 answers
238 views

PostgreSQL remote connection failing

I've recently installed PostgreSQL on my PC as a requirement for my DB class, and as a practice, I decided to try and setup a remote connection for it so I can access it via online services. But after ...
6 votes
2 answers
6k views

How to set statement timeout per user?

I have multiple users in Postgres. I would like to set up different statement timeouts for different users. Eg: Guest 5 minutes and Admin 10 minutes. Is it possible in Postgres 11.11?
4 votes
0 answers
701 views

SQL Server Network Packet Size

During the analysis of network traffic from Citrix clients to our database server, we noticed that we had a lot of RETRANSMITs occurring during the transport of TCP packets. The packets were being ...
  • 15.5k
0 votes
1 answer
244 views

IP Addresses tab is not showing a specific IP Address

I have SQL SERVER 2008 R2 installed on windows Server 2016, it runs smoothly on a LAN network interface. I Added a USB MODEM (4G) to the server and went to the IP Addresses tab in network ...
0 votes
1 answer
213 views

Why turning off condition_fanout_filter speed up query

bin/mysqld_safe --user=mysql --optimizer-switch=condition_fanout_filter=off --innodb-flush-method=O_DIRECT & Query (from TPC-H query-19): SELECT Sum(l_extendedprice * ( 1 - l_discount )) AS ...
  • 93
0 votes
0 answers
88 views

My Mongos can't authenticate to my replica set

I have 3 config servers in a replica set and when I use the command: sudo mongos --configdb crs/the 3 config servers:port# --keyfile "Keyfile", I keep getting this error: [mongosMain] Unable ...
0 votes
2 answers
3k views

mysql: [ERROR] unknown variable 'default-authentication-plugin=mysql_native_password' [closed]

When I installed MySQL 8.0, I selected sha256 password authentication method instead of legacy, When I tried to return to native password authentication it shows an error message: mysql: [ERROR] ...

1
2 3 4 5
14