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, 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 […]