Skip to content

SHOW SSL IDENTITY

Display the login identity certificate, which is only used at runtime for replication login.

SHOW SSL IDENTITY

For example:

premdb=# show ssl identity;
                      IDENTITY CERTIFICATE                       
------------------------------------------------------------------
 -----BEGIN CERTIFICATE-----
 MIIFuzCCA6OgAwIBAgIJAPbhAtmlePVuMA0GCSqGSIb3DQEBCwUAMH8xCzAJBgNV
 BAYTAlVTMQswCQYDVQQIDAJDQTEfMB0GA1UECgwWWWVsbG93YnJpY2sgRGF0YSwg
 SW5jLjEtMCsGA1UECwwkODYyNzcwMDMtMDNlNi00OTdjLWIxNWEtOTkyMGQ5Zjgx
 MDZjMRMwEQYDVQQDDApzeXNfeWJkX2NhMB4XDTIwMDExNzIwMDIyM1oXDTMwMDEx
 NjIwMDIyM1owgYMxCzAJBgNVBAYTAlVTMQswCQYDVQQIDAJDQTEfMB0GA1UECgwW
 WWVsbG93YnJpY2sgRGF0YSwgSW5jLjEtMCsGA1UECwwkODYyNzcwMDMtMDNlNi00
 OTdjLWIxNWEtOTkyMGQ5ZjgxMDZjMRcwFQYDVQQDDA5zeXNfeWJkX3N5c3RlbTCC
 AiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAL00gVwx9W0K7JupLNHjKYl2
 CRJdnHbtFv6e03wZLNhlmNGUXezs6Tura8hoeHhxAZKlJ/jlN+iRaEkTWdpG6xGK
 firsoZicZjtFL33NF5i6Olo64FPJFkESrLz/PCVpJpZm+oKIzMGW4QWHOM8Kh3ny
 KPZORj/2UzGirgzcUNslfz0E3ioD5QNhxFTGyBeCqRxPdwzyBbpk5Er4c2vJtIya
 8X8ul43pKTblwJYpelVRyiZ0R2e+UI1QsuD4vjsORJovYCI7c91vUfP3v47eJtR/
 cX6WjijvS1nWpRFaxpmJUJXDCqp2SyYfv219Ev4gcjaE9BPKZB1N/9hizrGO3OB8
 GSbZEJODdhERyZK9sYwKOMRalaCsURYRfhN1uoGIykNwocBUen2vrq7IOc40Zs0Q
 2pPn/SNrxY32LseTQPkZJUSrTgJOJ/PrLOjIcMDgHcsFDihxqHjoa5/2EMuqvbgN
 upCkawXS2xVyNDaHZnEp1yHFw0L2bviGIqFXUsRfObKWWm07VQVTTfMyQLaAUpYh
 kt/GaqtUmLhisiwufgnEmxX/L0cyU3iHbfCusKsdwUJq2nvuNaJhVTkGrksl1dTt
 YMaun28ZCtGdCmkRTC3jFUSie2MHoB0woVTPYa7O9MVIRXqCeDGyYsmXaXQ1Vz60
 K8zN4GH0Cn3YCTtP2uPTAgMBAAGjNTAzMAkGA1UdEwQCMAAwCwYDVR0PBAQDAgXg
 MBkGA1UdEQQSMBCCDnN5c195YmRfc3lzdGVtMA0GCSqGSIb3DQEBCwUAA4ICAQB0
 hLyG381TBnGxbAi2DKaLkZh/ANHY7VnMUM5NwbniVy13sL7NPKg84d9zK4pJkN9O
 VHyT1DnIaFQbn6fR98x3LYQztrSveGZq9jej/7X40iHsUnpGZNnzCdJdV5y62QdY
 P73+93NrC44hIEocJXLPXXlfSHh6uqMbIuMkGFgwDg70O+pGxjQcwBI/Q3z/7wgM
 CUItl4ofX3icPX3u2CKU2KJKGXKr2LC0VX4keTgvSNTsJzlVv7l1EPQgKUl1n6Du
 1pCs0cYsTS0Lks0DJTQeeUm80+EtT586+Dc4V3aYcbihI/UKbMmhOvMLspb3H7S5
 Nlc88IUG/t/duYGcLOcCzI4Guzt/ah2B5MSAFku8bbMJnkQWSg0Hj7jTyLiPVl9y
 aqJJECW6w/imAFf2+SXB2l+RxkvzJv8hhLZMdBeJwbZ0pVyUjIjMxQuHr929TD7W
 ftw1ecwehzJm9TLYX1uFImHj7oi5vuTLQvF0NK9h59Nk3Oyi++sSYXhGKAl1fbwW
 LiTrqvjvlWUnNmfNQClBjqDrLhRv9TtCQzpFbfzw7lNvvFwiesKrxqphdrKDi2MJ
 Coss6HlYUksyA8nDGcgkGv9roQyEFiBopShJk7CrRCX3WIabZ3eBv9hp7eAebu7x
 SUAZZa680O5Po9nbR/8tzeR+IEMMZYQlT6yKZSDYHw==
 -----END CERTIFICATE-----
(33 rows)

Parent topic:SQL Commands