Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I have successfully set up a postgres master-replica with repmgr for automatic failover which can be found over here https://github.com/mgonzaga1990/pg-rpi-failover Now what I'm planning to do next...
Asked on 12/31/2020 by Jayson Gonzaga
0 answerAs our (32-bit) application uses the Oracle client for communication with the Oracle server I have set up a test environment on a Microsoft Windows Server 2019 Datacenter. I have...
Asked on 12/28/2020 by Ben A.
2 answerhave a logging table that contains references to other objects in other tables. I want to create a view to add some additional data to the logging table by looking...
Asked on 12/28/2020 by yellephen
2 answerI have schema A in a database and have assigned the default tablespace as myspace. There are 20 tables that reside under this single schema and all the tables are...
Asked on 12/28/2020 by Maheshnagakumar
1 answerI'm trying to implement a simple ABAC system using row level security, with main policy defined as following:CREATE policy resource_access ON resourceUSING ( ( org_id::varchar...
Asked on 12/28/2020 by Ivan C.
1 answerI created a user with the role of userAdminAnyDatabase db.createUser({user: "Username", pwd: "password", roles: [{role: "userAdminAnyDatabase", db: "admin"}]})and also user with the role of userAdmin for a single db...
Asked on 12/27/2020 by DragonBorn
1 answerI'm a new in MongoDB cluster. I have a question about config enable shading collection in MongoDB:I have a cluster :Shard1: replical01/node1:27017, node2:27017Shard2: replical02/node3:27017, node4:27017...
Asked on 12/26/2020 by muon.ha
1 answerI'm having this totally weird scenario: We have an archiving server based on PostgreSQL inside a Scientific Linux virtual server. I want to migrate the data (20+ GB) to a...
Asked on 12/26/2020 by 3bdalla
2 answerI have very complicated situation here. Application team was reporting that they see spikes and errors every 20 mins. We checked what was running and found log backups. So we...
Asked on 12/25/2020 by BeginnerDBA
1 answerWe have deployed an Oracle RAC cluster which consists of three Oracle instances. As we are considering the HA issue, and as far as I know, the only way of...
Asked on 12/25/2020 by yifan
1 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP