Andy Gelnar neoshrew

## 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

  
## DateTimeDecoder.py
#!/usr/bin/env python

# An example of decoding/encoding datetime values in JSON data in Python.
# Code adapted from: http://broadcast.oreilly.com/2009/05/pymotw-json.html

# Copyright (c) 2023, Abhinav Upadhyay
# All rights reserved.
#
# Redistribution and use in source and binary forms, with or without
# modification, are permitted provided that the following conditions are met:

## prepare.py
#!/usr/bin/env python
"""An example of cursor dealing with prepared statements.

A cursor can be used as a regular one, but has also a prepare() statement. If
prepare() is called, execute() and executemany() can be used without query: in
this case the parameters are passed to the prepared statement. The functions
also execute the prepared statement if the query is the same prepared before.

Prepared statements aren't automatically deallocated when the cursor is
deleted, but are when the cursor is closed. For long-running sessions creating
	#!/usr/bin/env python

	# An example of decoding/encoding datetime values in JSON data in Python.
	# Code adapted from: http://broadcast.oreilly.com/2009/05/pymotw-json.html

	# Copyright (c) 2023, Abhinav Upadhyay
	# All rights reserved.
	#
	# Redistribution and use in source and binary forms, with or without
	# modification, are permitted provided that the following conditions are met:
	#!/usr/bin/env python
	"""An example of cursor dealing with prepared statements.

	A cursor can be used as a regular one, but has also a prepare() statement. If
	prepare() is called, execute() and executemany() can be used without query: in
	this case the parameters are passed to the prepared statement. The functions
	also execute the prepared statement if the query is the same prepared before.

	Prepared statements aren't automatically deallocated when the cursor is
	deleted, but are when the cursor is closed. For long-running sessions creating