Babatope Ajepe ajepe

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

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ajepe
                / upgrade-postgres-9.6-to-10.md
            
            
              Created
              November 8, 2019 14:37
                — forked from mdesantis/upgrade-postgres-9.6-to-10.md
            
              
                Upgrading PostgreSQL from 9.6 to 10 on Ubuntu 16.04
              
          
    TL;DR
Install Postgres 10, and then:
sudo pg_dropcluster 10 main --stop
sudo pg_upgradecluster 9.6 main
sudo pg_dropcluster 9.6 main

  
## kill all
kill $(ps aux | grep 'odoo' | awk '{print $2}')

## constraint.sql
SELECT con.* FROM pg_catalog.pg_constraint con INNER JOIN pg_catalog.pg_class rel ON rel.oid = con.conrelid INNER JOIN pg_catalog.pg_namespace nsp ON nsp.oid = connamespace WHERE nsp.nspname = 'public' AND rel.relname = 'product_product';

## database.sql
select t1.datname AS db_name,
       pg_size_pretty(pg_database_size(t1.datname)) as db_size
from pg_database t1
order by pg_database_size(t1.datname) desc;

## Wget Crawl
wget -P build -nv -nH -r -E localhost:3000

## nginx
#odoo server
upstream odoo {
 server 127.0.0.1:8069;
}
upstream odoochat {
 server 127.0.0.1:8072;
}

# http -> https
# server {

## md
{
"070010": "ABBEY MORTGAGE BANK-070010",
"044": "ACCESS BANK PLC-044",
"323": "AccessMobile-100013",
"090134": "ACCION MICROFINANCE BANK-090134",
"090160": "ADDOSSER MICROFINANCE BANK-090160",
"100028": "AG MORTGAGE BANK PLC-100028",
"090133": "AL-BARAKAH MICROFINANCE BANK-090133",
"090180": "AMJU UNIQUE MICROFINANCE BANK-090180",
"090116": "AMML MFB-090116",

## gist:fdb8851684a058f254d4883bfb7ff79a

curl -gkvLI -H 'User-Agent: updown.io daemon 2.2' -H 'Accept: */*' -H 'Connection: Close' -H 'Accept-Language: en' -m 30 --connect-timeout 5 http://odoosme.ng

## random number
''.join([str(random.randint(0, 9)) for _ in range(11)])


def otp(length=5, lowerband=1, upperband=9):
    return ''.join(
        random.sample([str(random.randint(lowerband, upperband))
                       for _ in range(upperband+1)], length)
    )

## gist:bb824f52817d6c9958d0ece0097c727b
<?php
/**
 * Created by PhpStorm.
 * User: Raihan
 * Date: 10-Jul-17
 * Time: 4:37 AM
 */

class CryptOpenssl{
    private $hash;
	select t1.datname AS db_name,
	pg_size_pretty(pg_database_size(t1.datname)) as db_size
	from pg_database t1
	order by pg_database_size(t1.datname) desc;
	#odoo server
	upstream odoo {
	server 127.0.0.1:8069;
	}
	upstream odoochat {
	server 127.0.0.1:8072;
	}

	# http -> https
	# server {
	{
	"070010": "ABBEY MORTGAGE BANK-070010",
	"044": "ACCESS BANK PLC-044",
	"323": "AccessMobile-100013",
	"090134": "ACCION MICROFINANCE BANK-090134",
	"090160": "ADDOSSER MICROFINANCE BANK-090160",
	"100028": "AG MORTGAGE BANK PLC-100028",
	"090133": "AL-BARAKAH MICROFINANCE BANK-090133",
	"090180": "AMJU UNIQUE MICROFINANCE BANK-090180",
	"090116": "AMML MFB-090116",

	curl -gkvLI -H 'User-Agent: updown.io daemon 2.2' -H 'Accept: /' -H 'Connection: Close' -H 'Accept-Language: en' -m 30 --connect-timeout 5 http://odoosme.ng
	''.join([str(random.randint(0, 9)) for _ in range(11)])


	def otp(length=5, lowerband=1, upperband=9):
	return ''.join(
	random.sample([str(random.randint(lowerband, upperband))
	for _ in range(upperband+1)], length)
	)
	<?php
	/**
	* Created by PhpStorm.
	* User: Raihan
	* Date: 10-Jul-17
	* Time: 4:37 AM
	*/

	class CryptOpenssl{
	private $hash;