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
1
vote
1answer
18 views

Locale is incompatible error in Postgresql 10 when replicating from Ubunu to Win 10

The locale available in my Ubuntu PG-10 DB is en_US.UTF-8. When doing PG_Basebackup to a PG-10 DB in Win-10, Psql failed to connect with error psql: FATAL: database locale is incompatible with ...
0
votes
0answers
18 views

missing the OracleOraDB12Home2TNSListener service

I have just completed the installation of the Oracle 12c database, following this tutorial. My OS is Windows 10. The installation has completed successfully, only green ticks. The problem is that, ...
0
votes
1answer
76 views

Postgres Windows post-install “The database cluster initialization failed”

I've seen many solutions and have been working on this issue for hours now. After installation the post-installation script fails with the message above. This is a development installation of ...
0
votes
1answer
14 views

Move Mysql database from Windows Xampp to Linux MySql Server

I 'am looking for a way to move some database in my local xampp to remote MySql Server , running into a Linux VM (Centos 7) Any idea or any suggestions to do this migration?
1
vote
1answer
41 views

Dynamic quorum and Dynamic witness in Always On AG 2016

I have a Always On AG 2016, configured on Windows Server 2012 R2 – 2 node cluster. Quorum configured as 2 nodes + Fileshare witness, totally 3 votes. Scenario 1: Now, either 1 node fails – remaining ...
1
vote
0answers
75 views

Oracle 18 on Windows with long hostnames doesn't talk to the local listener?

Note: Initially this was about installing Oracle 18c XE on a Windows machine with a long (> 15 chars) hostname. During our further tests we then noticed that Oracle 18c XE does not work properly at ...
0
votes
0answers
79 views

MySql Workbench Couldn't find section mysqld in the remote config file /etc/mysql/my.cnf

if you get this trying to connect to your remote server using MySql Workbench, then try to (on your remote server) navigate to /etc/mysql/my.cnf and add [mysqld] then it should look like: !...
2
votes
1answer
60 views

SQL Server Demo Environment on Docker Desktop (Win 10): DB storage und upgrade paths

I would like to run SQL Server 2019 on my work as well as my private machine (both running Windows 10 Pro). Thus I thought Docker Desktop would be a nice option. However I would like to keep the ...
0
votes
0answers
8 views

Windows 2016 Workgroup failover cluster

I am building a two node Window failover cluster for SQL Server AG. I am getting following errors in the cluster log. Please help me to resolve the error. Thanks
0
votes
0answers
63 views

bcp: dsn specified an unsupported driver

A straight-forward call to bcp works on linux and not on windows. Ubuntu ~$ /opt/mssql-tools/bin/bcp "select @@version as v" queryout foo.csv \ -D -S mydsn -c -U myuser -t, -r '\n' -P '...' ...
1
vote
1answer
189 views

Error while configuring REST for Oracle APEX on Windows

I'm trying to deploy Oracle APEX 18 on Windows 8.1 PC using Oracle REST Data Services and Oracle Database 18c XE following this guide. But when I'm trying to run @apex_rest_config.sql I get this ...
10
votes
2answers
709 views

Limit max CPU usage SQL SERVER with WSRM

I have a physical server running one instance of SQL Server. I notice that quite often this server is running at 100% CPU usage. My IT team is not happy about this, and suggested we reserve 2 of the ...
0
votes
0answers
697 views

Can't figure out how to start postgres on port 5432 in windows

Setting up Postgres on Windows for frontend web dev This is not my area of expertise (frontend guy), but I need postgres simply running on my side to connect with the test DB for the project I'm ...
0
votes
0answers
45 views

PostgreSQL 9.6 on linux server gives a different collation than windows installation

I am running into an issue with a script that makes a backup towards the SQL. What happens is that with our script we make a dump of SQL we can read out to restore the PostgreSQL database. Our client ...
0
votes
0answers
14 views

MySql module in xampp server is not starting..Getting following error log:

Error: MySQL shutdown unexpectedly. 3:30:57 PM [mysql] This may be due to a blocked port, missing dependencies, 3:30:57 PM [mysql] improper privileges, a crash, or a shutdown by another ...
0
votes
1answer
47 views

SQL Server Management Studio - Debugger buttons greyed

I have for mission to enable Transact SQL from a remote computer. My database is on a server and i'm trying to use the debug from a computer on the same network. My firewalls are all open on both side....
0
votes
1answer
198 views

SQL Server Execute Permission Denied

