Replace custom_schema with the schema on the databaseReplace dbo with the schema you want the table to have Note: The above query only creates commands that can be used to change the schema. you will need to run the output of the above command.
vcsa certificate store (global sigining root)
location /etc/pki/tls/certs
Duplicate STS signing certificates can cause authentication failure.
Log: The duplicate certificate needs to be deleted via jxplorer, refer to the screenshot above (from the above example, trustedcertchain-2 and trusted credential-2 had the same certificate which had to be deleted from the system)
Handy commands when working with vPostgres
Copy Table to CSV Copy table from CSV list Top tables by size: postgres password: Rename table Database backup/Dump using pg_dump Database backup (excluding a specific corrupted table) Determining broken tables(pg toast) Starting postgres in single user mode: Reset WAL (Write Ahead logs) Error “MultiXactId has not been created yet — apparent wraparound” Manual Recovery […]
Replacing VMware-stsd certificate on 6.5/6.7
If the vCenter was upgraded from 5.5, it retains legacy endpoints for lookup service IE: https://FQDN:7444/lookupservce/sdkRunning certificate-manager will not replace the certificate and vCenter might actually start to complain about expired certificate although they are valid. In this can be easily worked around by replacing the certificate on the VECS store: Start by exporting the […]
VMCA Certificates replacement for vCenter 6.x, workflow
VMCA is the Default self-signed certificates that is set up at the time of vCenter deployment. All solution users and machine SSL certificates are signed with this certificate. VMCA certificates can be regenerated by using option 8 on the certificatae manager. choosing option 8, you are presented with the below options: Below are the .cfg’s […]
VMware Converter Workflow for Linux conversions.
Step 1: Validate source connect to source Linux VM via SSH (port 22 by default/specify port number in the IP address field if using custom ports The account used must be a part of sudoers (must be able to run a sudo command without prompting for a password. Here’s an example from my setup Step […]
Restricting Plugins on vSphere web-client (Flex and html5)
on Certain occations when the vCenter is upgraded, Plugins like pure, Netapp, NSX, SRM etc can cause incompatibility and prevent the webclient from loading up/Malfunctioning Starting vSphere 6.7, we have a config file to white list and black list plugins which helps us to flag specific Malicious/incompatible plugins which prevents the web client form loading […]
recovering from an unresponsive hostd after a datastore/storage goes PDL
Hostd crashes with the below: Scsi Decoder: Link In my case, The volume appeared to have gone offline because the host was aborting the commands to the HBA. This shows that hostd still appears to be stuck as running in a zombie state. To resolve this, we will need to reset scsi commands to vmhba32 […]
PostgreSQL: could not open file “/var/lib/pgsql/data/pg_clog/0726”: No such file or directory
when selecting a specific date from a table, at times due to database corruption Postgres might report the file was not found. In Such instances, we will can re-create the file using the below dd command (note: data loss on the missing file) Note: Ensure the permissions on the file that was re-created are set […]