Notes on Databases

# Install PostgreSQL
sudo apt install postgresql

# Change Password on first installation
sudo -u postgres psql template1
ALTER USER postgres with encrypted password 'postgres';

# Create database
sudo -u postgres createdb mydatabase
sudo -u postgres createdb standup_india

# Manage services
sudo systemctl status postgresql.service
sudo systemctl start postgresql.service
sudo systemctl restart postgresql.service
sudo systemctl stop postgresql.service
sudo systemctl enable postgresql.service
sudo systemctl disable postgresql.service

VER=7.0
sudo apt-get install gnupg curl
curl -fsSL https://www.mongodb.org/static/pgp/server-7.0.asc | \
   sudo gpg -o /usr/share/keyrings/mongodb-server-7.0.gpg \
   --dearmor
echo "deb [ arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-7.0.gpg ] https://repo.mongodb.org/apt/ubuntu jammy/mongodb-org/7.0 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-7.0.list
sudo apt-get update
sudo apt-get install -y mongodb-org

sudo systemctl start|stop|status|enable|disable mongod

# important step
sudo systemctl daemon-reload

# Issue: Failed to start mongod.service: Unit mongod.service not found.
sudo chown -R mongodb:mongodb /var/lib/mongodb
sudo chown -R mongodb:mongodb /var/log/mongodb
sudo chown mongodb:mongodb /tmp/mongo*.sock


#echo "deb [ arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-7.0.gpg ] <https://repo.mongodb.com/apt/ubuntu> jammy/mongodb-org/7.0 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-7.0.list
#echo "deb [arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-7.0.gpg] <https://repo.mongodb.org/apt/ubuntu> jammy/mongodb-org/7.0 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-7.0.list