How do Manage Postgresql 13 Services in Ubuntu 20.04 LTS

1> Stop Postgresql Service:

sudo systemctl stop  postgresql

2> Start Postgresql Service:

sudo systemctl start  postgresql

3> Restart Postgresql Service:

sudo systemctl restart postgresql

4> Check Postgresql Service Status:

sudo systemctl status postgresql 

How do I increased Swap Memory of Ubuntu OS using terminal from 1GB to 7GB

 Hi, I have increase my Ubuntu OS swap memory from 1GB to 7GB by adding additional 6GB space to swap. Process which I followed is as follows:

1> Check previous Swap Memory:

cat /proc/swaps

2> Check previous Swap Memory:

swapon

3> Check previous Swap Memory:

free

4> Create new Swap Memory:

sudo dd if=/dev/zero of=/newswap bs=1024 count=6M

5> Set permissions for new Swap Memory

sudo chmod 0600 /newswap

6> Bake new swap:

sudo mkswap /newswap

7> Turn on new swap:

sudo swapon /newswap

8> Check new Swap Memory:

swapon

9> Modify /etc/fstab file by adding following lines at the end

/newswap    swap    swap   defaults 0 0

Done!

Google Cloud Plateform VM Instances: How to connect one VM Instance to other using SSH and Internal IP Address

 Dear Friends, all of us know that there are two kinds of IP Address that can be assigned to GCP VM Instances (i.e Compute Engine), now if you take external IP address, without any reason then you will have to pay since external IP address is not free.

So if you need to connect two compute engines via internal IP address using terminal for same region, via SSH, process is same as you connect via extermal IP address.

i.e ssh <username>@<internal_ip_address>.

Other advantage of connection via internal IP address is that it uses Internal LAN instead of Internet Data for communication will in turn will save lot of energy.

Update Time-Zone in Ubuntu 20.04 terminal

Check time zone by date command 

sudo timedatectl set-timezone <your_timezone>

eg sudo timedatectl set-timezone Asia/Kolkata

Then after setting check again using date command.

Note: After updating timezone always restart using command

sudo reboot, for proper functioning of cronzobs, etc

Set Up Default Password for Postgres User

 Upon installing postgres, there is no password for Postgres User

This is the way to set up default password for Postgres User in Linux

1. Open terminal
2. Type: sudo -u postgres psql <-p portNo> eg sudo -u postgres psql -p 5433 or sudo -u postgres psql for default port 5432
3. Type: postgres=# ALTER USER postgres PASSWORD '<your desired password>';
4. Type: \q to exit postgres and return back to terminal login

DONE!

How to do Instance Scheduling in Google Cloud Plateform

Instance Scheduling provides easy way to turn copmpute engine instance on & off at particular timing very easily.

This the the way, how I achieved this for doing this work.

Log in to console.cloude.google.com

1. Go to IAM & Admin -> Roles
2. Choose Create roles and create role with permissions: 
   
   
   
   
   
3. Go to IAM & Admin -> IAM
4. Click Google -Provided Role grant...
   
   
   
   
   
5. Search for service-<Your-ProjectId>@compute-system.iam.gserviceaccount.com in filter and edit to add role you created in Step 2 above
6. Go to Compute Engine -> VM Instances -> Instance Schedule
7. Create an instance schedule with start - stop timing as per your requirement
8. you can choose start-stop timing as per CRON format of Linux for further detailing.
9. Now once instance schedule is created, click it and click Add Instance to Schedule
   
   
   
   
   
10. Choose your VM Instances for this schedule and its done

Hope you enjoyed this reading and this reading may help you for future project.