ibrahim edib kokdemir edib

More than 20 years in IT sector. Self educated.

edib / nginx.conf

Last active December 30, 2022 12:04 — forked from joshcummingsdesign/conf

NGINX config for a Jekyll site using SSL

	server {
	listen 80;
	server_name example.com www.example.com;
	return 301 https://$host$request_uri;
	}

	server {
	listen 443 ssl;

	server_name example.com www.example.com;

edib / deployment.yml

Created October 18, 2021 21:30 — forked from troyharvey/deployment.yml

Using Kubernetes envFrom for environment variables

	# Use envFrom to load Secrets and ConfigMaps into environment variables

	apiVersion: apps/v1beta2
	kind: Deployment
	metadata:
	name: mans-not-hot
	labels:
	app: mans-not-hot
	spec:
	replicas: 1

edib / main.dart

Created April 30, 2020 21:38 — forked from simoales/main.dart

A very basic main.dart file, a good starting point for any Flutter app.

	import 'package:flutter/material.dart';

	void main() => runApp(MyApp());

	class MyApp extends StatelessWidget {
	@override
	Widget build(BuildContext context) {
	return MaterialApp(
	title: 'Your app name',
	home: Scaffold(

edib / pgbackrest-kullanimi.md

Created January 26, 2020 19:15

pgBackRest Kullanımı

Bu yazıyı okumadan önce, ssh ayarlarınızı yaptığınıza emin olun
Bu yazı PostgreSQL 11 ve PgBackRest 2.15 için yazılmıştır

Kurulum

Öncelikle aşağıdaki komut ile pgbackrest kuralım:

sudo apt-get install pgbackrest -y

edib / psql_useful_stat_queries.sql

Created January 15, 2020 07:20 — forked from anvk/psql_useful_stat_queries.sql

List of some useful Stat Queries for PSQL

	--- PSQL queries which also duplicated from https://github.com/anvk/AwesomePSQLList/blob/master/README.md
	--- some of them taken from https://www.slideshare.net/alexeylesovsky/deep-dive-into-postgresql-statistics-54594192

	-- I'm not an expert in PSQL. Just a developer who is trying to accumulate useful stat queries which could potentially explain problems in your Postgres DB.

	------------
	-- Basics --
	------------

	-- Get indexes of tables

edib / haproxy.cfg

Created November 1, 2019 17:30 — forked from arkady-emelyanov/haproxy.cfg

haproxy check: postgresql is master

	# Sample haproxy postgresql master check
	#
	# haproxy listen: 5431
	# pg, instance #1 listen: 5432 (master node)
	# pg, instance #2 listen: 5433 (replica node)
	# external failover, promoting replica to master in case of failure
	# passwordless auth for user web
	# template1 database is accessible by user web
	#
	# haproxy will pass connection to postgresql master node:

Apache : Permission denied because search permissions are missing on a component of the path

edib / pglogical

Last active February 21, 2025 08:13 — forked from ratnakri/pglogical

short tutorial to setup replication using pglogical

	Edit /var/lib/postgres/data/postgresql.conf:

	# change IP on subscriber
	listen_addresses = '*'
	wal_level = logical
	shared_preload_libraries = 'pglogical'
	max_worker_processes = 16
	max_wal_senders = 16
	max_replication_slots = 16
	track_commit_timestamp = on

edib / postgres_queries_and_commands.sql

Created January 19, 2018 08:24 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

edib / PostgreSQL Composite Indexes and Sorting on Multiple Columns

Created January 2, 2018 21:47 — forked from peter/PostgreSQL Composite Indexes and Sorting on Multiple Columns

	-- Order by one indexed column (FAST)
	newsdesk_production=# explain analyze select * from pressreleases order by published_at DESC limit 100;
	QUERY PLAN
	---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
	Limit (cost=0.00..249.91 rows=100 width=1207) (actual time=26.070..716.453 rows=100 loops=1)
	-> Index Scan Backward using pressreleases_published_at_index on pressreleases (cost=0.00..964766.62 rows=386042 width=1207) (actual time=26.067..716.343 rows=100 loops=1)
	Total runtime: 716.709 ms
	(3 rows)

	- Order by two separately indexed columns (SLOW)