Questions tagged [windows-10]
The windows-10 tag has no usage guidance.
72
questions
0
votes
0
answers
24
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 ...
- 111
1
vote
0
answers
14
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 ...
- 1,027
0
votes
0
answers
28
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 ...
1
vote
0
answers
261
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 ...
- 159
0
votes
3
answers
182
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 ...
- 1
0
votes
1
answer
313
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 ...
0
votes
1
answer
383
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 ...
- 111
0
votes
0
answers
16
views
Cannot connect to server after installation
I am new in MySQL.
I installed Windows 10 MySQL 8.
Installation was failed on the communication setup.
Server is running but I cannot connect through Workbench.
The problem was sold!
0
votes
1
answer
198
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. ...
- 103
0
votes
0
answers
24
views
Postgresql 11.4.1
Anytime I install PostgreSQL 11.4.1 it gives me this error: database cluster initialization failed.
I have tried all options but still giving the same error. Am using windows 10
-1
votes
1
answer
93
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 ...
- 3
0
votes
1
answer
106
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 ...
- 257
0
votes
2
answers
2k
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:/...
- 131
0
votes
0
answers
379
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 ...
- 133
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 ...
1
vote
1
answer
430
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 ...
- 157
0
votes
0
answers
133
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 ...
- 1
0
votes
1
answer
2k
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 ...
- 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 ...
- 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 ...
- 103
0
votes
2
answers
118
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 ...
- 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 ...
- 221
1
vote
1
answer
419
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 ...
- 111
-2
votes
1
answer
2k
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 ...
- 1
1
vote
1
answer
5k
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 ...
- 111
0
votes
0
answers
429
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 ...
- 25
0
votes
0
answers
2k
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 ...
- 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 ...
- 121
0
votes
1
answer
631
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).
- 103
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 ...
- 135
2
votes
0
answers
367
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 ...
- 435
2
votes
1
answer
9k
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 ...
- 143
0
votes
0
answers
160
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 ...
- 1
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 ...
0
votes
1
answer
51
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 ...
- 101
0
votes
1
answer
125
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 ...
- 101
1
vote
0
answers
968
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 ...
- 11
0
votes
1
answer
481
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 ...
- 3
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 ?...
1
vote
0
answers
67
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 ...
- 11
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 ...
- 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 ...
- 602
0
votes
1
answer
4k
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 ...
- 13
2
votes
1
answer
829
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 ...
- 1,342
0
votes
1
answer
769
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: [...
- 157
1
vote
0
answers
671
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")
...
- 121
1
vote
2
answers
6k
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 ...
- 171
13
votes
1
answer
5k
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 ...
- 251
2
votes
1
answer
4k
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? ...
- 121
1
vote
0
answers
726
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 ...
- 11