Skip to main content

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
1 answer
37 views

Why does moving a postgres table from one tablespace to another take so long

Why does moving a postgres table from one tablespace to another take so long (and how can I speed it up) I have a postgres database with two main tablespaces, one on a SDD, the other on magnetic HDD. ...
ConanTheGerbil's user avatar
0 votes
1 answer
30 views

how to move a postgres tablespace on windows?

Now do I move a tablespace on a windows installation of postgres? This thread shows how to do it on unix, not windows. The tablespace was originally created with this command... CREATE TABLESPACE ...
ConanTheGerbil's user avatar
0 votes
1 answer
25 views

How do I restore a PostgreSQL/TimescaleDB pg_basebackup tar on Windows? postgresql-x64-15 immediately stops on start

I'm going thru the various online processes to expand the pg_basebackup tar file into the C:\Program Files\PostgreSQL\15\data, such as Restore data from tar file for unix, but when restoring on ...
Scott's user avatar
  • 101
1 vote
1 answer
33 views

Recovered database files, need to be rebuilt using a new SQL server instance [closed]

Need some help in recreating a recovered database. We recently recovered an old disk drive that has the following folders on it: Program Files\Microsoft SQL Server\MSSQL... Program Files(x86)\...
Patrick's user avatar
  • 11
0 votes
0 answers
63 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
389 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
43 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
29 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
33 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
238 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
31 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
191 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
268 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
215 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
40 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
68 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
150 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
298 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
  • 223
0 votes
2 answers
507 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
524 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
146 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
60 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
408 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
191 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
  • 149
0 votes
2 answers
289 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
258 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
89 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
227 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
415 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
158 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
14k 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
473 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
150 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
117 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
  • 432
0 votes
0 answers
498 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
456 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
861 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
1k 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
141 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
  • 723
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
  • 723
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
458 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,483
0 votes
1 answer
777 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
294 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,061
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

1
2 3 4 5
14