Questions tagged [database-administration]
Questions about how to install, configure or tune the configuration of any database package.
82
questions
2
votes
1
answer
2k
views
MariaDB: Should I configure the db-server using "/etc/my.cnf" or a file in "/etc/my.cnf.d"?
I am trying to configure MariaDB on a machine with Fedora 37: Workstation as its operating system.
I expected to use /etc/my.cnf to configure the ports and such, however, the file contained an include ...
2
votes
1
answer
4k
views
Is there any way to export MySQL Workbench 8 connections by shell commands?
I need to add some shell commands to my backup script to take a backup of defined MySQL connections in the Workbench.
MySQL workbench allows this in its GUI: menu bar > Tools > Configuration >...
1
vote
3
answers
6k
views
How to downgrade MS SQL Server 2019 Enterprise (evaluation) to Standard (purchased)?
SQL Server 2019 was installed in evaluation edition. When entering the activation code for a purchased copy of Standard edition I received the following message:
I entered the activation code that is ...
0
votes
1
answer
893
views
Physical to Virtual Migration using Disk2vhd utility
We are currently in plan of migrating physical to virtual servers for both DB & App servers. Currently we are with SQL Server 2014 AOAG System. Databases are FileStream enabled. Currently we have ...
0
votes
1
answer
94
views
MDSplus configuration: How to Change the Start Shot Number in an MDSplus tree?
When creating a new MDSplus tree, it's possible (or perhaps even required) to specify the smallest shot number for which data can be stored in the tree. Shot numbers are just index values identifying ...
2
votes
1
answer
334
views
Database Reverse engineering wizard Fails
I am using Visio 2019, trying to reverse engineer a Azure SQL server. I have successfully created multiple User data sources to use in the wizard using both our DB-admin user and my admin azure ...
0
votes
1
answer
144
views
SQL Server file is in Is_media_read_only mode and can't apply TDE as a result
We have a database that we restored to a server and have been read/writing to that database for quite some time. We are now trying to apply TDE to that database and it will not allow us because it ...
0
votes
1
answer
367
views
MariaDB slave replication stopped after slave upgrade to 10.1.41
After the recent MariaDB 10.1.41 update which happened on 01/Aug/2019, few of our slaves have stopped syncing relay logs from master which is on 10.1.40. Slaves which got automatically updated to 10.1....
0
votes
1
answer
40
views
Link two fields in one table to one field in a second table, and create qry in Access
I am not sure if this is possible to do in Access; I have been googling forums and have not found a solution yet that works...
Essentially there are a list of patients who provide multiple blood ...
0
votes
1
answer
851
views
MS Access form doesn't reflect recent data updates in Split Database's FrontEnd Forms
I have a front end and a backend to my access database. The VBA code, forms, queries etc are on the frontend and tables on the backend. The backend is on a server, about 5 different users are using ...
1
vote
1
answer
7k
views
PostgreSQL getting error during pg_restore using pgadmin pg_restore: [archiver (db)] could not execute query: ERROR: role does not exist
I am trying to restore a database from one schema to another schema in PostgreSQL using pgadmin backup and restore utility.
The backup is successful for the database A but when I try to do the restore ...
0
votes
0
answers
159
views
Can you store encrypted passwords in ConnectWise Manage or will they always be plain text?
Title pretty much says it all. I need to store passwords for devices and configurations but I want them to be stored securely and encrypted. Can this be done with ConnectWise Manage?
1
vote
0
answers
84
views
How to connect to a PostgreSQL database?
I have a website written in Python / Django, and it is functioning well on a CentOS server (I wasn't one who set it up though). Now I want to set this website up locally on my Mac OS X or Linux system ...
0
votes
1
answer
496
views
postgresql does no restart after changing postgres.conf or pg_hba.conf. This incident happened while i was trying to setup the postgresql BDR
I am not able to login to postgresql after restarting postgresql DB after configuring pg_hba.conf and postgresql.conf file. The snapshot of the error is attached for referral postgresql.conf / pg_hba....
0
votes
1
answer
431
views
Removing cluster node from always on cluster
I have an alwaysOn configuration for SqlServer 2012 that is installed in two node windows cluster.
We had a disk failure on the second node, and there is no way to recover it, so I should run a new ...