Questions tagged [windows-10]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
178 views

What to do about "unable to write inside temp environment variable path" on Windows 10 for PostgreSQL

I get this error message when I try to install PostgreSQL on my Windows machine. I tried all the provided solutions for solving this issue. I have uninstalled my McAfee antivirus as I wasn't using it ...
Hamza Farooq's user avatar
0 votes
0 answers
136 views

MariaDB ODBC connector connects to all databases indiscriminately

This is connector 3.3.4 (64-bit). OS is W10. mariadb --version gives "mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for Win64 (AMD64), source revision ..." I wanted to set up an ODBC connector ...
mike rodent's user avatar
1 vote
0 answers
50 views

Postgres - now to optimise a table for high frequency INSERTs?

I need to load data into a table as fast as possible. So far I've done the following. Create the table UNLOGGED Removed all indexes Removed all triggers Created the table in a tablespace on a SSD ...
ConanTheGerbil's user avatar
1 vote
0 answers
486 views

SQL Server Management Studio compatible with Windows 10 32 bit

I'm running a VM with Windows 10 32 bit OS and I need to install SQL Server Management Studio. The OS on my VM OS Name: Microsoft Windows 10 Pro OS Version: 10.0.19044 ...
sergiom's user avatar
  • 159
0 votes
3 answers
364 views

Why PHPmyAdmin works on Windows 10 and not Windows 11?

I'm running Windows 11 and tried to install XAMPP on this machine. It installed Apache correctly, but when going to mySQL this appears: I tried everything I found online to fix this problem in order ...
Johann's user avatar
  • 1
0 votes
1 answer
1k views

Failed to open file error 13 on Windows 10, mysql source command

Before this, I executed -u root -p command and it went through, but trying source always gives me this error. I tried running terminal as administrator, moving the source file location, and setting ...
Justin Kim's user avatar
0 votes
1 answer
1k views

MariaDB not starting in windows 10 after crash

MariaDB 10.7 service suddenly stopped in Windows 10 after a crash and the service is not starting. The pop up shows 'windows cannot start mariadb service). The windows event viewer gives the following ...
sariDon's user avatar
  • 111
0 votes
1 answer
491 views

SQL Server 2005 error after update to windows 10 [closed]

I have a SQL Server 2005 database that I can see in SQL Server Management Studio Express. There is a front end application, but since the upgrade to Windows 10, I cannot access the database with it. ...
Aquamarine's user avatar
-1 votes
1 answer
288 views

how to back-up all databases in postgresql iteratively?

I have a large number of databases in postgresql 9.5 which I want to back-up using pg_dump tool. Each back-up should get its name from the corresponding database. when I run SELECT datname FROM ...
Brian's user avatar
  • 3
0 votes
1 answer
244 views

MariaDB: How to install a second instance using MSI-Installer

I would like to install a second instance of MariaDB with MSI-Installer (Windows 10). The first instance is on drive C. When I want to install the second instance on drive D using MSI-Installer the ...
giordano's user avatar
  • 257
1 vote
2 answers
3k views

Postgresql 14 on Windows 10: pg_ctl.exe returns is not a database cluster directory

I have installed postgresql 14 on a Windows 10 machine. But, I'm getting this message: C:\Program Files\PostgreSQL\14\bin > pg_ctl.exe start -D "C:\postgres" pg_ctl: directory "C:/...
nephewtom's user avatar
  • 151
0 votes
0 answers
579 views

How can Postgres clusters be managed on a Windows EnterpriseDB of Postgres?

To clarify, I am using plain Postgres as packaged by EnterpriseDB (with StackBuilder), not EDB Postgres Advanced Server. I'm familiar with using pg_lsclusters, pg_dropcluster, and pg_createcluster on ...
Lee Hachadoorian's user avatar
0 votes
0 answers
2k views

Postgres is extremely slow through localhost, for any command

