Questions tagged [network]
The network tag has no summary.
192 questions
2 votes
1 answer
90 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
0 votes
0 answers
49 views
PostgreSQL pg_dump fails with "server closed the connection unexpectedly" during COPY operation
Problem Summary My automated PostgreSQL backup script using pg_dump was working fine until a few days ago. Now it consistently fails with a connection error during the COPY operation on the alternate ...
- 101
0 votes
1 answer
28 views
Unable to connect to auxiliary database
I am trying to create a standby (WIEN), however I am not able to connect to the auxiliary, and I don't see the issue, the same setup has been used for the primary (GRAZ). GRAZ: [oracle@server-graz dbs]...
- 137
0 votes
1 answer
130 views
Dealing with Oracle over high-latency links
We have stand-by application-servers in multiple datacenters -- in case we must fail-over in a hurry -- and would like to make some use of them during the times of normalcy. The Oracle databases are ...
- 166
1 vote
1 answer
56 views
Ipv6 creating table load data and retriving in mysql using ip_poly
CREATE TABLE `ipv6_table` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `ip_poly` POLYGON NOT NULL, `start_network` BIGINT(20) NOT NULL DEFAULT '0', `end_network` BIGINT(20) NOT NULL ...
- 11
0 votes
1 answer
61 views
SQL Server Backup to Network Share Across Different Active Directory Domains Using Cross-Network Access
I have two separate Active Directory domains (FOO and BAA) A dedicated backup server with S.O Windows exists in the FOO domain. A SQL Server instance in the BAA domain needs to store backups on this. ...
2 votes
1 answer
39 views
How do I store time-varying follower-following relationship?
Assume we have a small social media app, containing only 4 people, whos UID = 11, 22, 33, 44 respectively. These people would follow and unfollow each other over time, and say, I want to take note of ...
- 121
0 votes
2 answers
110 views
Is it constraint on database client-server deployment (Firebird, Postgresql, Oracle) that it should not be made over WiFi (due to unreliability)?
Database client-server connectivity can sometimes happen. I mean: there is client side dll that sits on the client computer (device, it can be mobile phone as well). For the Windows OS based clients: ...
- 101
0 votes
1 answer
232 views
PostgreSQL: using stale statistics instead of current ones because stats collector is not responding
We are running PostgreSQL 13 on Azure Centos VM and found this problem from the logs followed by some slow commit and SET statements. The slow statement logs are only lasted for a period of less than ...
- 700
0 votes
1 answer
246 views
Connection string for a successful SSMS connection
In SSMS v19 I can successfully connect/login to a SQL server that is listening on the default port 1433 Server : server.env.domain.com,1433 Authentication : SQL Auth And I can query any of the ...
- 99
0 votes
0 answers
368 views
Pgbouncer: got packet 'E' from server when not linked
Does anyone knows what this error below means? We running pgbouncer 1.21 on centos using transaction pooling mode. 2024-04-29 15:00:02.378 CST [9680] WARNING S-0x197b028: db/[email protected]:5432 got ...
- 700
0 votes
1 answer
132 views
PostgreSQL & SQLAlchemy: Minimizing Impacts of latency with chatty applications
Are there any ways to minimize the impact of latency between the application and database when running PostgreSQL & SQLAlchemy ORM? Changing loading strategies or preloading properties has been ...
- 78
0 votes
1 answer
55 views
Network utilization maxed out during backup. Is it bad in itself?
We have a cluster of two Oracle DBs. Monitoring software agent is installed on both of the machines and overnight, when backups are happening, we get warnings that network interface utilisation on the ...
- 144
0 votes
1 answer
226 views
PostgreSQL: What's the most accurate way to find the network bandwidth of a Query result set
I have been trying to figure out network bandwidth of a Query output, since PostgreSQL only holds I/O bandwidth of Query I ended up in Octect_length() or pg_column_size(). I found below query from ...
- 700
2 votes
0 answers
43 views
MySQL Client taking more than 14 sec to be connected
IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
- 21