Skip to content

Instantly share code, notes, and snippets.

Agguro agguro

Block or report user

Report or block agguro

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
agguro / sources.list
Created Nov 18, 2018
Ubuntu 18.04 Bionic default /etc/apt/sources.list
View sources.list
#deb cdrom:[Ubuntu 18.04 LTS _Bionic Beaver_ - Release amd64 (20180426)]/ bionic main restricted
# See for how to upgrade to
# newer versions of the distribution.
deb bionic main restricted
# deb-src bionic main restricted
## Major bug fix updates produced after the final release of the
## distribution.
deb bionic-updates main restricted
agguro / psql_encoding.sql
Created Oct 24, 2018 — forked from turboladen/psql_encoding.sql
Script for dealing with creating Postgres databases that complain with: ``` PG::InvalidParameterValue: ERROR: encoding UTF8 does not match locale en_US DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1. ``` ...when trying to create the production DB. Taken from:…
View psql_encoding.sql
sudo su postgres
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';
You can’t perform that action at this time.