eznj

43 followers · 26 following

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

eznj / postgres_9_5_aws_linux.sh

Created October 19, 2016 23:13

	#!/bin/bash

	yum install -y postgresql95 postgresql95-server postgresql95-libs postgresql95-contrib postgresql95-devel

eznj / elastic_stats.sh

Created November 1, 2016 19:33

	#!/bin/bash

	# check elastic stats
	curl -XGET 'http://localhost:9200/_nodes/stats/os,process?pretty=true'

eznj / approver.yml

Last active August 4, 2020 20:14

SQS structure sign-off service

	provider: # s3, gcs
	storage_location: # s3 location, gcs location
	version: <generated schema vers>
	approvals:
	require_staging: true
	required: 2
	total: 1
	team_a: 0
	team_b: 1
	structure:

eznj / dwi.gif

Last active May 27, 2020 01:36

🌴

eznj / db_backup_commands.md

Created September 15, 2023 16:52 — forked from AtulKsol/db_backup_commands.md

Commands to backup & restore database

pg_dump is a nifty utility designed to output a series of SQL statements that describes the schema and data of your database. You can control what goes into your backup by using additional flags.
Backup: pg_dump -h localhost -p 5432 -U postgres -d mydb > backup.sql

Restore: psql -h localhost -p 5432 -U postgres -d mydb < backup.sql

-h is for host.
-p is for port.
-U is for username.
-d is for database.

OlderNewer