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 […]
joining Esxi to domain fails with LW_ERROR_INVALID_MESSAGE [code 0x00009c46]
Joining Esxi to doamin fails with the below message: Cat /etc/hosts show below: In some cases, the hostname on the /etc/hosts file might not match to that of the host. (look for the message on domainjoin-join “With Computer DNS Name: esx.” In order to sort this out, correct the /etc/host file (in my case, I […]
Installing VMware PowerCLi Install on windows 10/2012/2016 via Windows Gallery
Before you proceed, ensure there are no older version of VMware PowerCLi installed (check in add or remove programs), uninstall if you do have the older version. Install PowerCli from Windows Gallery Open powerCLI as an administrator and then run: List available VMware module: Import Module Troubleshooting Import module’s generally fail with the below error: […]
Passing through a Nvidia GTX970 to a VMware Virtual machine
Create a virtual machine with EFI boot, install windows + tools and power down the VM Open ssh to the host where the VM is registered to use vim-cmd to look for the VM cd to the data store path Edit the vmx file using the vi editor and add the below lines Save the […]