Troubleshooting Hybrid Data Security (HDS) PostgresDB and Microsoft SQL Server Configuration
Troubleshooting Hybrid Data Security (HDS) PostgresDB and Microsoft SQL Server configuration
How do I troubleshoot HDS Postgres DB or SQL Server configuration issues?
What are the system specifications for the Postgres DB for HDS?
Note: As of January 24, 2019, Cisco HDS now supports Microsoft SQL Server as a database. Microsoft SQL Server support is intended for new deployments of Hybrid Data Security only. We do not currently support migration of data from PostgreSQL to Microsoft SQL Server in an existing deployment.
Troubleshooting PostgresDB and Microsoft SQL Server Configuration for HDS
Troubleshooting PostgresDB and Microsoft SQL Server Configuration for HDS
- Cisco does not want to become a Database Administrator (DBA) for our customers. Customers are expected to be familiar with and maintain their own databases.
- Current items not supported are related to maintaining and monitoring a Database (DB).
- What backup solution should I use?
- What operations do I need to do to maintain my database? What is vacuuming?
- How do I restore a database?
Some examples:
- Why is 2TB the recommended disk size, it’s rather large?
- Disk sizing was done for large organizations with long lived HDS servers. Smaller customers can size smaller, but are required to monitor disk space.
- 1 Postgres 9.6.1 Database Instance (Key datastore)
- 8 vCPU, 16 GB RAM, 2 TB Disk.
- User created with createuser.
- User assigned GRANT ALLPRIVILEGES ON DATABASE <database> TO <user-role-specification>
Microsoft SQL Server Requirements
- SQL Server 2016 Enterprise installed and running with Service Pack 2 and Cumulative Update 2 or later, installed and running
- 8 vCPU, 16 GB RAM, 2 TB Disk.
- Select Mixed Mode Authentication during setup. Windows Authentication mode is not supported.
- Supported high-availability options: Always On Failover Cluster Instances or Always On availability groups
Was this article helpful?
