Ubantu Linux command

New Ubantu system setup

1. Install NPM in Ubuntu 20.04 LTS through repository

Since the package is already available in standard Ubuntu repository. Therefore, first we need to update the repository to make the latest version of the package available. Hence, open a terminal and issue the following –

sudo apt update

Next, to install NPM –

sudo apt install npm

To verify the version of NPM we have installed –

npm -v

It would return –

6.14.4

Reference :https://techpiezo.com/nodejs/install-npm-in-ubuntu-20-04-lts/ 

2. Install  Node Js

sudo apt install nodejs

3. Install  Visual Studio code

https://code.visualstudio.com/Download

.deb 64 bit download and install

Access Ubuntu server using Putty:

sudo su   ->enter

vim filenamd.extension

:w -save

:qa exit

i for insert

mv old file  new file

rm -remove file

rmdir -remove directory

rm -r mydir -non empty directory

cp -r  source  /destination path

assign permission 

chown -R www-data folder

Database access with Ubantu 

https://www3.ntu.edu.sg/home/ehchua/programming/sql/PostgreSQL_GetStarted.html

 Database:-

1. sudo -i -u postgres-  to access post gre sql.

2. psql

3. \l  list of database

4. \c db name - database connected

5  db= \i  script.sql

6.  

3. https://stackoverflow.com/questions/34098326/how-to-select-a-schema-in-postgres-when-using-psql

After - access the databases:

To list Databases.

psql -c'\l'

$ sudo service postgresql stop     // Stop the service
$ sudo service postgresql start    // Start the service
$ sudo service postgresql restart  // Stop and restart the service
$ sudo service postgresql reload