Dmitry Kustov dmitrykustov

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

      
              1 file
            
          
              15 forks
            
          
              24 comments
            
          
              73 stars
            
          
                dmitrykustov
                / upgrade-postgres-9.4-to-9.6.md
            
            
              Last active
              August 8, 2022 17:52
                — forked from dideler/upgrade-postgres-9.3-to-9.4.md
            
              
                Upgrading PostgreSQL from 9.4 to 9.6 on Debian Jessie
              
          
    To use the most modern version of Postgres software we need to add postgresql repository. Edit /etc/apt/sources.list or create /etc/apt/sources.list.d/pgdg.list and add there a line: deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main
Then import the repository signing key, and update the package lists:
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
Install a new version of PostgreSQL server.
Once the Debian upgrade finished, I used dpkg-query -l postgresql* to check which versions of postgres I have installed.

  
## change_db_owner.sh
#!/bin/bash

usage()
{
cat << EOF
usage: $0 options

This script set ownership for all table, sequence and views for a given database

Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto
	#!/bin/bash

	usage()
	{
	cat << EOF
	usage: $0 options

	This script set ownership for all table, sequence and views for a given database

	Credit: Based on http://stackoverflow.com/a/2686185/305019 by Alex Soto