Start background writer during archive recovery. Background writer now performs
[PostgreSQL.git] / contrib / pgcrypto / expected / sha2.out
blob2df5a0d0f997c8049b4a80d3e4c4a860fe583b48
1 --
2 -- SHA2 family
3 --
4 -- SHA224
5 SELECT encode(digest('', 'sha224'), 'hex');
6                           encode                          
7 ----------------------------------------------------------
8  d14a028c2a3a2bc9476102bb288234c415a2b01f828ea62ac5b3e42f
9 (1 row)
11 SELECT encode(digest('a', 'sha224'), 'hex');
12                           encode                          
13 ----------------------------------------------------------
14  abd37534c7d9a2efb9465de931cd7055ffdb8879563ae98078d6d6d5
15 (1 row)
17 SELECT encode(digest('abc', 'sha224'), 'hex');
18                           encode                          
19 ----------------------------------------------------------
20  23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7
21 (1 row)
23 SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha224'), 'hex');
24                           encode                          
25 ----------------------------------------------------------
26  75388b16512776cc5dba5da1fd890150b0c6455cb4f58b1952522525
27 (1 row)
29 SELECT encode(digest('12345678901234567890123456789012345678901234567890123456789012345678901234567890', 'sha224'), 'hex');
30                           encode                          
31 ----------------------------------------------------------
32  b50aecbe4e9bb0b57bc5f3ae760a8e01db24f203fb3cdcd13148046e
33 (1 row)
35 -- SHA256
36 SELECT encode(digest('', 'sha256'), 'hex');
37                               encode                              
38 ------------------------------------------------------------------
39  e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
40 (1 row)
42 SELECT encode(digest('a', 'sha256'), 'hex');
43                               encode                              
44 ------------------------------------------------------------------
45  ca978112ca1bbdcafac231b39a23dc4da786eff8147c4e72b9807785afee48bb
46 (1 row)
48 SELECT encode(digest('abc', 'sha256'), 'hex');
49                               encode                              
50 ------------------------------------------------------------------
51  ba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad
52 (1 row)
54 SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha256'), 'hex');
55                               encode                              
56 ------------------------------------------------------------------
57  248d6a61d20638b8e5c026930c3e6039a33ce45964ff2167f6ecedd419db06c1
58 (1 row)
60 SELECT encode(digest('12345678901234567890123456789012345678901234567890123456789012345678901234567890', 'sha256'), 'hex');
61                               encode                              
62 ------------------------------------------------------------------
63  f371bc4a311f2b009eef952dd83ca80e2b60026c8e935592d0f9c308453c813e
64 (1 row)
66 -- SHA384
67 SELECT encode(digest('', 'sha384'), 'hex');
68                                               encode                                              
69 --------------------------------------------------------------------------------------------------
70  38b060a751ac96384cd9327eb1b1e36a21fdb71114be07434c0cc7bf63f6e1da274edebfe76f65fbd51ad2f14898b95b
71 (1 row)
73 SELECT encode(digest('a', 'sha384'), 'hex');
74                                               encode                                              
75 --------------------------------------------------------------------------------------------------
76  54a59b9f22b0b80880d8427e548b7c23abd873486e1f035dce9cd697e85175033caa88e6d57bc35efae0b5afd3145f31
77 (1 row)
79 SELECT encode(digest('abc', 'sha384'), 'hex');
80                                               encode                                              
81 --------------------------------------------------------------------------------------------------
82  cb00753f45a35e8bb5a03d699ac65007272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358baeca134c825a7
83 (1 row)
85 SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha384'), 'hex');
86                                               encode                                              
87 --------------------------------------------------------------------------------------------------
88  3391fdddfc8dc7393707a65b1b4709397cf8b1d162af05abfe8f450de5f36bc6b0455a8520bc4e6f5fe95b1fe3c8452b
89 (1 row)
91 SELECT encode(digest('abcdefghbcdefghicdefghijdefghijkefghijklfghijklmghijklmnhijklmnoijklmnopjklmnopqklmnopqrlmnopqrsmnopqrstnopqrstu', 'sha384'), 'hex');
92                                               encode                                              
93 --------------------------------------------------------------------------------------------------
94  09330c33f71147e83d192fc782cd1b4753111b173b3b05d22fa08086e3b0f712fcc7c71a557e2db966c3e9fa91746039
95 (1 row)
97 SELECT encode(digest('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz', 'sha384'), 'hex');
98                                               encode                                              
99 --------------------------------------------------------------------------------------------------
100  3d208973ab3508dbbd7e2c2862ba290ad3010e4978c198dc4d8fd014e582823a89e16f9b2a7bbc1ac938e2d199e8bea4
101 (1 row)
103 -- SHA512
104 SELECT encode(digest('', 'sha512'), 'hex');
105                                                               encode                                                              
106 ----------------------------------------------------------------------------------------------------------------------------------
107  cf83e1357eefb8bdf1542850d66d8007d620e4050b5715dc83f4a921d36ce9ce47d0d13c5d85f2b0ff8318d2877eec2f63b931bd47417a81a538327af927da3e
108 (1 row)
110 SELECT encode(digest('a', 'sha512'), 'hex');
111                                                               encode                                                              
112 ----------------------------------------------------------------------------------------------------------------------------------
113  1f40fc92da241694750979ee6cf582f2d5d7d28e18335de05abc54d0560e0f5302860c652bf08d560252aa5e74210546f369fbbbce8c12cfc7957b2652fe9a75
114 (1 row)
116 SELECT encode(digest('abc', 'sha512'), 'hex');
117                                                               encode                                                              
118 ----------------------------------------------------------------------------------------------------------------------------------
119  ddaf35a193617abacc417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a2192992a274fc1a836ba3c23a3feebbd454d4423643ce80e2a9ac94fa54ca49f
120 (1 row)
122 SELECT encode(digest('abcdbcdecdefdefgefghfghighijhijkijkljklmklmnlmnomnopnopq', 'sha512'), 'hex');
123                                                               encode                                                              
124 ----------------------------------------------------------------------------------------------------------------------------------
125  204a8fc6dda82f0a0ced7beb8e08a41657c16ef468b228a8279be331a703c33596fd15c13b1b07f9aa1d3bea57789ca031ad85c7a71dd70354ec631238ca3445
126 (1 row)
128 SELECT encode(digest('abcdefghbcdefghicdefghijdefghijkefghijklfghijklmghijklmnhijklmnoijklmnopjklmnopqklmnopqrlmnopqrsmnopqrstnopqrstu', 'sha512'), 'hex');
129                                                               encode                                                              
130 ----------------------------------------------------------------------------------------------------------------------------------
131  8e959b75dae313da8cf4f72814fc143f8f7779c6eb9f7fa17299aeadb6889018501d289e4900f7e4331b99dec4b5433ac7d329eeb6dd26545e96e55b874be909
132 (1 row)
134 SELECT encode(digest('abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz', 'sha512'), 'hex');
135                                                               encode                                                              
136 ----------------------------------------------------------------------------------------------------------------------------------
137  930d0cefcb30ff1133b6898121f1cf3d27578afcafe8677c5257cf069911f75d8f5831b56ebfda67b278e66dff8b84fe2b2870f742a580d8edb41987232850c9
138 (1 row)