Lukas Nimmo Numbluk

## upgrade-postgres-9.5-to-9.6.md

      
              1 file
            
          
              26 forks
            
          
              14 comments
            
          
              91 stars
            
          
                delameko
                / upgrade-postgres-9.5-to-9.6.md
            
            
              Last active
              August 22, 2023 08:22
                — forked from johanndt/upgrade-postgres-9.3-to-9.5.md
            
              
                Upgrading PostgreSQL from 9.5 to 9.6 on Ubuntu 16.04
              
          
    TL;DR
Install Postgres 9.6, and then:
sudo pg_dropcluster 9.6 main --stop
sudo pg_upgradecluster 9.5 main
sudo pg_dropcluster 9.5 main

  
## PostgreSQL_index_naming.rst

      
              1 file
            
          
              34 forks
            
          
              5 comments
            
          
              178 stars
            
          
                popravich
                / PostgreSQL_index_naming.rst
            
            
              Last active
              March 25, 2024 12:42
            
              
                PostgreSQL index naming convention to remember
              
          
    The standard names for indexes in PostgreSQL are:
{tablename}_{columnname(s)}_{suffix}
where the suffix is one of the following:


pkey for a Primary Key constraint;
key for a Unique constraint;
excl for an Exclusion constraint;
idx for any other kind of index;