utkonos

## django-postgresql-15.md

      
        
          
            
              
              1 file
            
          
          
            
              
              1 fork
            
          
          
            
              
              6 comments
            
          
          
            
              
              25 stars
            
          
        
        
          
              
          
          
            
                axelbdt
                / django-postgresql-15.md
            
            
              Last active
              April 26, 2024 08:03
            
              
                # Django and PostgreSQL 15, the rules have changed
              
          
        
      
        
  
      
    Django and PostgreSQL 15, the rules have changed

Postgres 15 is just out, and while there is a lot to love about this new release, you're in for a surprise if you try to set it up with Django following tutorials like this one.
The reason is stated in the release announcement:

Remove PUBLIC creation permission on the public schema (Noah Misch)
The new default is one of the secure schema usage patterns that Section 5.9.6 has recommended...

Provided your web app doesn't access your database as a superuser (it shouldn't) and uses a dedicated user, it is not allowed to use the public schema anymore. You have to create one for this specific user, and the next section will