guamluv

updated

2 years ago

Closed

G

guamluv

1 Rookie

•

17 Posts

0

3767

August 5th, 2021 22:00

VxRail manager DB problem

HI, All

Completed upgrade to VxRail 4.7.411 -> 7.0.201. But. Can't get into psql -U postgres mysticmanager from VxRail Manager. It seems that the database does not exist. What should I do to solve it?

Thanks

  • Athar Alam

    1 Rookie

    •

    1 Message

    1153

    1

    Posted September 8th, 2022 21:00

    Database schema is different from 4.7 to 7.0 Please try below command to connect postgres DB.

     

    mystic # psql -U postgres vxrail

  • DELL-Josh Cr

    Community Manager

    •

    9745 Posts

    •

    44407 Points

    2747

    0

    Posted August 6th, 2021 09:00

    Hi,

    What is the output of service postgresql status?

  • TGOG

    10 Posts

    2746

    0

    Posted August 6th, 2021 10:00

    That is correct there was a DB change from 4.7 to 7.x that changed dramatically how the VxRail databases work. Is there a particular reason that you want to want to review something in the DB?

    Thanks

    Gearoid

  • guamluv

    1 Rookie

    •

    17 Posts

    2719

    0

    Posted August 9th, 2021 17:00

    HI. TGOG

    I want to view DB information in VxRail manager.
    If the following command is entered, the database does not exist.
    I want to check Mysticmanager and marvin information in VxRail 7.0.

    vxpmgr:~ # psql -U postgres Mysticmanager
    psql: FATAL: database "Mysticmanager" does not exist

    vxpmgr:~ # psql -U postgres marvin
    psql: FATAL: database "marvin" does not exist

    thank you.

  • guamluv

    1 Rookie

    •

    17 Posts

    2718

    0

    Posted August 9th, 2021 17:00

    Hi, 

    Postgresql status is 

    vxpmgr:~ # psql -U postgres Mysticmanager
    psql: FATAL: database "Mysticmanager" does not exist

    vxpmgr:~ # psql -U postgres marvin
    psql: FATAL: database "marvin" does not exist

    No information after VxRail upgrade.

    Thanks,

  • TGOG

    10 Posts

    2659

    0

    Posted August 15th, 2021 06:00

    You are right these databases dont exist any more in 7x

    This goes back to my original question what are you trying to do in the database as things have changed with the introduction of micro-services etc that maybe farmed out to a micro-service instead

    Dont forget solve is updated with 7x commands for things that used need DB access in 4x

     

    Hope that helps

    Gearoid

  • vinayakchristus

    1 Rookie

    •

    1 Message

    •

    2 Points

    0

    0

    Posted March 24th, 2025 16:56

    @Athar Alam​ this works!