Igor Alov IgorAlov

## nginx-config-auth-cert-ssl.md

      
              1 file
            
          
              18 forks
            
          
              5 comments
            
          
              52 stars
            
          
                alexishida
                / nginx-config-auth-cert-ssl.md
            
            
              Last active
              April 30, 2024 12:18
            
              
                Tutorial to configure Nginx client-side SSL certificates.
              
          
    Client-side SSL

For excessively paranoid client authentication.
Original: https://gist.github.com/mtigas/952344
Convert SSL certificate from CRT format to PEM

openssl x509 -in server.crt -out server.der -outform DER
openssl x509 -in server.der -inform DER -out server.pem -outform PEM


## postgres-cheatsheet.md

      
              1 file
            
          
              1129 forks
            
          
              66 comments
            
          
              3495 stars
            
          
                Kartones
                / postgres-cheatsheet.md
            
            
              Last active
              May 16, 2024 12:40
            
              
                PostgreSQL command line cheatsheet
              
          
    PSQL

Magic words:
psql -U postgres
Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)