Skip to main content

Posts

Showing posts from July, 2020

How to create database and user in postgress databse

Tech Easy Solutions sudo -u postgres createuser user01; $ sudo -u postgres createdb userdb; $ sudo -u postgres psql psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1)) Type "help" for help. postgres=# alter user user01 with encrypted password 'user01'; ALTER ROLE postgres=# grant all privileges on database userdb to user01; GRANT postgres=# \q database :userdb user : user01 passworrd : user01

how to add SSH key in version control

Tech Easy Solutions system config: Ubuntu $ ~/.ssh$ ssh-keygen -t ed25519 -C "key for git lab" Generating public/private ed25519 key pair. Enter file in which to save the key (/home/user/.ssh/id_ed25519): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /home/user/.ssh/id_ed25519. Your public key has been saved in /home/user/.ssh/id_ed25519.pub. The key fingerprint is: .. $ cat id_ed25519.pub then past into version control system access using ssh eky