Naimur Hasan Tech

Search This Blog

What software can I Install after a fresh Ubuntu Setup.

August 25, 2021

Get link
Facebook
X
Pinterest
Email
Other Apps

* VSCODE

* flutter

* android studio

* chrome

* unijoy keyboard layout

* sticky note

* teamviewer

* anydesk

* droidcam

* skype

* gimp

* flameshot

ubuntu

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

create ssl certificate with certbot

sudo certbot certonly --standalone --preferred-challenges http -d example.com listen 443 ssl; # managed by Certbot ssl_certificate /etc/letsencrypt/live/example.com/fullchain.pem; # managed by Certbot ssl_certificate_key /etc/letsencrypt/live/example.com/privkey.pem; # managed by Certbot include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot client_max_body_size 200M;

Copy Databse of Postgresql | Import & Export Remote to Local

1. First Login Using sudo -i -u postgres Then Type: psql To see databse list: \l or \list Connect to Database \c ebook_mcq List Table \dt Now Get Out of The Database By exit To Save A Copy as File pg_dump mydb > mydb.sql Now in your local Computer from another terminal download the file scp -r username@ip:/var/lib/postgresql/ mydb.sql . Copy Local File to Remote scp -r /local/directory remote_username@10.10.0.2:/remote/directory To Import psql -U username dbname < dbexport.pgsql if you want to delete all the tables DO $$ DECLARE r RECORD; BEGIN FOR r IN ( SELECT table_name FROM information_schema.tables WHERE table_schema=current_schema() ) LOOP EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(r.table_name) || ' CASCADE'; END LOOP; END $$ ; Or, DROP SCHEMA public CASCADE ; CREATE SCHEMA public ;

Powered by Blogger

What software can I Install after a fresh Ubuntu Setup.

Comments

Post a Comment