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
0 votes
0 answers
34 views

ORA-12541: TNS:no listener error when trying to login through WSL to access OracleXE Database

System Details WSL2 Ubuntu Oracle Instant Client (Inside of WSL) OracleXE (Inside of Windows) I followed the instructions guide from the Oracle Documentation, added the path to the TNS_ADMIN, ...
giovanni's user avatar
0 votes
0 answers
93 views

How can I check the current memory management mode for an oracle database instance?

I have a vendor requesting that Automatic Shared Memory Management (ASMM) is configured to a certain threshold for an existing oracle database (version 19c) hosted on a windows box. As usual Oracle ...
Eric Swiggum's user avatar
0 votes
0 answers
41 views

copying data from database with the same skeleton

I have a database design with the same tables, procedures and all other details on two different servers. Since one of them ran out of traffic, I forwarded the web software project to the other one. I ...
Kadir Çolak's user avatar
0 votes
0 answers
21 views

DB2 SQL1052N createing a database

SQL1052N is path not found when running CREATE DATABASE.... But I get this every time I specify a path in the statement, even when the path is there and is created by the same user. The path exists ...
teknopaul's user avatar
  • 101
0 votes
1 answer
30 views

Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right

Can automatic failover occur to a DR node on a different data center if synchronous commit is enabled and other conditions are right. I'm asking because we had a two node scenario where a primary node ...
Tichaona Masanga's user avatar
0 votes
0 answers
123 views

Cannot cannot to database using sql developer: a connection attempt failed because the connected party did not properly respond after a period

I am using a windows laptop and installed sql developer version 23.1.0. When I input the connection details for my database I get the following error: a connection attempt failed because the ...
What is in a name's user avatar
1 vote
1 answer
29 views

How can I get PostgreSQL to follow up filtering jobs that my FDW ignored?

I'm making a FDW (Foreign Data Wrapper) in PostgreSQL for myself using C. It seems to be working rudimentary, but I have one problem. When I pass it a query like the following via psql: select * from ...
yasoo7964's user avatar
0 votes
1 answer
143 views

Availability group issues - databases not synchronising

I am hoping someone may be able to offer some assistance with an issue that I do not seem to be able to work around. We have 2 on-premise SQL Server 2019 machines in an always on availability group. ...
AngryDog's user avatar
0 votes
1 answer
185 views

Confusion on SQL Server domain\username after Windows changing hostname

We have a SQL Server 2016 running on a virtual machine of Windows 2016. Previously, the virtual machine's hostname was WIN when we installed the SQL Server, so the database engine's server name was ...
James's user avatar
  • 149
0 votes
1 answer
147 views

Got an error when trying to get ER-diagram on SQL Server

We are using Microsoft SQL Server 2016 Management Studio (version 13.0.16106.4) connecting to an instance of SQL Server 2016 running on Windows 2016. The authentication is "SQL Server ...
James's user avatar
  • 149
0 votes
0 answers
37 views

Mongo 3.4 to 3.6

How to upgrade 3.4 mongo to 3.6 mongo. I don't have config file while starting mongodb in 3.4 how to have it in windows locally.
Elango Van's user avatar
0 votes
0 answers
53 views

My SSMS does't see the directory with db files

I did nothing and my SSMS does not see db directories with files. When I'm trying attach db ssmms can't find this way. But when I create db the files put there As I understood there is the problem ...
Andrei Yankavets's user avatar
0 votes
1 answer
128 views

MariaDB Power Outage Issue

We have a desktop application on Windows OS that installs with MariaDB server 10.4.10. Sometimes the client loses power and after restarting of PC MariaDB database becomes corrupted and Windows Server ...
WhoKnows's user avatar
  • 103
0 votes
1 answer
1k views

Unable to remote connect to windows 10 Postgresql

Context I have an old laptop I'd like to host a database on to serve a MEVN stack hosted on AWS. That MEVN stack currently does use Mongo, the goal is to transition to a local (my laptop) Postgresql ...
Ryan's user avatar
  • 1
1 vote
0 answers
236 views

pg_ctl on windows: keep running when closing cmd prompt

Is there a way to start postgresql with pg_ctl in a windows command prompt and keep the server running after closing the command prompt? Note: installed via conda, limited privs eg. running as a ...
beginner_'s user avatar
  • 213
0 votes
2 answers
396 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 ...
supmethods's user avatar
1 vote
1 answer
447 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 ...
Rafael Chielle's user avatar
0 votes
1 answer
129 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 ...
sqltracy's user avatar
0 votes
0 answers
49 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 ...
mrxaxen's user avatar
-2 votes
1 answer
315 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 ...
LOSTinDB's user avatar
  • 551
1 vote
0 answers
181 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":"...
JRA's user avatar
  • 139
0 votes
2 answers
271 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 ...
ConanTheGerbil's user avatar
1 vote
0 answers
232 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 ...
ConanTheGerbil's user avatar
0 votes
0 answers
84 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 ...
Michał Lipok's user avatar
0 votes
0 answers
192 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 ...
Roman DotNetDev's user avatar
0 votes
0 answers
373 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 ...
socaljoker's user avatar
0 votes
0 answers
149 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 ...
Roman DotNetDev's user avatar
0 votes
0 answers
74 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 ...
Roman DotNetDev's user avatar
2 votes
1 answer
12k 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 ...
JuliousGonsalves's user avatar
0 votes
1 answer
423 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(`...
LOSTinDB's user avatar
  • 551
-1 votes
1 answer
133 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....
dtc348's user avatar
  • 101
-2 votes
1 answer
109 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 ...
user avatar
1 vote
1 answer
1k 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 ...
valepu's user avatar
  • 111
3 votes
1 answer
2k 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 ...
Kris's user avatar
  • 422
0 votes
0 answers
460 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 ...
Kostya GL's user avatar
0 votes
1 answer
382 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). ...
LetMeSOThat4U's user avatar
0 votes
1 answer
619 views

PostgreSQL data corruption tools?

Are there any techniques/tools/methodologies for investigating row level corruption within a PostgreSQL table? Most proposed solutions on this forum boil down to: try doing a VACUUM FULL to rebuild ...
ConanTheGerbil's user avatar
1 vote
0 answers
875 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 ...
ConanTheGerbil's user avatar
0 votes
0 answers
134 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 ...
Dave's user avatar
  • 693
0 votes
1 answer
3k 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 ...
Dave's user avatar
  • 693
0 votes
1 answer
2k 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 ...
Richard T's user avatar
  • 219
1 vote
2 answers
6k 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 ...
Francesco Mantovani's user avatar
0 votes
1 answer
430 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 ...
Stephan's user avatar
  • 1,463
0 votes
1 answer
680 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 ...
FlexMcMurphy's user avatar
0 votes
2 answers
277 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 ...
SQL_NoExpert's user avatar
  • 1,049
1 vote
1 answer
1k 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-...
ConanTheGerbil's user avatar
0 votes
0 answers
713 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 ...
TitanOfDimension's user avatar
0 votes
2 answers
296 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 ...
Oky's user avatar
  • 1
0 votes
1 answer
717 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 ...
Racer SQL's user avatar
  • 7,386
0 votes
2 answers
2k 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 ...
Hmkyriacou's user avatar

1
2 3 4 5
14