Start a Conversation

Unsolved

G

17 Posts

3236

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

Moderator

 • 

8.6K Posts

August 6th, 2021 09:00

Hi,

What is the output of service postgresql status?

10 Posts

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

17 Posts

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.

17 Posts

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,

10 Posts

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

1 Message

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

No Events found!

Top