Newest Questions
105,298 questions
0
votes
1
answer
52
views
Unable to restart PostgreSQL after automatic shutdown
My PostgreSQL server has unexpectedly shut down.
In the log file (postgresql-Wed.log), I can see the following:
2025-11-12 18:18:54 LOG: received fast shutdown request
2025-11-12 18:18:54 LOG: ...
- 1,843
0
votes
0
answers
35
views
PostgreSQL logical replication failing with "permission denied for schema" despite operating as the superuser
On a PostgreSQL 14 database, I've got a logical replication publication of 108 tables across 10 schemas. For some unknown reason, the subscriber fails to replicate tables in one of the schemas (call ...
- 175
-1
votes
1
answer
55
views
Couldn't import excel file in my SQL(SSMS) but the "IMPORT" and "EXPORT" are greyed or faint that it can't be clicked on
I have created my Database,then highlighted the database and right-clicked ,then TASK and to IMPORT but both IMPORT and EXPORT are faint.
- 1
0
votes
1
answer
40
views
Monitoring PostgreSQL Copy Operations
To monitor Copy operations in PostgreSQL in real-time, I use the “pg_stat_progress_copy” view tool:
Here, I specifically want to analyze the number of tuples processed by the command, which is “...
0
votes
0
answers
13
views
How commitlog_sync works with direct I/O?
If I set commitlog_disk_access_mode: direct - what's happening to commitlog_sync? It sounds like now I get something close to batch option?
- 1
0
votes
1
answer
39
views
SQL Server encrypting backup with a certificate failed with "Cannot find server certificate with thumbprint..."
Here is my demo code:
USE master;
GO
IF NOT EXISTS (SELECT * FROM sys.symmetric_keys WHERE name = '##MS_DatabaseMasterKey##')
BEGIN
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'StrongPassword123!';...
- 2,126
0
votes
1
answer
72
views
How can I find the source (hostname, etc.) of one Azure SQL Database query using Extended Events without having to capture every statement?
I want to do this, but there doesn't seem to be a supported way to do it. What is a version that would work?
CREATE EVENT SESSION [MySession] ON DATABASE
ADD EVENT sqlserver.sql_statement_completed(
...
- 2,295
0
votes
1
answer
30
views
PostgreSQL:Why promoting standby while primary is online causing WAL fork?
I have been testing PostgreSQL 17 AYSNC replication and failover on Ubuntu VMs. Suppose I have two VMs: A as the primary and B as the standby. If I promote B while A is offline, and later configure A ...
- 700
4
votes
1
answer
135
views
How can I tell which tables, indexes, or pages do not have checksums?
This time last year, I set the page_verify database option to checksum on a very old and very large database. We do weekly index maintenance, so I hope that most of the database's pages have been ...
- 1,362
1
vote
1
answer
15
views
decommissioned node still stuck in metrics
Need some help with our Cassandra 4.1.3 operation.
We successfully decommissioned a node in remote datacenter by first “ALTER KEYSPACE” with remaining datacenter, then “nodetool decommission”
nodetool ...
- 11
0
votes
0
answers
27
views
Transaction applied partially after failover in postgres
We noticed a data inconsistency in a 3-node asynchronous replication Postgres setup.
A single JDBC transaction inserted/updated rows in two tables but we are noticing that one table did not have a few ...
- 1
3
votes
1
answer
70
views
sqlcmd truncating "text" type column
I've noticed when using "sqlcmd" to connect to SQLServer, the text is cut off when the column is of "text" type and more than 256 characters.
I've discovered if I place "-y 0&...
- 131
2
votes
1
answer
92
views
RDS - connect to HA Secondary without joining domain
I am attempting to connect to the secondary replica in an HA RDS cluster. Usually I do this by connecting to hostname.vpc.local with the master user SQL Auth credential. Today I restored an HA cluster ...
- 5,951
1
vote
1
answer
70
views
How to change password for federated access between two IBM Db2 databases?
On single IBM Db2 v11.5 database server we have two databases connected with federated system. On source database there are federated definitions:
CREATE WRAPPER DRDA;
CREATE SERVER myserver
TYPE DB2/...
- 550
0
votes
1
answer
33
views
View or not to View
My experience is in Firebird v1 to 3. So, I am apprehensive about using views.
I am using MySQL 8.x on a Windows server.
The server side is a REST server on IIS.
The client is a WebApp running in the ...
- 2,168