I have a small app which calls a stored procedure over ODBC using a sysadmin user with login and password. The problem is that some (Windows Domain) users get an error saying execute permissions were ...
2
votes
0answers
105 views

SQL Server stored procedure not throwing certain kind of error

I noticed an issue in my app recently where an database insert that occurred in a stored procedure was failing, but no exception was getting thrown. The insert failed because a column that doesn't ...
1
vote
1answer
1k views

Getting error while creating a New Connection using Studio 3T for Mongo DB

I tried to create a new connection with Studio 3T for Mongo DB. I don't have a previous DB connection and this is the new one that I am trying to create it. I can't able to figure out why this is ...
0
votes
1answer
34 views

adding pgadmin3 to windows start menu

I have installed postgres (different versions actually) as well as pgadmin3 on windows using the package manager: https://www.openscg.com/bigsql/package-manager/ https://www.openscg.com/bigsql/docs/...
-1
votes
1answer
90 views

Cannot find innodb_page_size option in [mysqld] section in my.ini file

Where can I find innodb_page_size option? Since I cannot find it in [mysqld] section in my.ini file. I want to change it to 32k or 64k since I am getting the below error: MySQL: Error Code: 1118 ...
1
vote
1answer
70 views

Import Windows MySQL dump on a Debian Linux server