Postgres 13 in my Windows 10 machine is extremely slow. Even with Postgres shell, every single command needs 22 seconds to be executed. Either it is a single query in a nearly zero-rows DB, or a ...
george lal's user avatar
1 vote
1 answer
1k views

How to restore one mysql database with mysqldump

to make a backup I run: mysqldump --host=localhost --user=root --password=whatever --single-transaction --routines --triggers --log-error=error.txt mydatabase > out.sql Is it possible to do the ...
acgbox's user avatar
  • 157
0 votes
0 answers
159 views

What is the alternative of PL/Java for PostgreSQL 11 and 12?

Understand from: https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/user-guide/11/EDB_Postgres_Advanced_Server_Guide.1.80.html that PL/Java is deprecated in Advanced ...
Jacky's user avatar
  • 1
0 votes
1 answer
3k views

Recovering InnoDB database from backed up “data” folder in XAMP in Windows 10

I copied the data directory from mysql folder and uninstalled the XAMPP as the MariaDB was not starting. I installed XAMPP same version and backed up the data folder into mysql data directory. At ...
Sourav's user avatar
  • 121
1 vote
2 answers
2k views

MySQL 8.0.24 Windows 10 crashes [not] resolved by reboot, [requires mySQL optimizer tweak]

MySQL 8.0.24 on Windows 10 (10.0.18363.0) crashes near the same point when running a final results query, but only after data input queries with many more records have been run. A restart of the MySQL ...
wistlo's user avatar
  • 119
0 votes
1 answer
2k views

Connect to WSL2 Postgres database from local network

I run Postgres 12 service in Windows Subsystem for Linux 2 (WSL2). In my /etc/postgresql/12/main/postgresql.conf, I have: listen_addresses = '*' while my /etc/postgresql/12/main/pg_hba.conf has this ...
vlad's user avatar
  • 103
0 votes
2 answers
164 views

Do I need a domain controller for multiple PCs accessing the same SQL server db? How do I configure it?

