Skip to content

SHOW SSL SYSTEM

Export the system certificate for SSL trust on a remote system that is used for replication.

SHOW SSL SYSTEM

See Configuring SSL Trust for details about when to use this command.

For example:

premdb=# show ssl system;
                       SYSTEM CERTIFICATE                        
------------------------------------------------------------------
 -----BEGIN CERTIFICATE-----
 MIIFyDCCA7CgAwIBAgIJAKbfKdX9Np6DMA0GCSqGSIb3DQEBCwUAMIGCMQswCQYD
 VQQGEwJVUzELMAkGA1UECAwCQ0ExHzAdBgNVBAoMFlllbGxvd2JyaWNrIERhdGEs
 IEluYy4xLTArBgNVBAsMJDQ1M0M4M0JBLTBCMEMtNDAyMS1BMjcxLTE5NzdDRkJC
 MTlGQjEWMBQGA1UEAwwNeWJpbml0X2Rldl9jYTAeFw0xOTEyMTMxNzEzMzFaFw0y
 OTEyMTIxNzEzMzFaMHwxCzAJBgNVBAYTAlVTMQswCQYDVQQIDAJDQTEfMB0GA1UE
 CgwWWWVsbG93YnJpY2sgRGF0YSwgSW5jLjEtMCsGA1UECwwkOTU0OGZlZWYtMWNj
 MC00YTg1LTliN2EtYjVmMjk4YjI1YjVlMRAwDgYDVQQDDAdicnVtc2J5MIICIjAN
 BgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAm+QpCcsdkfHjoLkfmuLL6ltKAmvD
 P3d6MyA/PANarYQTP8stSxE/aa1OZ8ZxXaY4aLc468qYxIjtOiE51odI6pG3jOab
 zOYZ+Fvx5643wJ5nTXcqf+nHp4cTrpJX37DVsI5rbGjJzUn1y246zSfBoJqMmDu5
 aVjrO8Gz9D2IrMHxOrlk4U2xu/qSZTThvn1zVmo+qMX2NY181Iql3PvT7Iuw1/NR
 MQ4FmDOpFyB0w67/msT2G6DFvZlCPluoPH+56oTVhaB8UFj/kvSdBQX6ylOasNzB
 wEu/XpRnL/WIBLWyN/Q0umuVKGuHQa+6iY8oJOtOV+5cXpOj1+Y+lV9f0JTrPwJG
 g5Xxvk2zyllOfuiMJHPEyLB4BrU2BroQPabGYPlMD5Z0Y30DZWhvyj+l4gWX2L+d
 tzV+V832iSw3/1rGMLRWjiwhUkcwSBV99HcwMEOzr0cejQGGLXgRcL8rTDCH1j4o
 hcAJ8ZxKaUvh1Z+nBXnw6MR1B/8rXqyenLVKukKxea0couKxJnp7oi5RuekmdowO
 PbJ6t3iCgGqZdIsgsGJyA0UDBAO2IopHdXQhi11gsBJMU1BcIvkRgxGoPE2E3QKt
 AhSAZ6Qf6vEHovMSoyrGXzPvfDNHBCLQ6ZZcU2F0NdmVhZxXZZKlNuQRUoahNAVl
 rWp+Av07BtiA98UCAwEAAaNGMEQwCQYDVR0TBAIwADALBgNVHQ8EBAMCBeAwKgYD
 VR0RBCMwIYIHYnJ1bXNieYIWYnJ1bXNieS55ZWxsb3dicmljay5pbzANBgkqhkiG
 9w0BAQsFAAOCAgEAf6+7CTBQJZLdjc9pk9RQP1DL5kvxuQayTgkpF3uYnIyAiD15
 GLtwuRXnbuzN0UCMNl1747aNmCV6LLoq6MZWZpSAyug6lYyNZP7uA9bdv0whIYVA
 PJMJDtz2AgqxK3mEnRfTvLmQ+6mQRwP+kYPpe4DR191KhmUpsO25vugciV6tufNr
 VHZox04f/B5aasFU5A9JJ2x11D/7ZjG71meDB76b21FyhQURQKx5N+/ReMAcqvaF
 pf0e1qrWEd5SA/onX6EGbXmxBBDb1A+5XSpjor6pr6Uap8MfCLtqrwzBz74/sC0t
 vLDADPC5DXXZupEOOXvPGV8oshArdYhNzX5Y1B2RR78Wqz2Xrstb41eD/TBUUO7N
 LpTVF/aGATjubgK0vCjVVdwdzC+J3UfQmoLElNOrL6+6bzsu8EzWwu18wwKrUQmb
 Llzd7CSrXPR9F3qoQ7PtTH2plFskjdY6Tqgog8OStkMHG+plnw1AAaEVRPOv4ZWX
 yJeRWi4g5FlgV+Fkc66biBicZW9+vxw5uoRw/zW49vtjYOZllupVKHV0dg+3r+B0
 jgaJSCDXTsmRJmEoefeC/zEgO4AGrwk3BmCE2i6Zwt+lqCfKZOJCQmt7yQwHp0s0
 VCN9CLDM20JZ2kvBk9K8BDUdMeN7jOFQrdILcIq2ZKFdFdu0yzlW1FTOvtQ=
 -----END CERTIFICATE-----
(33 rows)

Parent topic:SQL Commands