Dell EMC VxRail: VCF on VxRail: How to collect SDDC Manager postgres DB through CLI
Print
Created by: Srinath Ramachandran
Modified on: Mon, 21 Sep, 2020 at 11:16 AM
Article Content
| Instructions | VCF on VxRail: How do you collect SDDC Manager postgres DB through CLI- Connect to the SDDC Manager through SSH.
- Execute the command on SDDC manager cli:
- "for DB in $(psql -h localhost -U postgres -c "\l" | grep UTF.*Tc | cut -d ' ' -f2); do for TABLE in $(psql -h localhost -U postgres -d $DB -c "\dt;" | grep table | cut -d '|' -f 2); do echo $DB"."$TABLE; psql -h localhost -U postgres -d $DB -c "select * from $TABLE;" ; done; done > /tmp/postgres.txt "
- Copy it through winscp and upload it to an FTP.
|
Srinath is the author of this solution article.
Did you find it helpful?
Yes
No
Send feedback Sorry we couldn't be helpful. Help us improve this article with your feedback.
