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










      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