rovshango

## generate-pg-ssl.md

      
        
          
            
              
              1 file
            
          
          
            
              
              6 forks
            
          
          
            
              
              2 comments
            
          
          
            
              
              11 stars
            
          
        
        
          
              
          
          
            
                achesco
                / generate-pg-ssl.md
            
            
              Last active
              May 9, 2024 16:47
            
              
                Generate self-signed SSL certificates for PostgreSQL server and client
              
          
        
      
        
  
      
    CNs are important!!! -days 3650
Create a Certificate Signing Request (CN=localhost)

umask u=rw,go= && openssl req -days 3650 -new -text -nodes -subj '/C=US/ST=Massachusetts/L=Bedford/O=Personal/OU=Personal/emailAddress=example@example.com/CN=localhost' -keyout server.key -out server.csr
Generate self-signed certificate

umask u=rw,go= &amp;&amp; openssl req -days 3650 -x509 -text -in server.csr -key server.key -out server.crt