Skip to content

Instantly share code, notes, and snippets.

View jackie-do's full-sized avatar
🎯
Focusing

Huy Do jackie-do

🎯
Focusing
13 followers · 9 following
View GitHub Profile
@jackie-do
jackie-do / init.coffee
Last active August 29, 2017 07:20
automatic update by http://atom.io/packages/sync-settings
# initialization file (not found)
@jackie-do
jackie-do / restore_database_in_docker.md
Last active November 14, 2017 11:14
Restore a postgres database in a docker container

  1. Run the database container only. "docker container start [container name]"

  2. Connect pgAdmin to the docker container

  • Check port of the container, for example: "0.0.0.0:5432->5432/tcp"
  • Create a new connection on pgAdmn: "0.0.0.0:5432"
  1. Remove the old database
@jackie-do
jackie-do / [postgresql]_dump_and_restore.md
Last active January 4, 2018 06:51
dump and restore a table 
PGPASSWORD=mypassword pg_dump -Fc --no-acl --no-owner -h localhost -U myuser -d mydb -t mytable > mydb.dump

=== RESTORE ===

psql -U boxatwork_newqa -d boxatwork_newqa -1 -f ../../../boxie24_production/shared/db_bk/store_blog_categories_april_24.dump

psql -U boxatwork_newqa -d boxatwork_newqa -1 -f store_blog_categories_april_24.dump
@jackie-do
jackie-do / [postgresql]_set_up_read_only_user.md
Last active January 4, 2018 06:50
Set up a read-only user for Postgresql
  1. Create a linux user and set password
sudo adduser read_access

.. then enter your password for this user

  1. Limit permission for the user (option) .. normally, this user only has root permission on it's directory. (/home/read_access)

  2. Set read-only role for this user to use Postgresql

@jackie-do
jackie-do / [linux]_user_permissions_in_linux.md
Last active March 12, 2018 08:34
Grant and update user permission in Linux

Changing a file/directory ownership

  1. Check file's permissions and ownership
ll
  1. Changing A File Ownership
sudo chown :
@jackie-do
jackie-do / [postgresql]_set_up_authentications_postgresql_user.md
Last active January 4, 2018 06:50
Set up authentication methods for postgresql users
  1. Go to config directory
 cd /etc/postgresql/<postgresql_version>/main
  1. Open and update file "pg_hba.conf" to dismiss all authentications for "postgres" user (normally line 85)
  • Before updating
 local   all             postgres                                peer
@jackie-do
jackie-do / set_up_vim.md
Created January 1, 2018 01:02
Set up vim 
" display line number
:set number
" size of a hard tabstop
set tabstop=2
" always uses spaces instead of tab characters
set expandtab
" size of an "indent"
set shiftwidth=2
@jackie-do
jackie-do / [postgresql]_update_auto_increment_field_manually.md
Last active January 4, 2018 07:12
Update the sequence field (auto increment field) manually
  • Get the max current value of a field (base on current data)
SELECT MAX(<field_name>) FROM <table_name>;

example:

SELECT MAX(id) FROM blogs;
@jackie-do
jackie-do / [linux]_check_info_of_host_server.md
Last active October 2, 2018 10:18
Some commands to check the information of a server
  1. Check linux version
cat /etc/lsb-release   (for ubuntu)
cat /etc/debian_version (for debian)
cat /etc/redhat-release (CenOs/Redhat)
  1. Check disk space
@jackie-do
jackie-do / [linux]_install_redis_on_ubuntu_16.md
Last active January 21, 2018 07:48
Set up redis for Ubuntu 16.04

1) Install Prerequisites

sudo apt-get update
sudo apt-get install build-essential tcl

2) Download, Compile, and Install Redis

  • Since we won't need to keep the source code that we'll compile long term (we can always re-download it), we will build in the /tmp directory. Let's move there and download the latest stable version of Redis.