emrahoruc

Find pg_hba.conf file location

bash-4.1$ psql
psql (8.4.20)
Type "help" for help.

postgres=# SHOW hba_file;
            hba_file             

emrahoruc

add PostgreSQL 13 repository

sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

sudo yum -y update

install PostgreSQL 13 packages

sudo yum -y install postgresql13 postgresql13-server

After fresh installation of PostgreSQL 13 on CentOS 7 initialization is required.

sudo /usr/pgsql-13/bin/postgresql-13-setup initdb

emrahoruc

-- Set Id Seq
SELECT setval('tablename_id_seq', (SELECT MAX(id) FROM public.tablename));

-- Log in
sudo -i -u postgres  
psql dbname username  

-- Backup
sudo -u postgres pg_dump -U postgres -d mydb -F c -f /tmp/mydb.backup

emrahoruc

Compress

tar -cvzf backup.tgz /home/user/project

Extract

tar -xvzf backup.tgz

Copy Lots And Large Files

rsync -avhW --no-compress --progress --exclude 'file_or_dir' /source/ /target/

See Largest 20 Folders

emrahoruc

How to Install GraalVM Community Edition on Linux

Note: Tested on Fedora only

1. Download the new release of GraalVM and unpack it anywhere in your filesystem:

$ tar -xvzf graalvm-ce-1.0.0-rc14-linux-amd64.tar.gz

emrahoruc

package coolphpobfuscator;

import java.io.File;
import java.io.FileNotFoundException;
import java.math.BigInteger;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.Scanner;

emrahoruc

var mediaJSON = { "categories" : [ { "name" : "Movies",
        "videos" : [ 
		    { "description" : "Big Buck Bunny tells the story of a giant rabbit with a heart bigger than himself. When one sunny day three rodents rudely harass him, something snaps... and the rabbit ain't no bunny anymore! In the typical cartoon tradition he prepares the nasty rodents a comical revenge.\n\nLicensed under the Creative Commons Attribution license\nhttp://www.bigbuckbunny.org",
              "sources" : [ "http://commondatastorage.googleapis.com/gtv-videos-bucket/sample/BigBuckBunny.mp4" ],
              "subtitle" : "By Blender Foundation",
              "thumb" : "images/BigBuckBunny.jpg",
              "title" : "Big Buck Bunny"
            },
            { "description" : "The first Blender Open Movie from 2006",
              "sources" : [ "http://commondatastorage.googleapis.com/gtv-videos-bucket/sample/ElephantsDream.mp4" ],

emrahoruc

<?php
# Source: https://codeigniter.com/userguide3/installation/upgrade_303.html

$config['base_url'] = ['domain1.tld', 'domain2.tld'];

if (in_array($_SERVER['HTTP_HOST'], $config['base_url'], true)) {
    $domain = $_SERVER['HTTP_HOST'];
} else {
    $domain = $config['base_url'][0];
}

emrahoruc

{
    // Use IntelliSense to learn about possible attributes.
    // Hover to view descriptions of existing attributes.
    // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
    "version": "0.2.0",
    "configurations": [
        {
            "name": "Listen for Xdebug",
            "type": "php",
            "request": "launch",

emrahoruc

#!/bin/bash
sudo apt-get update
sudo apt-get --only-upgrade install google-chrome-stable