3 Replies Latest reply on Sep 18, 2018 7:21 AM by MartinGustafsson

    vcenter appliance embedded database backup fails

    mogulsurf Novice

      Hi experts. vmw newbie here

       

      I have a vcenter 5.5 appliance which just died can't connect to it via vsphere

       

      I notice during startup that the database failed to load so googleling around i saw a couple of things to try

       

      but first i want to take a backup of the embedded DB and i found this article

       

      VMware Knowledge Base

       

      however when I run the backup cmd it fails with then below

       

      LBLRALVC1:/opt/vmware/vpostgres/current/bin # cat /etc/vmware-vpx/embedded_db.cfg

      EMB_DB_INSTALL_DIR='/opt/vmware/vpostgres/9.0'

      EMB_DB_TYPE='PostgreSQL'

      EMB_DB_SERVER='127.0.0.1'

      EMB_DB_PORT='5432'

      EMB_DB_INSTANCE='VCDB'

      EMB_DB_USER='vc'

      EMB_DB_PASSWORD='Tq&LYekN&9e+H^}m'

      EMB_DB_STORAGE='/storage/db/vpostgres'

       

      LBLRALVC1:/opt/vmware/vpostgres/current/bin # ./pg_dump VCDB -U vc -Fp -c > /tmp/VCDBbak

      pg_dump: [archiver (db)] connection to database "VCDB" failed: could not connect to server: No such file or directory

              Is the server running locally and accepting

              connections on Unix domain socket "/tmp/.s.PGSQL.5432"

       

      what am i missing here.

       

      not very good at cli so please if you have any suggestion please include the command i need to use

       

      Seems like it can't find the database file VCDB?

       

      thanks in advance