Babatope Ajepe ajepe

## psql_encoding.markdown

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              0 stars
            
          
                ajepe
                / psql_encoding.markdown
            
            
              Created
              August 8, 2018 10:44
                — forked from joshteng/psql_encoding.markdown
            
              
                This solves Postgresql's encoding issue (happened to me when running postgres on my vagrant box) The error happens when trying to create db "rake db:create": Error message: "encoding UTF8 does not match locale en_US; the chosen LC_CTYPE setting requires encoding LATIN1"
              
          
    sudo su postgres
psql
update pg_database set datistemplate=false where datname='template1';
drop database Template1;
create database template1 with owner=postgres encoding='UTF-8' lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;
update pg_database set datistemplate=true where datname='template1';

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

  
## odoo-requests
#!/bin/sh
#%# family=manual
#%# capabilities=autoconf suggest

# Munin plugin for transactions/minute
case $1 in
    autoconf)
        exit 0
        ;;
    suggest)

## Installing wkhtmltopdf 0.12.4, 0.12.5 - Ubuntu 16.04 x64, 0.12.5 - Ubuntu 18.04 x64, 0.12.5 - MacOS High Sierra 10.13.6.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ajepe
                / Installing wkhtmltopdf 0.12.4, 0.12.5 - Ubuntu 16.04 x64, 0.12.5 - Ubuntu 18.04 x64, 0.12.5 - MacOS High Sierra 10.13.6.md
            
            
              Created
              December 12, 2019 16:51
                — forked from srmds/Installing wkhtmltopdf 0.12.6, 0.12.5, 0.12.4 - Ubuntu 22.06 , 18.04, 16.04 x64, 0.12.6 - MacOS  Ventura 13.6.md
            
              
                Installing wkhtmltopdf 0.12.4, 0.12.5 - Ubuntu 16.04 x64, 0.12.5 - Ubuntu 18.04 x64 - 0.12.5 - macOS Catalina 10.15
              
          
    You can check here for getting the latest version.
Change the wget url to download newer versions.


Install instructions


wkhtmltopdf 0.12.4 - Ubuntu 16.04 x64


wkhtmltopdf 0.12.5 - Ubuntu 16.04 x64


wkhtmltopdf 0.12.5 - Ubuntu 18.04 x64


wkhtmltopdf 0.12.5 - macOS Mojave 10.14 & Catalina 10.15


Install verification


## main.py
##############################################################################
#
#    Author: Miku Laitinen / Avoin.Systems
#    Copyright 2019 Avoin.Systems
#
#    This program is free software: you can redistribute it and/or modify
#    it under the terms of the GNU Affero General Public License as
#    published by the Free Software Foundation, either version 3 of the
#    License, or (at your option) any later version.
#

## Virtual Box Host Only Static IP.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ajepe
                / Virtual Box Host Only Static IP.md
            
            
              Created
              June 14, 2020 14:22
                — forked from pjdietz/Virtual Box Host Only Static IP.md
            
              
                VirtualBox Host-Only Adapter with Static IP
              
          
    VirtualBox Host-Only Static IP

My typical setup for a development box in VirtualBox uses two NICs. The first uses NAT to allow the box to communicate with the outside world through my host computer’s network connection. (NAT is the default, so shouldn't require any setup.) The second is a "host-only" connection that allows my host and guest to interact.
To create a host-only connection in VirtualBox, start by opening the preferences in VirtualBox. Go to the "Network" tab, and addd a Host-only Network. Modify the host-only network, and disable DHCP. Make a note of the IP address. (Feel free to set the IP address as well, if you like.)
Next, assign this host-only adapter to the virtual machine. Select the VM and press "Settings". Go to the "Network" tab, and select "Adpater 2". Enable the adapter, set it to a "Host-only Adapter", and select the adpater you created above.
Temporary


## README.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                ajepe
                / README.md
            
            
              Created
              August 22, 2020 19:56
                — forked from clhenrick/README.md
            
              
                PostgreSQL & PostGIS cheatsheet (a work in progress)
              
          
    PostgreSQL & PostGIS Cheatsheet

This is a collection of information on PostgreSQL and PostGIS for what I tend to use most often.
TOC


Installing Postgres & PostGIS
Using Postgres on the command line: PSQL
Importing Data into Postgres
Exporting Data from Postgres
Joining Tables


## migrate.py
#!/usr/bin/env python2

import os
import sys
import StringIO
import psycopg2
import psycopg2.extensions
from optparse import OptionParser
from ConfigParser import SafeConfigParser
try:

## install-wkhtmltopdf.sh
wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.4/wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
tar xvf wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
mv wkhtmltox/bin/wkhtmlto* /usr/bin/
ln -nfs /usr/bin/wkhtmltopdf /usr/local/bin/wkhtmltopdf

## postgres_bacnkup
# List databases
sudo su postgres
psql
\list

# Create a compressed backup
sudo su postgres
pg_dump -Fc <database_name> > <file>

# Example
	#!/bin/sh
	#%# family=manual
	#%# capabilities=autoconf suggest

	# Munin plugin for transactions/minute
	case $1 in
	autoconf)
	exit 0
	;;
	suggest)
	##############################################################################
	#
	# Author: Miku Laitinen / Avoin.Systems
	# Copyright 2019 Avoin.Systems
	#
	# This program is free software: you can redistribute it and/or modify
	# it under the terms of the GNU Affero General Public License as
	# published by the Free Software Foundation, either version 3 of the
	# License, or (at your option) any later version.
	#
	#!/usr/bin/env python2

	import os
	import sys
	import StringIO
	import psycopg2
	import psycopg2.extensions
	from optparse import OptionParser
	from ConfigParser import SafeConfigParser
	try:
	wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.4/wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
	tar xvf wkhtmltox-0.12.4_linux-generic-amd64.tar.xz
	mv wkhtmltox/bin/wkhtmlto* /usr/bin/
	ln -nfs /usr/bin/wkhtmltopdf /usr/local/bin/wkhtmltopdf
	# List databases
	sudo su postgres
	psql
	\list

	# Create a compressed backup
	sudo su postgres
	pg_dump -Fc <database_name> > <file>

	# Example