(more details/replicate from: https://superuser.com/questions/1612260) Dear all, I'm a total newbie in connecting 2 PCs and making them use the same SQL server DB from one computer ... so please ...
radui's user avatar
  • 101
0 votes
1 answer
25 views

Is it safe to use the Windows "Compress directory to save space" feature on the directory that contains my MySQL general log file?

I have changed MySQL 8 on my Windows 10 development machine to write logfiles (general log and slow queries log) to "E:\mysql logfiles". I'd like to compress this directory using the Windows ...
Nzall's user avatar
  • 221
1 vote
1 answer
469 views

SQL server memory pressure

First observed few months ago at end-user's laptop (rather slow i3 CPU, 4GB RAM, SSD) with SQL 2014 Express. The problem persists with SQL 2019, even with clean Windows 10 1903 installation. The ...
Jan Zahradník's user avatar
-2 votes
1 answer
3k views

What should I do about PostgreSQL logging so much "weird noise" in its own log?

PostgreSQL 12.4 on Windows 10 Pro 2004. With the default configuration file, I start PostgreSQL with pg_ctl and the "-l PostgreSQL.txt" option. It logs to that file. Looking in it, I'm ...
Orbelin's user avatar
1 vote
1 answer
6k views

Cant install SQL Server 2019

I have a single node Windows 10 Pro machine, 64 bit, with 32GB Ram and an i7 processor. When I try to install the developer edition of Sql Server 2019, it fails installing the Database engine with a ...
bilpor's user avatar
  • 111
0 votes
0 answers
505 views

Import table data using multiple sql file in psql

Local Machine(l1): Windows 10 psql Remote Machine(R1): linux EDB(postgres) On my local I have 1000+ sql script containing insert statement . psql is also installed locally . I need to run this sql ...
user236778's user avatar
0 votes
0 answers
3k views

Failed to add 'Admin user' to %2% user group in Oracle 19C Windows 10 installation

Oracle 19c installation fails with this error message. I am trying to set up oracle for my 'Existing Local User' account Installation logs tries to add Admin user to all groups and fails .it says ...
Aegon's user avatar
  • 11
1 vote
0 answers
1k views

PostgreSQL: "PANIC: out of memory"

Got an error while running an application connected to a PostgreSQL DB (10.12). All the connections got disconnected, looking through the server logs, I found the below. TopMemoryContext: 292488 ...
ChrisMM's user avatar
  • 121
0 votes
1 answer
692 views

After doing latest windows10 update 1909 SQL Server Management Studio 17 not working

yesterday I have an update for windows version 1909, after updating to the latest version, When I tried to open SSMS it shows me an error like this(please check the screenshot).
Dhanil Dinesan's user avatar
2 votes
1 answer
1k views

Old ODBC app throws "cannot generate sspi context" on Windows 10

An old Access 2003 .adp project is currently running on Windows 7 machines, while SQL Server 2008 is on the backend. Since the app is moved to a Windows 10 machine, the app will trigger "Cannot ...
Riccardo's user avatar
  • 135
2 votes
0 answers
383 views

All but one of my SQL Server 2017 databases are GONE after Windows 10 nightly update failure

EDIT: Restored to a restore point from three days ago, prior to a "Critical Update", and the databases are back. This is, I believe, the culprit update: September 10, 2019-KB4514601 Cumulative Update ...
Tim's user avatar
  • 545
2 votes
1 answer
11k views

pgAgent service for PostgreSQL does not run

OS: Windows 10 PostgreSQL 11.4 I Installed PgAgent with Stackbuilder setup. In Windows services; PostgreServer service is running. However, the pgAgent service is stopped. When I try to start ...
tomatoeshift's user avatar
0 votes
0 answers
176 views

Sybase 8 to Sybase 16 migration in Windows 10 OS

Currently we are using Sybase 16 db in our project. But there are few Sybase 8 db's (that clients are using in market) that needs to converted to Sybase 16 for any patch testing. I used to use the ...
MgmtTech's user avatar
1 vote
2 answers
2k views

How to set up signed SSL Root and Leaf certificates on a PostgreSQL 11 database on Ubuntu and Windows 10 Power BI plus PostgreSQL?

I have Power BI and PostgreSQL 11 installed on Windows 10 and my primary PostgreSQL 11 database on Ubuntu 18.10 Linux. I edited the postgresql.conf and pg_hba.conf files correctly to the IP Adresses ...
Humble-Data-22's user avatar
0 votes
1 answer
52 views

PostgreSQL 11 Windows 10 Truncates All Tables on Shutdown

i have a new Windows 10 laptop with beefed up processors, 16GB RAM and 2TB SSD storage. I have installed PostgreSQL 11.2 on this laptop, and use it to compile large datasets from various sources and ...
Michael Sheaver's user avatar
0 votes
1 answer
143 views

How present the result table below the last result query table, SSMS 2017

os: window 10 SSMS 2017, v17.9.1 I watched youtube videos of SSMS running two different queries and the last result was displayed below the last table. Example that I am referring in youtube. Now ...
christianbueno.1's user avatar
1 vote
0 answers
1k views

ODBC from Win10 32bit client only connects using IP address, but not using hostname

I'm experiencing a pretty strange problem. We're using a MS SQL based quality assurance software. The database is hosted on a MS SQL 2016 Std. server running on a Windows Server 2012 R2 VM. Our ...
user3744122's user avatar
0 votes
1 answer
517 views

How to deploy install of MS SQL Server 2017 Developer Edition via command-line script - not working

I'm trying to deploy MS SQL Server 2017 Developer Edition via command-line script from a server share that holds the install media onto Windows 10 1803 (June release). However, I'm not having much ...
cmc.tech's user avatar
0 votes
1 answer
1k views

SQL Server service start automatically only after Windows Shutdown, how can I make restart automatically without batch file? [duplicate]

I am using MS SQL Server 2014, When I restart my Pc the SQL Server Service does not start automatically, however, it does after Windows Shutdown and run again, how can I make it restart automatically ?...
Yousef Albakoush's user avatar
1 vote
0 answers
73 views

Deployed application (Oracle 11g, VB.NET 2015 and Crystal Reports) cannot connect to database

I'm developing an application using Oracle 11g, VB.NET 2015 and Crystal Reports on Windows 10. I created a package and installed it on another PC on same network. The package is running fine but ...
Ejaz Sarwar's user avatar
4 votes
3 answers
2k views

Can't restart Postgres on Windows 10 with external drive

I've been working on a postgres database, with my data directory on my 8TB external USB drive. Occasionally, I need to restart the postgres instance to change configuration settings, but for some ...
Rob G's user avatar
  • 149
3 votes
1 answer
4k views

SSMS crashes when attempting to create a database diagram

I'm currently using the latest version of SSMS (17.8.1) on windows 10 and everytime I try to create a database diagram it crashes without giving me any error message. I've already tried to re-install ...
Mattia Nocerino's user avatar
0 votes
1 answer
5k views

Can't install Oracle 11g [closed]

Error while installing Oracle 11g: Please find the StackTrace of this error. ID: oracle.install.driver.oui.OUISetupDriver:13 oracle.cluster.verification.PreReqNotSupportedException: Reference data ...
beskar's user avatar
  • 13
2 votes
1 answer
892 views

Connection's MAC address randomly changes on Windows 10, then stops

Because reasons (tm), we want to identify the client's MAC address on SQL Server side (local network, not about security, enables a very convenient feature in way transparent for applications). We do ...
GSerg's user avatar
  • 1,342
0 votes
1 answer
841 views

Connect analysis services to oracle database

I am looking to connect analysis services to an oracle database, and when I hit Process in AS, it gives me a generic Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [...
soandos's user avatar
  • 157
1 vote
0 answers
705 views

PostgreSQL service stops immediately after installing Windows Fall Creators Update 1709

The server itself runs fine with pg_ctl -D <datadir> start But the service stops immediately ("...Some services stop automatically if they are not in use by other services or programs") ...
Gunnar's user avatar
  • 121
1 vote
2 answers
7k views

How to set cache on windows 10 pro 64bit machine

When running Mongod I get the following WARNING: The file system cache of this machine is configured to be greater than 40% of the total memory. This can lead to increased memory pressure and poor ...
DCR's user avatar
  • 171
13 votes
1 answer
6k views

PostgreSQL 9.5 won't start after Windows 10 fall update

I've installed Windows 10 Fall update (1709) and now my PostgreSQL 9.5 server won't start. It worked yesterday before the update and I haven't made any changes to the configuration. I've checked ...
jvb's user avatar
  • 261
2 votes
1 answer
5k views

How to relax file permissions conditions on postgres database folder?

Postgresql service refuses to start if the data folder (PGDATA) doesn't belong exclusively to the postgres user (i.e. permissions = 700). Is there any way to disable or circumvent that condition? ...
user3748764's user avatar
1 vote
0 answers
818 views

How to run Oracle Client 10g from non Administrator account?

Hi I have 2 users configured on my Windows 10 Home machine. One is Administrator and another is my own user. Although my user is configured as an Administrator, I can use Oracle Client 10g from my ...
Mayank's user avatar
  • 11
1 vote
1 answer
12k views

'SSL is required but the server doesn't support it (2026)' error while making an SSL MySQL connection

I'm trying to make an SSL supported connection using MySQL Workbench 6.3.9. My OS is Windows 10 x64 and I have installed MySQL Server 5.7 x64 with OpenSSL-1.0.2L (Win64 version). I made a non-SSL ...
Zerthimon's user avatar
  • 111
0 votes
2 answers
691 views

Oracle12c R2 on Windows 10 starts only one of two instances. Manual start results in LRM-00109

I have installed Oracle 12c R2 on my local Windows 10 (64 Bit) machine. For the installation I choose only to install the software. After the installation I have used the tool that comes with the ...
ap0's user avatar
  • 113