Questions tagged [windows]
Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.
653
questions
0
votes
1
answer
14
views
Memory usage for MySQL
I have created the following procedure:
CREATE DATABASE memory
USE memory
DELIMITER $$
DROP PROCEDURE IF EXISTS `my_memory` $$
CREATE PROCEDURE `my_memory` ()
BEGIN
DECLARE var LONGTEXT;
DECLARE ...
- 121
-1
votes
0
answers
14
views
Windows Admin Center (WAC) Port Forwarding for Remote Usage [closed]
I've installed the Windows Admin Center (WAC) at a Server 2022 Hyper-V VM at Port 443. It is a fresh server installation without any additional features. I'm able to access the WAC from anywhere in my ...
- 1
0
votes
1
answer
118
views
PostgreSQL uses huge amount of memory
When executing a query containing WITH and more than a thousand UNION ALL, PostgreSQL version 14 or higher uses all server memory until it enters recovery mode. In tests with version 11, this behavior ...
0
votes
1
answer
33
views
Oracle for Windows: how do I create a new user and login with it?
I can connect as sysdba and with the system user, but I am unable to create a new user and connect with it. This is a new Oracle install straight out of the box 19;
enter image description here
...
- 1
0
votes
0
answers
24
views
connect to MySql installed in WSL from nodeJS
I installed MySQL in Windows WSL. I created a user & DB with
CREATE USER admin@localhost IDENTIFIED BY 'admin';
GRANT ALL ON *.* TO admin@localhost;
CREATE DATABASE test;
From command line I can ...
- 1
0
votes
0
answers
20
views
pg_dump significant size difference between dumps
So we've been doing some temporary backups on windows machines and came across something interesting.
Doing plain formatted dumps with no compression and blobs,
we get significant size differences ...
- 1
-2
votes
1
answer
60
views
Mysql - Fields in views and tables being cut off at a character limit for varchar?
I have tables where I am running views off of. Anything with over varchar(255) get automatically cut off in a view.
I even created a query to create a table using AS SELECT (that was a view) with ...
- 541
1
vote
0
answers
47
views
How to use mongoexport with a dynamic variable for date on windows batch file?
Here is my working script:
mongoexport --db db1 --collection Transaction --out C:\Users\Admin\transactionstats.json --query="{"PaymentDate":{"$gte":{"$date":"...
- 79
0
votes
0
answers
25
views
How to accomplish this kind of basic "local replication" in PostgreSQL 14 on Windows 10?
I start (and restart) PostgreSQL like this:
pg_ctl restart -D "C:\Users\John Doe\Documents\PGDB"
I am trying to also start three "replication PostgreSQL servers" on the same ...
0
votes
2
answers
94
views
Postgres - how to work out which tablespace is short of space?
I'm trying to add a INTEGER DEFAULT 0 field to a very large (partitioned) table spread across two tablespaces.
Each tablespace is on a different disc (one on C drive, the other on D). I get the ...
- 983
0
votes
0
answers
69
views
How to direct psql errors to powershell log file?
I'm running a powershell script on a windows system. The script includes psql commands to run SQL on a postgres database.
Most stuff gets correctly recorded in the powershell log file, EXCEPT for psql ...
- 983
0
votes
0
answers
20
views
Hidden Windows registry entry when trying to patch SQLLocalDb anomaly
This question follows one asked and answered here :
Can't connect to SQL Server 2017 Local DB shared instance
I have a .Net Framework / C# project where a SQLLocalDB instance is created by a ...
0
votes
0
answers
52
views
Linux PostgreSQL 9.4 to Windows PostgreSQL 13
I had to switch from PostgreSQL 9.4 on Linux to PostgreSQL 13 on Windows
Normal restore was not successful.
Can somebody share experience with such case?
EDIT 1:
On linux I use:
pg_dump -c -O -U ...
- 117
0
votes
0
answers
48
views
Connection String requires AttachDbFilename property
I'm trying to use SQL Server LocalDb to store the database by connection string. During first connection to the database I have an error about connecting to the database. In SSMS it is opening. To fix ...
0
votes
0
answers
85
views
SQL Server Install/Uninstall Freezes
I'm running Windows Server 2019 Standard. All Windows updates have been installed. Chckdsk, sfc, and dism have been run and found no problems. Server has been restarted.
I'm trying to uninstall some ...
- 101
0
votes
0
answers
80
views
Windows server localdb issue
I'm trying to deploy a database to a Windows Server machine.
The database is a SQL Server LocalDB. When I deploy it to a Windows machine, everything works correctly. When I try to deploy the same ...
0
votes
0
answers
67
views
Create logins for all active directories groups named ("Domain Users"), related to current Windows Authenticated user in SQL Server
I need to get all active directories locations, related to current machine, by SQL script to create logins for them. Is there a way to perform that? For now I wrote such procedure:
USE [master]
GO
...
2
votes
1
answer
2k
views
The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server)
we have an issue connecting remotely to SQL Server via SSMS with Azure AD users. Any attempt to log in to a SQL Server instance in AWS with Windows Authentication throws an SSPI error. We've tried the ...
0
votes
1
answer
176
views
How to get rid of all whitespace in a mysql query?
SELECT
libary.MediaId,
library.Title,
library.`date-downloaded`,
library.Author,
library.`language`,
library.asseturl,
library.`recycle-bin`,
library.`key-asset`,
SUBSTRING_INDEX(SUBSTRING_INDEX(`...
- 541
-1
votes
1
answer
72
views
Does IntelliSense feature available in Data Studio?
Does IBM Data Studio have IntelliSense features or Intelligent code completion something
like below?
I would like to write an SQL query with IntelliSense type functionality.
I have IBM Data Studio 4.1....
- 101
-2
votes
1
answer
44
views
How much changing MySQL datadir from SSD Drive "C:/.." to HDD Drive "D:/.." will slow down the query processing speed?
I am working on my local device and have created a schema that makes drive "C:/" (SSD) nearly full (it took up nearly 60 GB from the available space), so I think I should move the data to ...
user262207
1
vote
1
answer
228
views
MySQL from backup won't start due to possibly corrupted data folder or permissions
A few days ago I was forced to format my PC due to an issue with a Windows update, I managed to make a backup first and now I'm trying to restore the files.
I have a mysql instance that I'm having ...
- 111
3
votes
1
answer
893
views
Install SQL Server 2016 SP2 on SP3 - Windows Updates says that?
Currently our server is on Microsoft SQL Server 2016 (SP3) (KB5003279) - 13.0.6300.2 (X64) Aug 7 2021 01:20:37 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server ...
- 362
0
votes
0
answers
195
views
Failed to open file '{dump.sql}', error: 13 Windows 10
I have installed XAMPP with PHP 7.2.23 and MySql v8 and want to import database dump on Windows 10
I used this commands in Command promt running by Administrator:
C:\xampp\mysql\bin\mysql -u root
...
0
votes
1
answer
86
views
Reliable way(s) of finding home directory of Sybase DB (ASE) on Linux and Windows
I need to write a script that finds Sybase installation on a system if there's any.
For testing I've installed ASE 16 on CentOS system, but the installer is apparently based on InstallAnywhere (Java).
...
- 473
0
votes
1
answer
100
views
Postgres data corruption tools?
Are there any techniques/tools/methodologies for investigating row level corruption within a postgres table?
Most proposed solutions on this forum boil down to 'try doing a VACUUM FULL to rebuild the ...
- 983
1
vote
0
answers
233
views
Root cause of Postgres database corruption
I've been suffering from occasional (but regular) database corruption recently. Errors like this.
compressed lz4 data is corrupt
and
Npgsql.NpgsqlException:
invalid page in block 1787279 of relation ...
- 983
0
votes
0
answers
70
views
How do I retain command history for psql running within PowerShell?
I'm running the following version of psql
psql (12.11)
on Windows Powershell running on Windows 10. Within the same shell session, when I log in and out of psql, it doesn't retain the previous ...
- 563
-1
votes
2
answers
43
views
Is it possible to save the password in .my.cnf or similiar on Windows for mysql?
Is it possible to save the password in .my.cnf or similiar on Windows for mysql?
0
votes
0
answers
208
views
PostgreSQL "The database cluster initialisation failed"
I followed the manual initialisation steps on my windows 11 laptop:
Command Prompt:
cd "C:\Program Files\PostgreSQL\12\bin"
initdb -D "D:\postgresqldata" -U postgres
pg_ctl start -...
- 1
0
votes
1
answer
1k
views
In Postgres 12, how do I set a default schema when logging in using psql?
I'm logging in to my Postgres 12 (running on Windows 10) db using an alias, which resolves to
PGPASSWORD=$DB_PASSWORD psql -U${DB_USER} $DB_NAME
I would like to find a way to tell Postgres which ...
- 563
0
votes
1
answer
969
views
postgres: could not access directory "C:/opt/PostgreSql/14/data": Permission denied
Importantly: This is on Windows 10 and Postgres 14 (for newbies, Postgres is also known as PostgreSQL), with Cygwin providing the CLI.
On a fully functional, up and running, and apparently perfectly ...
- 209
1
vote
2
answers
2k
views
Servicing Update for SQL Server 2019 RTM GDR (KB4517790) - Install error - 0x80070643
SQL Server is still working smoothly but I noticed that I have an alert on the Windows Update that says:
Servicing Update for SQL Server 2019 RTM GDR (KB4517790)
Install error - 0x80070643
I tried ...
- 1,314
0
votes
1
answer
213
views
How to change initdb own messages localization?
When I initialize a cluster the messages produced by initdb are in French.
I tried the following options :
--locale=en_US
--lc-messages=en_US
--no-locale
--locale=C
initdb messages still stay in ...
- 1,373
0
votes
1
answer
256
views
Most recent version of SQL Server Management Studio that works with Windows 7 pre SP1?
I am trying to do some work with SQL Server 2008 (not 2008 r2, just 2008) that is installed on a Windows 7 Pro 32-bit PC. It's just Windows 7 with no Service Pack 1 applied. I have no option to update ...
- 103
0
votes
0
answers
120
views
Can't view/create System DSN in windows 10 using ACEODBC.DLL
I need to create a system dsn to connect to a Microsoft access accdb for my fedex shipping station.
I can seemingly create a dsn and everything seems fine but then it doesn't show up in the list. And ...
- 13
0
votes
2
answers
111
views
Failing over to DR site Availability group
I have a 4 node cluster SQL 2012 availability group database with one witness server at the primary site. 3 nodes are in the primary site and one node in the DR site.
Due to maintenance at the Primary ...
- 1,019
0
votes
0
answers
147
views
Postgres execution times increase exponentially with data volume
I have a table that increases by several million record per day. Initially it's partitioned by day, but a couple of days after creation
each daily partition is merged into a monthly partition.
The ...
- 983
1
vote
1
answer
683
views
Postgresql connection timing-out too quickly
I'm running a powershell script on windows that connects to a postgres database.
Under normal conditions everything works fine, but I'm trying to make the system more robust, and make everything re-...
- 983
0
votes
0
answers
488
views
error installing PostgreSQL, Could not find registry key HKEY_LOCAL_MACHINE\
I've been trying install postgres, i try solutions related to WSH,
nothing works to me.
here's the log
Log started 01/19/2022 at 21:06:35
Preferred installation mode : qt
Trying to init installer in ...
0
votes
2
answers
129
views
3 Node WFCS - How to automatically FO to DR?
I am planning to implement a two-node Windows Server Failover Cluster (WSFC) for SQL Server Always On Availability Group in our main site, and the third node in our DR site.
All application clients ...
- 1
0
votes
1
answer
185
views
Does AOAG needs a Windows failover cluster?
I'm reading some windows docs about AOAG and I got confused:
Always On availability groups, the high availability and disaster recovery solution introduced in SQL Server 2012 (11.x), requires Windows ...
- 7,246
0
votes
2
answers
882
views
Start PostgreSQL from different data directory on windows
I set up PostgreSQL on my mac and I am trying to share the database files through GitHub to my Windows machine and other users.
I know how to start the PostgreSQL Service from a specific data ...
1
vote
1
answer
320
views
Any idea what Virtual Machine Cluster WMI is for?
We have a Windows Failover Cluster to host our SQL Server Availability Group.
We have a resource that popped up that no one recalls creating named "Virtual Machine Cluster WMI". We have ...
- 11
2
votes
2
answers
1k
views
pg_dump hangs in Git Bash but works in Windows command line
I tried to make a backup of a database from Git Bash environment, but the executable does not output anything.
If I specify the filename using the -f flag, a blank file gets created, so the executable ...
- 163
2
votes
1
answer
855
views
How do I identify the users on Oracle database who uses OS authentication?
I'm trying to audit the privileged users on Oracle Db and see there are users for whom the last login column appears to be blank, however, I'm aware that those user accounts are used for certain ...
0
votes
0
answers
61
views
What is the intended method for automatically/streamlinedly updating minor/patch PostgreSQL versions on Windows?
I currently run PostgreSQL 12.4 on Windows 10. Since the "BigSQL" distribution is no longer around, the only choice is to use the EnterpriseDB installer for the initial installation: https://...
- 267
0
votes
1
answer
233
views
MySQL 8 install doesn't include mysql.exe (Windows)
I've installed MySQL 8.0 using mysql-installer-community-8.0.26.0.msi. Mainly these options:
But there's no binaries for connecting (mysql.exe) or dumping (mysqldump.exe):
What else do I need to ...
- 101
0
votes
1
answer
308
views
how can resolve a cyclic redundancy check sql
i need to restore a database but i have a strong problem, please look the photo, is a strange error, please helpme
Jhona JM
0
votes
1
answer
2k
views
How can I create a mysql database (if it doesn't exist) or replace it (if it exists)?
My dump:
mysqldump --host=localhost --user=root --password=whatever --single-transaction --routines --triggers --log-error=error.txt --databases mydatabase > out.sql
My restore
mysql --host=...
- 157