I created a test database on a Windows computer with MySQL 5.7 and filled it with many data records. Now I created a database dump with mysqldump and wanted to import it on my server (Debian Jessie, ...
-1
votes
2answers
49 views

What permissions should be added to public users sql [closed]

I have a SQL Server and am looking at making it public. What I mean by this is: I can create a DB and give access to myself and friends etc. I need to create a login which can only view databases it ...
0
votes
2answers
612 views

Error cs1567 while installing ms-sql on windows 8.1

I tried to install sql server 2008 and 2012 on my windows 8.1 laptop, but at both times I faced with the same error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the ...
0
votes
1answer
122 views

Running loadjava with Windows authentication

I want to run following command under Windows with Oracle Database 12c installed: loadjava -force -genmissing -r -user username/password@database -verbose core-1.7.jar The problem is that I use ...
0
votes
1answer
49 views

Oracle TKPROF Insert data doesn't match text results

I'm trying to make sense of the output from a SQL Trace from an Oracle 12.2 database on Windows. I've used TKPROF to interpret the the resulting trace files. This utility generates a text file output ...
1
vote
0answers
46 views

MySQL 5.7 issue with 16TB disk

(Repost from StackOverflow) I have a MySQL 5.7 running on a Windows Server 2016 VM with two disks from a NAS: C:\ for system and D:\ for data (empty at start). I try to create a partitioned table: ...
1
vote
1answer
45 views

Which Editions of Oracle are Free?

I am aware of Oracle Express edition which is up to version 11g, which is pretty dated. However, I have read that Oracle are changinging/have changed their licensing of newer editions so that we will ...
-2
votes
2answers
1k views

How do I install a PostgreSQL extension in Windows? [closed]

In Linux (with Ubuntu or Debian) if I want to install gen_salt(), I first install the -contrib package. sudo apt install postgresql-contrib Then I install the extension in the database, psql -d ...
2
votes
1answer
97 views

How to access a shared folder from Windows Cluster IP [closed]

This is a very strange question, but I am trying to access a Windows file share from a SQL server cluster IP, that resides on that server. In the past and on other servers I have, I get connected to ...
3
votes
1answer
859 views

How to restore from .wt files?

Environment Windows Professional 10 MongoDB 3.6.4 2008R2Plus SSL (64 bit) (before computer crash) MongoDB 4.0.2 2008R2Plus SSL (64 bit) (after computer crash) I have been developing locally, and ...
0
votes
1answer
68 views

Always On Windows Server Edition

For setting up Always On Availability Groups in SQL Server I know you need to have at least Enterprise Edition for SQL Server 2012, 2014, or 2016. Do you also need the Datacenter or Enterprise ...
-1
votes
2answers
106 views

MySQL on Windows or Linux [closed]

I am new to the Database region while have to migrate the company's database from AWS RDS to AWS EC2 and subscribe MySQL Enterprise edition. What I am confused now is which OS should I choose, ...
0
votes
0answers
36 views

Do any of the PostgreSQL releases for Windows support automatic updates?

PostgreSQL has two distributions for Windows, EnterpriseDB BigSQL Do either of these Windows distributions support automatic updates for the term of support? Something that looks for the updates ...
1
vote
2answers
814 views

MySql 5.6: Ignores innodb_page_size setting in my.ini

So I tried to increase the innodb_page_size to 32k, by setting this value in my.ini: innodb_page_size=32k I then stopped the MySql service, and restarted it. The service in Win looks like this: "C:\...
0
votes
1answer
440 views

Python version issue on Cassandra 3.11.2

Searching around I found a lot of thread about this problem (coming from 2012) but I can't find an official solution: running cqlsh.bat File "C:\apache-cassandra-3.11.2\bin\\cqlsh.py", line 146 ...
0
votes
1answer
119 views

Does the Mysql install location affect write speeds?

Up until lately, I used a 32 bit version of Mysql 5.7, bundled with a WAMP server (EasyPHP) on Windows for local development, all running on an SSD. I ran into database size issues, and had to upgrade ...
0
votes
0answers
73 views

OpsCenter missing in Datastax Cassandra for Windows

Following this guide within the Cassandra installer I should get OpsCenter too. But this screenshot https://www.datastax.com/wp-content/uploads/2012/01/dsc-win4.jpg doesn't match the current release (...
1
vote
1answer
29 views

Connection is Using Properly or not in Net Use via SQL Procedure

am doing an operation of creating a file and writing in a SAN SAMBA where it will be done using the cmd_shell via SQL Procedure. It's creating and writing it successfully but while am calling that ...
0
votes
1answer
138 views

MySql Replication on Windows

guys any one please give detailed document on Mysql Replication on Windows System.I replicated master to slave, but it is showing 'connecting to master' errorno showing as 1045 and 2003 its varying. ...
1
vote
3answers
1k views

How to prevent asking for password when creating new database in PostgreSQL 10?

I use the following batch file to create a new database in PostgreSQL 10. echo off cd "C:\Program Files (x86)\PostgreSQL\10\bin" createdb -h localhost -p 5432 -U postgres myDB But it asks to enter ...
0
votes
2answers
48 views

Drive holding my database is running out of space. What are my options?

I am new to database administration. I've been scraping a website for a month now. I have two drives, each 2TB in size. I have PostgreSQL 10 on my first drive (c:) and it has 50GB left. I've only ...
0
votes
1answer
325 views

Local Cosmos DB service unavailable

I've installed the azure cosmos db in my local machine but is not loading the explorer pages as shown below: Explicit error: Failed to get authorization headers for offers: {"readyState":4,"...
0
votes
1answer
2k views

How to create a new database in PostgreSQL 10 in Windows from batch file?

I am creating a batch file to create a new database in PostgreSQL 10. I used the following code, echo off cd "C:\Program Files (x86)\PostgreSQL\10\bin" psql "dbname=myDB host=localhost user=postgres ...
1
vote
1answer
722 views

MySQL select * from table without conditions does not return rows right away

I have a table with about 4 million rows and a bunch of columns on each row and I'm doing a simple select * from table in the mysql client and it doesn't return data right away. A count(*) of the same ...
0
votes
1answer
1k views

`“C:\xampp\mysql\bin”' is not recognized as an internal or external command,operable program or batch file [closed]

I am trying to access to mysql from windows command prompt by this command: "C:\xampp\mysql\bin" mysql -u root - p But it sayas: `"C:\xampp\mysql\bin"' is not recognized as an internal or ...
0
votes
1answer
18 views

Regularly clone/backup 2 MySQL databases unidirectionally from PC to Laptop both running Windows

I have a PC running Windows XP with a custom ERP system and MySQL Server 4.x (A) and a Laptop running Windows 10, same MySQL 4.x and same custom ERP (B). I'm afraid I can't upgrade PC nor MySQL, etc. ...
1
vote
1answer
474 views

Access denied error when archiving WAL during postgresql 9.5 replication setup

I want to setup Postgres replication on Windows. I followed the given youtube url step by step: youtube video. For archive_command I use this: archive_command = 'copy "%p" "\\\\ip-address of ...
0
votes
1answer
704 views

How save psql `ERROR` output to the same file as the DDL commands?

I'm trying to restore a database from a text file. I'm following the answer on this question. How do I restore a plain text postgres .backup file But add: > c:\result.txt psql.exe -U sde sde <...
1
vote
1answer
54 views

Share mongo database between two OS on dual boot

Now I have two OS on my computer: Windows 10 and Linux (arch). Sometimes I use Linux but I also use windows because of gaming, and I want to create a small application that is going to work on both OS....