Skip to content

Instantly share code, notes, and snippets.

@krishchow
krishchow / controllerconfig.yaml
Last active Jul 26, 2022
Openshift Crossplane SecurityContext
View controllerconfig.yaml
apiVersion: pkg.crossplane.io/v1alpha1
kind: ControllerConfig
metadata:
name: openshift-config
namespace: crossplane-system
spec:
securityContext: {}
podSecurityContext: {}
---
apiVersion: pkg.crossplane.io/v1
@cderv
cderv / 00-New setup.md
Last active Sep 19, 2022
New computer setup
View 00-New setup.md
# installed by winget
winget install PowerShell-Preview
winget install git
git config --global user.name "Christophe Dervieux"
git config --global user.email christophe.dervieux@gmail.com
winget install rstudio
winget install vscode
winget install -e R
winget install Github.GithubDesktop
@syafiqfaiz
syafiqfaiz / how-to-copy-aws-rds-to-local.md
Last active Sep 24, 2022
How to copy production database on AWS RDS(postgresql) to local development database.
View how-to-copy-aws-rds-to-local.md
  1. Change your database RDS instance security group to allow your machine to access it.
    • Add your ip to the security group to acces the instance via Postgres.
  2. Make a copy of the database using pg_dump
    • $ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>
    • you will be asked for postgressql password.
    • a dump file(.sql) will be created
  3. Restore that dump file to your local database.
    • but you might need to drop the database and create it first
    • $ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>
  • the database is restored