Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- postgres=# \c engine;
- You are now connected to database "engine" as user "postgres".
- engine=#
- engine=#
- engine=#
- engine=#
- engine=#
- engine=#
- engine=# select vds_id,vds_name from vds_static;
- vds_id | vds_name
- --------------------------------------+---------------------------------
- 5bc89c44-8773-41e9-9532-97307beb29ba | tendrl25.lab.eng.blr.redhat.com
- bd3901cb-ce5f-4d5b-aa59-bd7430497cfb | tendrl26.lab.eng.blr.redhat.com
- cee37edc-9d02-4df5-ad7a-c715af4381c1 | tendrl27.lab.eng.blr.redhat.com
- (3 rows)
- engine=# select * from vds_static where vds_id='5bc89c44-8773-41e9-9532-97307beb29ba';
- vds_id | vds_name | vds_unique_id | host_name | port | cluster_id | server_ssl_enable
- d | vds_type | pm_enabled | _create_date | _update_date | otp_validity | vds_spm_priority | recoverable | sshkeyfingerprint | pm_proxy_pref
- erences | console_address | ssh_username | ssh_port | free_text_comment | disable_auto_pm | pm_detect_kdump | host_provider_id | openstack_network_provider_id |
- kernel_cmdline | last_stored_kernel_cmdline | reinstall_required | vgpu_placement
- --------------------------------------+---------------------------------+--------------------------------------+---------------------------------+-------+--------------------------------------+------------------
- --+----------+------------+---------------------------------+----------------------------------+--------------+------------------+-------------+----------------------------------------------------+--------------
- --------+-----------------+--------------+----------+-------------------+-----------------+-----------------+------------------+--------------------------------------+--------------------------------------------
- -----------------------------------------------------------------------------------------------------------------------------+----------------------------+--------------------+----------------
- 5bc89c44-8773-41e9-9532-97307beb29ba | tendrl25.lab.eng.blr.redhat.com | 34373737-3732-4753-4837-3036584d444b | tendrl25.lab.eng.blr.redhat.com | 54321 | e37998dc-20bc-11ea-b465-00163e65f83b | t
- | 1 | f | 2019-12-17 16:35:51.29526+05:30 | 2019-12-19 19:47:30.616731+05:30 | 0 | 5 | t | SHA256:E4yORssw5tQYmD4f/8Bq8y2gKGywKe9i5k412md7fFU |
- | | root | 22 | | f | t | | 736a8219-618a-4abb-907e-52920fc58731 | {"current":null,"parsable":false,"blacklist
- Nouveau":false,"iommu":false,"kvmNested":false,"unsafeInterrupts":false,"pciRealloc":false,"fips":false,"smtDisabled":false} | | f | 1
- (1 row)
- engine=# select cluster_id from vds_static where vds_id='5bc89c44-8773-41e9-9532-97307beb29ba';
- cluster_id
- --------------------------------------
- e37998dc-20bc-11ea-b465-00163e65f83b
- (1 row)
- engine=# select vds_id,vds_name,cluster_id from vds_static;
- vds_id | vds_name | cluster_id
- --------------------------------------+---------------------------------+--------------------------------------
- 5bc89c44-8773-41e9-9532-97307beb29ba | tendrl25.lab.eng.blr.redhat.com | e37998dc-20bc-11ea-b465-00163e65f83b
- bd3901cb-ce5f-4d5b-aa59-bd7430497cfb | tendrl26.lab.eng.blr.redhat.com | e37998dc-20bc-11ea-b465-00163e65f83b
- cee37edc-9d02-4df5-ad7a-c715af4381c1 | tendrl27.lab.eng.blr.redhat.com | e37998dc-20bc-11ea-b465-00163e65f83b
- (3 rows)
- engine=# select vds_name from vds_static where cluster_id = 'e37998dc-20bc-11ea-b465-00163e65f83b';
- vds_name
- ---------------------------------
- tendrl27.lab.eng.blr.redhat.com
- tendrl26.lab.eng.blr.redhat.com
- tendrl25.lab.eng.blr.redhat.com
- (3 rows)
Advertisement
Add Comment
Please, Sign In to add comment
