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.

Filter by
Sorted by
Tagged with
2 votes
1 answer
53 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 ...
  • 340
0 votes
0 answers
14 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
20 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). ...
0 votes
1 answer
27 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 ...
1 vote
0 answers
52 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 ...
0 votes
0 answers
27 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 ...
  • 515
-1 votes
2 answers
18 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
57 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
72 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 ...
  • 515
0 votes
1 answer
80 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
1 answer
287 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 ...
0 votes
1 answer
54 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,333
0 votes
1 answer
84 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 ...
0 votes
0 answers
33 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 ...
0 votes
2 answers
49 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,007
0 votes
0 answers
49 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 ...
1 vote
1 answer
193 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-...
0 votes
0 answers
84 views

How do you copy the permissions of a certificate to another certificate using Powershell?

How do you copy the permissions of a certificate to another certificate using Powershell? I added a certificate through a pfx file and the new certificate doesn't have the same permissions as the old ...
0 votes
0 answers
50 views

Assigning access group to SSL certificate for MSSQL db on Windows

Inside The permission wizard I opened from the certificate snap-in, I see this: Group Allow MSSQLSERVER Full Control None However, I don't see it for my other certificate, which I just created. When ...
0 votes
0 answers
337 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
63 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
77 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,156
0 votes
2 answers
408 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 ...
0 votes
1 answer
174 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 ...
0 votes
0 answers
20 views

SqlError: (conn=46, no: 1045, SQLState: 28000) Access denied for user 'Raccoon'@'localhost' (using password: NO)

Im trying to set up one of mariadb's sample application, which is orders(https://github.com/mariadb-corporation/dev-example-orders). When starting the back end part it always shows " SqlError: (...
2 votes
2 answers
746 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 ...
  • 153
2 votes
1 answer
439 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
45 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://...
0 votes
1 answer
95 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
147 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
's user avatar
0 votes
1 answer
1k 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
0 votes
0 answers
66 views

rotate error log file of MySQL 8.0 server over windows

we have MySQL 8.0 installed over windows and my err log file (.err) is very large (11 GB), so we need to rotate the error loge so it writes to a new file when the current file is 200 MB we tried to ...
's user avatar
3 votes
1 answer
293 views

Why putting SQL Agent offline caused WSFC to fail over on passive node?

I have 2 node Windows Failover Cluster with Quorum disk. SQL agent is NOT a resource of the cluster. I needed to enable service broker on the server; for that I need to set SQL Agent offline, run tsql ...
  • 637
0 votes
1 answer
1k views

Why can't I use command \i on psql? It says no such file or directory [closed]

I am trying to use command \i 'C:\Users\Public\person.sql'; on windows on psql. And it says C:UsersPublicperson.sql: No such file or directory Although file does exist. I tried to relocate file on ...
0 votes
1 answer
204 views

How to run postgres in-memory on windows and sync to FS when a temer runs out?

So Progress is slow for me (in terms of query and update times) on SSD and it is ok in my case: I use it as a mix of Graph database + Table processor + NoSQL JSON trees so lots of loops, graphs, trees,...
  • 75
0 votes
0 answers
981 views

Oracle 19c listener stops on connection TNS-12541 error

I have just installed Oracle 19c Standard Edition 2 on Windows 10 and created a local database. I can connect to it with sqlplus / sysdba, but if I try to connect with sqlplus user/password@host:port, ...
0 votes
1 answer
431 views

How to Prevent High MariaDB Memory Usage on Windows

I am running MariaDB 10.5 and I am having trouble with it using too much memory on my Windows 10 machine. I have 16GB of RAM, and MariaDB ends up using around 8GB. SHOW VARIABLES; https://pastebin.com/...
  • 1
0 votes
0 answers
40 views

Is there a way to purge a DTC transaction from command line?

as you can see on my screenshot, I have a DTC transaction in error on my server. I know, I can Right -> Resolve -> Forget/Abort However, I want to do it with a command line (batch or Powershell)....
1 vote
1 answer
123 views

Mysql (win) Is it possible to get databases from multiple drives in the same time?

My question would be, is there any way to read the mysql data folder from different drives in the same time (Windows) ? For example: I have 1TB database from the drive C:, and another 1TB from the ...
-1 votes
1 answer
40 views

Best Database to be shipped with my application? [closed]

I have a .NET core application using a database. I need to create an installer using NSIS where I will be packaging my application along with a database, so that the client can easily install my ...
  • 99
0 votes
1 answer
75 views

How to configure account to be able to create/delete folders and files?

I have a newly created domain account (domainname\user1). This will be used by SQL server agent job proxy credential to run a SSIS package that creates/deletes files and folders on the same computer ...
  • 2,800
1 vote
2 answers
91 views

Why does linked server need delegation where as file access require no delegation settings?

I have a ssis package deployed to ssis catalog in ServerA. It is configured to be run via sql agent job step. The job step is set to Run As proxy user that is pointing to a domain user credential. ...
  • 2,800
-1 votes
1 answer
318 views

Linux PostgreSQL mount data from external ntfs disk [closed]

I have similar problem as here: Postgres tablespace on mounted usb I want to have access to my DB on external hard drive from Raspbian and Windows 10. Not simultaneously. I just want cross-platform DB ...
  • 1
1 vote
1 answer
1k views

Upgrading Postgres 12 to 13: 'pg_upgrade.exe' fails

I'm attempting to upgrade a Postgres instance from version 12 to version 13, following the steps outlined at https://www.postgresql.org/docs/13/pgupgrade.html. From an elevated command prompt, I'm ...
  • 187
0 votes
1 answer
10k views

The pgAdmin 4 server could not be contacted

Whenever I install PostgreSQL, it stops working after about 6 months. This is the second time this happened! Last time this happened, I uninstalled and then installed version 4.29. How can I debug ...
  • 2,007
1 vote
1 answer
297 views

Kerberos Issue - Anonymous Login

I have a linked server that connects one SQL Server to another SQL Server. For two weeks now there has been an error when testing the connection; Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. ...
0 votes
0 answers
352 views

MariaDB starts from cmd prompt but not as service

Attempting to start MariaDB as a service results in an error that says: Windows could not start the MariaDB service on Local Computer Error 1053: The service did not respond to the start or control ...
  • 383
0 votes
1 answer
142 views

Cannot find sqlserver service

I installed Sql Server 2019 in Windows PC. In Sql Server Configuration Manager into SQL Server Service I stopped all the instances. But still I can loggin to Sql Server via SSMS.why is that? Where is ...
0 votes
1 answer
109 views

Powershell script while executing mysqldump script

I'm having an error 1045: Access denied for user 'mysqlsuperuser'@'test.internal.cloudapp.net' (using password: YES) when trying to connect Here is the mysqldump command on my ps1 file. $command = [...
  • 59
0 votes
3 answers
137 views

Postgres psql requires " FROM database.table" in sql statement [duplicate]

As a beginning learner of of Postgres I have created two different installations of a database where one requires a select statement to use ...FROM database.table... and the other only requires ......
  • 135

1
2 3 4 5
13