4259 links
  • Arnaud's links
  • Home
  • RSS Feed
  • Tag cloud
  • Login
newest first
  • pgadmin - PostgreSQL, display role members - Database Administrators Stack Exchange

    SELECT r.rolname as username,r1.rolname as "role"
    FROM pg_catalog.pg_roles r LEFT JOIN pg_catalog.pg_auth_members m
    ON (m.member = r.oid)
    LEFT JOIN pg_roles r1 ON (m.roleid=r1.oid)
    WHERE r.rolcanlogin
    ORDER BY 1;

    August 12, 2019 - permalink - https://dba.stackexchange.com/questions/136858/postgresql-display-role-members
    permissions postgresql role
  • terraform-aws-ecs-scheduled-task/main.tf at master · dxw/terraform-aws-ecs-scheduled-task · GitHub

    TIL : les ECS scheduled tasks sont en fait trigger par cloudwatch

    August 12, 2019 - permalink - https://github.com/dxw/terraform-aws-ecs-scheduled-task/blob/master/main.tf
    ecs task
  • Downloads & Changelog
    August 12, 2019 - permalink - https://omnidb.org/en/downloads-en
    client postgresql
  • arl/tmux-gitbar: Git in your tmux status bar
    August 10, 2019 - permalink - https://github.com/arl/tmux-gitbar#installation
    git tmux
  • Note: ssm links

    https://docs.aws.amazon.com/systems-manager/latest/userguide/ssm-agent.html

    https://docs.aws.amazon.com/systems-manager/latest/userguide/session-manager-working-with-sessions-start.html#sessions-start-ssh

    https://docs.aws.amazon.com/systems-manager/latest/userguide/session-manager-getting-started-enable-ssh-connections.html

    August 10, 2019 - permalink - https://links.infomee.fr/shaare/Hgv05w
    aws ssm
  • Meld

    à tester

    August 10, 2019 - permalink - https://meldmerge.org/
    diff git merge tool
  • Managing PostgreSQL users and roles | AWS Database Blog

    A faire en superuser:

    -- Revoke privileges from 'public' role
    REVOKE CREATE ON SCHEMA public FROM PUBLIC;
    REVOKE ALL ON DATABASE mydatabase FROM PUBLIC;

    -- Create schema
    CREATE SCHEMA myschema

    -- Read-only role
    CREATE ROLE readonly;
    GRANT CONNECT ON DATABASE mydatabase TO readonly;
    GRANT USAGE ON SCHEMA myschema TO readonly;
    GRANT SELECT ON ALL TABLES IN SCHEMA myschema TO readonly;
    ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT ON TABLES TO readonly;

    -- Read/write role
    CREATE ROLE readwrite;
    GRANT CONNECT ON DATABASE mydatabase TO readwrite;
    GRANT USAGE, CREATE ON SCHEMA myschema TO readwrite;
    GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA myschema TO readwrite;
    ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO readwrite;
    GRANT USAGE ON ALL SEQUENCES IN SCHEMA myschema TO readwrite;
    ALTER DEFAULT PRIVILEGES IN SCHEMA myschema GRANT USAGE ON SEQUENCES TO readwrite;

    -- Users creation
    CREATE USER reporting_user1 WITH PASSWORD 'some_secret_passwd';
    CREATE USER reporting_user2 WITH PASSWORD 'some_secret_passwd';
    CREATE USER app_user1 WITH PASSWORD 'some_secret_passwd';
    CREATE USER app_user2 WITH PASSWORD 'some_secret_passwd';

    -- Grant privileges to users
    GRANT readonly TO reporting_user1;
    GRANT readonly TO reporting_user2;
    GRANT readwrite TO app_user1;
    GRANT readwrite TO app_user2;

    August 3, 2019 - permalink - https://aws.amazon.com/fr/blogs/database/managing-postgresql-users-and-roles/
    aws postgresql rds
  • Enable or Disable Close Tab by Double Click in Firefox | Tutorials

    about:config
    browser.tabs.closeTabByDblclick

    August 2, 2019 - permalink - https://www.tenforums.com/tutorials/113005-enable-disable-close-tab-double-click-firefox.html
    firefox
  • avsm/docker-ssh-agent-forward: Forward SSH agent socket into a container
    July 30, 2019 - permalink - https://github.com/avsm/docker-ssh-agent-forward
    docker mac mount ssh
  • GitHub - scrooloose/nerdtree: A tree explorer plugin for vim.

    Comment j'ai fait pour me passer de nerdtree?

    July 29, 2019 - permalink - https://github.com/scrooloose/nerdtree
    vim
  • Iterm Themes - Color Schemes and Themes for Iterm2
    July 28, 2019 - permalink - https://iterm2colorschemes.com/
    color iterm2 mac
  • GitHub - tmux-plugins/tmux-continuum: Continuous saving of tmux environment. Automatic restore when tmux is started. Automatic tmux start when computer is turned on.

    Encore mieux que tmux-resurrect

    July 25, 2019 - permalink - https://github.com/tmux-plugins/tmux-continuum
    tmux
  • How to use custom workflows and restrict actions by username · Issue #701 · runatlantis/atlantis · GitHub

    https://unix.stackexchange.com/questions/111508/bash-test-if-word-is-in-set

    July 24, 2019 - permalink - https://github.com/runatlantis/atlantis/issues/701
    atlantis terraform
  • AWS Fargate Pricing Calculator

    0,25 vCPU + 0,5GB = 9,010$ (1 month)

    July 23, 2019 - permalink - http://fargate-pricing-calculator.site.s3-website-us-east-1.amazonaws.com/
    aws fargate
  • 1x Engineer
    July 18, 2019 - permalink - https://1x.engineer/
    engineer
  • Terraform: terraform_remote_state - Terraform by HashiCorp
    July 12, 2019 - permalink - https://www.terraform.io/docs/providers/terraform/d/remote_state.html
    aws data terraform
  • PostgreSQL: Documentation: 11: 34.15. The Password File
    July 12, 2019 - permalink - https://www.postgresql.org/docs/current/libpq-pgpass.html
    postgresql
  • Voici l'emplacement des 8 fontaines d’eau pétillante gratuites de Paris - Carnets de Week-Ends
    July 8, 2019 - permalink - https://www.carnetsdeweekends.fr/voici-lemplacement-8-fontaines-deau-petillante-gratuites-de-paris/
    eau paris
  • Announcing Amazon VPC Traffic Mirroring for Amazon EC2 Instances
    July 3, 2019 - permalink - https://aws.amazon.com/about-aws/whats-new/2019/06/announcing-amazon-vpc-traffic-mirroring-for-amazon-ec2-instances/
    aws mirror network
  • Note: postgre

    voir obsidian "Postgresql pg survival"

    July 3, 2019 - permalink - https://links.infomee.fr/shaare/IImegQ
    postgresql
  • AWS Systems Manager Session Manager - AWS Systems Manager

    interessant

    June 28, 2019 - permalink - https://docs.aws.amazon.com/systems-manager/latest/userguide/session-manager.html
    aws ssh ssm
  • Frequently Asked Questions — Ansible Documentation
    June 27, 2019 - permalink - https://docs.ansible.com/ansible/latest/reference_appendices/faq.html#how-do-i-configure-a-jump-host-to-access-servers-that-i-have-no-direct-access-to
    ansible bastion jump ssh
  • Secure your instances with multi-factor authentication | AWS Startups Blog
    June 12, 2019 - permalink - https://aws.amazon.com/fr/blogs/startups/securing-ssh-to-amazon-ec2-linux-hosts/
    aws mfa ssh
  • coolaj86/browser-authenticator.js: Two- / Multi- Factor Authenication (2FA / MFA / OTP) for browser JavaScript - browser-authenticator.js - CoolAJ86 on GIT
    June 12, 2019 - permalink - https://git.coolaj86.com/coolaj86/browser-authenticator.js
    auth authenticator google mfa
  • Git Tree Compare - Visual Studio Marketplace
    June 7, 2019 - permalink - https://marketplace.visualstudio.com/items?itemName=letmaik.git-tree-compare
    git tree
  • GitHub - picheli20/github-code-tree: Show the source tree on the github PR
    June 7, 2019 - permalink - https://github.com/picheli20/github-code-tree
    github tree
  • wercker/stern: ⎈ Multi pod and container log tailing for Kubernetes
    June 7, 2019 - permalink - https://github.com/wercker/stern
    k8s log
  • Creating a permanent link to a code snippet - GitHub Help
    June 6, 2019 - permalink - https://help.github.com/en/articles/creating-a-permanent-link-to-a-code-snippet
    github permalink
  • GitHub - pre-commit/pre-commit-hooks: Some out-of-the-box hooks for pre-commit
    June 6, 2019 - permalink - https://github.com/pre-commit/pre-commit-hooks
    git hook pre-commit
  • GitHub - antonbabenko/pre-commit-terraform: pre-commit git hooks to take care of Terraform configurations
    June 6, 2019 - permalink - https://github.com/antonbabenko/pre-commit-terraform
    git hook pre-commit
  • pre-commit

    Git hook scripts are useful for identifying simple issues before submission to code review. We run our hooks on every commit to automatically point out issues in code such as missing semicolons, trailing whitespace, and debug statements. By pointing these issues out before code review, this allows a code reviewer to focus on the architecture of a change while not wasting time with trivial style nitpicks.

    June 6, 2019 - permalink - https://pre-commit.com/
    git hook pre-commit
  • GitHub - ovity/octotree: GitHub code tree on steroids
    June 4, 2019 - permalink - https://github.com/ovity/octotree
    github tree
  • Mozilla releases Firefox Lockwise (formerly Lockbox) add-on - gHacks Tech News

    à tester

    June 4, 2019 - permalink - https://www.ghacks.net/2019/05/29/mozilla-releases-firefox-lockwise-formerly-lockbox-add-on/
    firefox password
  • Terraform `cidrsubnet` Deconstructed | It's Just Code
    May 31, 2019 - permalink - http://blog.itsjustcode.net/blog/2017/11/18/terraform-cidrsubnet-deconstructed/
    network surbnet terraform
  • Tutorial: Delegate Access Across AWS Accounts Using IAM Roles - AWS Identity and Access Management

    Gestion multi compte aws

    May 30, 2019 - permalink - https://docs.aws.amazon.com/IAM/latest/UserGuide/tutorial_cross-account-with-roles.html
    account aws
  • Les meilleurs freelances tech et data à la demande | Comet
    May 25, 2019 - permalink - https://comet.co/
    freelance
  • Deploying (AWS EC2) - Armory Spinnaker Documentation

    additional-launch-block-devices

    May 22, 2019 - permalink - https://docs.armory.io/spinnaker-user-guides/deploying/#additional-launch-block-devices
    device ebs spinnaker
  • The XY Problem
    May 22, 2019 - permalink - http://xyproblem.info/
    ask problem question solution
  • Velero
    May 21, 2019 - permalink - https://velero.io/
    backup k8s
  • GitHub - weskerfoot/DeleteFB: Selenium script to delete all of your Facebook wall posts
    May 21, 2019 - permalink - https://github.com/weskerfoot/DeleteFB
    facebook
  • tmux in practice: iTerm2 and tmux – freeCodeCamp.org

    pour binder ctrl tab et shift ctrl tab pour avec next/previous window il faut un peu de bricolage :

    Dans iterm on peut créer des bindings :
    ctrl + tab --> Send hexa -> 0x01 0x6e
    shift ctrl tab --> Send hexa -> 0x01 0x70

    Ces codes hexa correspondent à l'enchainement "ctrl+a n" et "ctrl+a p"

    (tools utile : showkey -a sur linux)

    May 21, 2019 - permalink - https://medium.freecodecamp.org/tmux-in-practice-iterm2-and-tmux-integration-7fb0991c6c01
    iterm mac tmux
  • Security for Elasticsearch is now free | Elastic Blog

    nice!

    May 21, 2019 - permalink - https://www.elastic.co/blog/security-for-elasticsearch-is-now-free
    es
  • GitHub - mlabouardy/komiser: Cloud Environment Inspector 👮
    May 20, 2019 - permalink - https://github.com/mlabouardy/komiser
    aws cost
  • Amazon EKS Simplifies Kubernetes Cluster Authentication
    May 20, 2019 - permalink - https://aws.amazon.com/about-aws/whats-new/2019/05/amazon-eks-simplifies-kubernetes-cluster-authentication/
    eks
  • KubeContext/README.md at master · turkenh/KubeContext · GitHub
    May 18, 2019 - permalink - https://github.com/turkenh/KubeContext/blob/master/README.md
    k8s mac
  • Kubernetes Operator FAQ – CloudARK – Medium
    May 17, 2019 - permalink - https://medium.com/@cloudark/kubernetes-operator-faq-e018132c6ea2
    crd k8s operator
  • An Introduction to the Z Shell - Aliasing

    Most other shells have aliases of this kind (command aliases). However, zsh also has global aliases, which are substituted anywhere on a line. Global aliases can be used to abbreviate frequently-typed usernames, hostnames, etc.

    % alias -g me=pfalstad gun=egsirer mjm=maruchck
    % who | grep me
    pfalstad ttyp0 May 24 03:39 (mickey.Princeton)
    pfalstad ttyp5 May 24 03:42 (mickey.Princeton)
    % fm gun
    Login name: egsirer In real life: Emin Gun Sirer
    Directory: /u/egsirer Shell: /bin/sh
    Last login Thu May 23 19:05 on ttyq3 from bow.Princeton.ED
    New mail received Fri May 24 02:30:28 1991;
    unread since Fri May 24 02:30:27 1991
    % alias -g phx=phoenix.princeton.edu warc=wuarchive.wustl.edu
    % ftp warc
    Connected to wuarchive.wustl.edu.

    Here are some more interesting uses.

    % alias -g M='| more' GF='| fgrep -f ~/.friends'
    % who M # pipes the output of who through more
    % who GF # see if your friends are on
    % w GF # see what your friends are doing

    alias -g gp='|grep '

    May 15, 2019 - permalink - http://zsh.sourceforge.net/Intro/intro_8.html
    alias zsh
  • splitting_commits
    May 15, 2019 - permalink - https://git-scm.com/docs/git-rebase#_splitting_commits
    commit git split
  • GitHub - paulirish/git-open: Type `git open` to open the GitHub page or website for a repository in your browser.
    May 15, 2019 - permalink - https://github.com/paulirish/git-open
    git github
  • Customize the Touch Bar to always show function keys or media controls

    gimme back my FXX!

    May 15, 2019 - permalink - https://www.idownloadblog.com/2019/02/27/customizing-touch-bar-function-keys-media-controls/
    mac
▼ Load 50 more