DEV Community: Peter Gatitu Mwangi

PostgreSQL Procedures & Functions

Peter Gatitu Mwangi — Mon, 10 Nov 2025 08:31:19 +0000

1. What Are They?

In PostgreSQL:

A Function returns data (e.g., query results or a calculation).
A Procedure performs an action (e.g., insert, update, or delete data).

Both are written in PL/pgSQL (Procedural Language for SQL).

2. Basic Syntax

Function Syntax

CREATE OR REPLACE FUNCTION function_name(parameter_list)
RETURNS return_type
LANGUAGE plpgsql
AS $$
BEGIN
    -- SQL statements
    RETURN some_value;
END;
$$;

Notes:

RETURNS defines what the function will give back.
Use RETURN or RETURN QUERY to send results.
Call it with:

  SELECT function_name(arguments);

Procedure Syntax

CREATE OR REPLACE PROCEDURE procedure_name(parameter_list)
LANGUAGE plpgsql
AS $$
BEGIN
    -- SQL statements
END;
$$;

Notes:

Procedures do not return values.
Call them with:

  CALL procedure_name(arguments);

3. Example Table: `bookshop.books`

Column	Type	Description
`book_id`	`serial4`	Auto-generated ID
`book_name`	`varchar(150)`	Title of the book
`author`	`varchar(150)`	Author name
`price`	`numeric(10,2)`	Book price
`published_date`	`date`	Date of publication

4. Creating a Function — Select All Books

CREATE OR REPLACE FUNCTION select_all_books()
RETURNS TABLE (
    book_id INT,
    book_name VARCHAR,
    author VARCHAR,
    price NUMERIC(10,2),
    published_date DATE
)
LANGUAGE plpgsql
AS $$
BEGIN
    RETURN QUERY
    SELECT 
        b.book_id, 
        b.book_name, 
        b.author, 
        b.price, 
        b.published_date
    FROM bookshop.books AS b;
END;
$$;

How to Run

SELECT * FROM select_all_books();

Notes:

RETURN QUERY tells PostgreSQL to output rows.
The function behaves like a normal SQL query.

5. Creating a Procedure — Insert a Book

CREATE OR REPLACE PROCEDURE insert_book(
    p_book_name VARCHAR(150),
    p_author VARCHAR(150),
    p_price NUMERIC(10,2),
    p_published_date DATE
)
LANGUAGE plpgsql
AS $$
BEGIN
    INSERT INTO bookshop.books (book_name, author, price, published_date)
    VALUES (p_book_name, p_author, p_price, p_published_date);

    RAISE NOTICE 'Book "%", by % inserted successfully.', p_book_name, p_author;
END;
$$;

How to Run

CALL insert_book('The Alchemist', 'Paulo Coelho', 15.99, '1988-04-14');
CALL insert_book('Atomic Habits', 'James Clear', 18.50, '2018-10-16');

Notes:

CALL executes the procedure.
RAISE NOTICE prints confirmation messages.
book_id is auto-generated — you don't insert it manually.

6. Viewing the Inserted Data

SELECT * FROM bookshop.books;

7. Difference Between a Function and a Procedure

Feature	Function	Procedure
Returns a value or table	✅ Yes	❌ No
Called with	`SELECT`	`CALL`
Can modify data	⚠️ Limited	✅ Yes
Use case	Reading data	Inserting or updating data

8. Example With Simple Error Handling

CREATE OR REPLACE PROCEDURE safe_insert_book(
    p_book_name VARCHAR(150),
    p_author VARCHAR(150),
    p_price NUMERIC(10,2),
    p_published_date DATE
)
LANGUAGE plpgsql
AS $$
BEGIN
    IF EXISTS (
        SELECT 1 FROM bookshop.books 
        WHERE book_name = p_book_name AND author = p_author
    ) THEN
        RAISE NOTICE 'Book "%" by % already exists. Skipping insert.', p_book_name, p_author;
    ELSE
        INSERT INTO bookshop.books (book_name, author, price, published_date)
        VALUES (p_book_name, p_author, p_price, p_published_date);
        RAISE NOTICE 'Book "%" by % inserted successfully.', p_book_name, p_author;
    END IF;
END;
$$;

9. Summary for Students

Task	Type	Example Command
Create function	`CREATE FUNCTION`	—
Create procedure	`CREATE PROCEDURE`	—
View all books	Function	`SELECT * FROM select_all_books();`
Insert a new book	Procedure	`CALL insert_book(...);`
Check table contents	SQL query	`SELECT * FROM bookshop.books;`

10. Real-World Industry Applications

Understanding where and why these tools are used helps students see their practical value beyond classroom exercises.

E-Commerce & Retail

Use Case: Order Processing

-- Function: Calculate order total with discounts
CREATE FUNCTION calculate_order_total(order_id INT)
RETURNS NUMERIC AS $$
BEGIN
    RETURN (
        SELECT SUM(quantity * unit_price * (1 - discount_rate))
        FROM order_items
        WHERE order_id = order_id
    );
END;
$$ LANGUAGE plpgsql;

-- Procedure: Process order payment and update inventory
CREATE PROCEDURE process_order(p_order_id INT)
AS $$
BEGIN
    UPDATE orders SET status = 'paid' WHERE order_id = p_order_id;
    UPDATE inventory SET stock = stock - quantity 
    FROM order_items WHERE order_items.order_id = p_order_id;
END;
$$ LANGUAGE plpgsql;

Why? Ensures consistent business logic across applications (web, mobile, POS systems) and maintains data integrity during complex transactions.

Banking & Finance

Use Case: Account Transactions

-- Procedure: Transfer money between accounts
CREATE PROCEDURE transfer_funds(
    p_from_account INT,
    p_to_account INT,
    p_amount NUMERIC
)
AS $$
BEGIN
    -- Debit source account
    UPDATE accounts SET balance = balance - p_amount 
    WHERE account_id = p_from_account;

    -- Credit destination account
    UPDATE accounts SET balance = balance + p_amount 
    WHERE account_id = p_to_account;

    -- Log transaction
    INSERT INTO transaction_log VALUES (p_from_account, p_to_account, p_amount, NOW());
END;
$$ LANGUAGE plpgsql;

Why? Guarantees atomic operations (all steps succeed or all fail), prevents data corruption, and maintains audit trails for compliance.

Healthcare

Use Case: Patient Management

-- Function: Check bed availability by department
CREATE FUNCTION get_available_beds(p_department VARCHAR)
RETURNS INT AS $$
BEGIN
    RETURN (
        SELECT COUNT(*) FROM beds 
        WHERE department = p_department AND status = 'available'
    );
END;
$$ LANGUAGE plpgsql;

-- Procedure: Admit patient with medical history validation
CREATE PROCEDURE admit_patient(
    p_patient_id INT,
    p_bed_id INT,
    p_doctor_id INT
)
AS $$
BEGIN
    -- Check allergies and medications
    -- Assign bed
    UPDATE beds SET status = 'occupied' WHERE bed_id = p_bed_id;
    INSERT INTO admissions VALUES (p_patient_id, p_bed_id, p_doctor_id, NOW());
END;
$$ LANGUAGE plpgsql;

Why? Enforces medical protocols, prevents scheduling conflicts, and ensures regulatory compliance (HIPAA, GDPR).

Logistics & Supply Chain

Use Case: Inventory Management

-- Function: Predict reorder date based on consumption rate
CREATE FUNCTION calculate_reorder_date(p_product_id INT)
RETURNS DATE AS $$
DECLARE
    current_stock INT;
    daily_usage NUMERIC;
BEGIN
    SELECT stock INTO current_stock FROM inventory WHERE product_id = p_product_id;
    SELECT AVG(daily_sales) INTO daily_usage FROM sales_history WHERE product_id = p_product_id;

    RETURN CURRENT_DATE + (current_stock / daily_usage)::INT;
END;
$$ LANGUAGE plpgsql;

Why? Automates supply chain decisions, reduces manual calculations, and optimizes warehouse operations.

Gaming & Entertainment

Use Case: Leaderboards and Achievements

-- Function: Get player rank
CREATE FUNCTION get_player_rank(p_player_id INT)
RETURNS INT AS $$
BEGIN
    RETURN (
        SELECT COUNT(*) + 1 FROM players 
        WHERE score > (SELECT score FROM players WHERE id = p_player_id)
    );
END;
$$ LANGUAGE plpgsql;

-- Procedure: Award achievement and update stats
CREATE PROCEDURE award_achievement(p_player_id INT, p_achievement_id INT)
AS $$
BEGIN
    INSERT INTO player_achievements VALUES (p_player_id, p_achievement_id, NOW());
    UPDATE players SET total_achievements = total_achievements + 1;
END;
$$ LANGUAGE plpgsql;

Why? Handles high-traffic operations efficiently and maintains consistent game logic across servers.

Analytics & Reporting

Use Case: Business Intelligence

-- Function: Calculate monthly revenue by category
CREATE FUNCTION monthly_revenue_report(p_year INT, p_month INT)
RETURNS TABLE (category VARCHAR, revenue NUMERIC) AS $$
BEGIN
    RETURN QUERY
    SELECT 
        c.category_name,
        SUM(o.total_amount)
    FROM orders o
    JOIN products p ON o.product_id = p.id
    JOIN categories c ON p.category_id = c.id
    WHERE EXTRACT(YEAR FROM o.order_date) = p_year
      AND EXTRACT(MONTH FROM o.order_date) = p_month
    GROUP BY c.category_name;
END;
$$ LANGUAGE plpgsql;

Why? Pre-aggregates complex reports, improves dashboard performance, and standardizes KPI calculations.

Security & Compliance

Use Case: Data Privacy (GDPR/CCPA)

-- Procedure: Anonymize user data upon deletion request
CREATE PROCEDURE anonymize_user_data(p_user_id INT)
AS $$
BEGIN
    UPDATE users SET 
        email = 'deleted_' || p_user_id || '@example.com',
        phone = NULL,
        address = NULL,
        deleted_at = NOW()
    WHERE id = p_user_id;

    INSERT INTO audit_log VALUES ('user_anonymized', p_user_id, NOW());
END;
$$ LANGUAGE plpgsql;

Why? Ensures legal compliance, maintains data lineage for audits, and automates privacy workflows.

Key Industry Benefits

Benefit	Description
Performance	Reduces network overhead by processing data on the database side
Security	Centralizes business logic and controls data access
Consistency	Ensures same rules apply across all applications
Maintainability	Update logic once instead of in multiple codebases
Transaction Safety	Guarantees atomic operations for critical business processes
Code Reusability	Shared logic across web, mobile, and internal tools
Regulatory Compliance	Enforces data handling rules and audit trails

Career Relevance

Job Roles That Use This:

Database Administrators (DBAs)
Backend Developers
Data Engineers
DevOps Engineers
Business Intelligence Analysts
Financial Systems Developers

Interview Topics:

"Explain the difference between functions and stored procedures"
"How would you handle a money transfer between accounts?"
"Design a procedure to maintain inventory consistency"
"What are the performance benefits of database functions?"

People who master functions and procedures gain skills directly applicable to real-world systems, making them valuable in any data-driven industry.

How to Reset Your WSL Password: A Beginner's Guide to Getting Back Into Your Linux Environment

Peter Gatitu Mwangi — Wed, 06 Aug 2025 22:56:36 +0000

Have you ever found yourself locked out of your Windows Subsystem for Linux (WSL) because you forgot your password? Don't panic! This is one of the most common issues faced by developers who are new to WSL, and fortunately, it's also one of the easiest to fix.

In this step-by-step guide, we'll walk through the process of resetting your WSL password without losing any of your data or configurations. Whether you're a complete beginner or just need a quick refresher, this tutorial will get you back up and running in minutes.

What is WSL and Why Do Passwords Matter?

Before we dive into the solution, let's quickly understand what we're working with. Windows Subsystem for Linux (WSL) allows you to run a Linux environment directly on Windows without the need for a virtual machine. When you first set up WSL, you create a user account with a password, just like you would on any Linux system.

This password is important because it's used for:

Administrative tasks (sudo commands)
Securing your Linux environment
Accessing system files and configurations
Installing software packages

If you forget this password, you'll be locked out of performing many essential tasks in your Linux environment.

When You Might Need This Guide

You'll find this tutorial helpful if you're experiencing any of these situations:

You can't remember the password you set during WSL installation
You haven't used WSL in a while and forgot your credentials
Someone else set up WSL on your machine and didn't share the password
You're getting "authentication failure" errors when trying to use sudo commands
You want to change your password for security reasons

Prerequisites

Before we begin, make sure you have:

Windows 10 version 1903 or higher, or Windows 11
WSL already installed with at least one Linux distribution
Administrator access to your Windows machine
Basic familiarity with command-line interfaces (don't worry, we'll guide you through each step)

Step-by-Step Password Reset Process

Step 1: Open PowerShell or Command Prompt as Administrator

This is crucial—you need administrative privileges to access WSL as the root user.

Method 1: Using the Start Menu

Click the Start button or press the Win key
Type "PowerShell" or "Command Prompt"
Right-click on "Windows PowerShell" or "Command Prompt"
Select "Run as administrator"
Click "Yes" when prompted by User Account Control

Method 2: Using the Quick Access Menu (Recommended)

Press Win + X on your keyboard
Select "Windows PowerShell (Admin)" or "Terminal (Admin)"
Click "Yes" when prompted by User Account Control

You'll know you're successful when you see a terminal window with "Administrator" in the title bar.

Step 2: Identify Your WSL Distribution

Before we can reset the password, we need to know which Linux distribution you're using. WSL supports multiple distributions, and you might have more than one installed.

Run this command to list all your installed WSL distributions:

wsl -l -v

You'll see output similar to this:

  NAME            STATE           VERSION
* Ubuntu          Running         2
  Debian          Stopped         2
  openSUSE-42     Stopped         1

The asterisk (*) indicates your default distribution. Make note of the exact name (including capitalization) of the distribution you want to reset the password for.

Common distribution names you might see:

Ubuntu
Ubuntu-20.04
Ubuntu-22.04
Debian
openSUSE-Leap-15-1
kali-linux

Step 3: Access WSL as Root User

Now we'll use the root account to access your WSL distribution. The root user has administrative privileges and can reset any user's password.

Run the following command, replacing <DistributionName> with the exact name from Step 2:

wsl -d <DistributionName> -u root

Examples:

wsl -d Ubuntu -u root

wsl -d Ubuntu-20.04 -u root

After running this command, you should see your command prompt change to something like:

root@DESKTOP-ABC123:/mnt/c/Windows/system32#

This indicates you're now inside your Linux environment as the root user.

Step 4: Identify Your Username

If you're not sure what your username is in WSL, you can list all user accounts by looking at the home directories:

ls /home

This will show you all user directories, which typically correspond to usernames. You'll likely see something like:

john
user
developer

Your username is probably the one you remember creating, or if there's only one, that's likely it.

Step 5: Reset the Password

Now comes the actual password reset. Use the passwd command followed by your username:

passwd <username>

Example:

passwd john

What happens next:

You'll be prompted to enter a new password
Type your new password (you won't see any characters as you type—this is normal for security)
Press Enter
You'll be asked to confirm the password by typing it again
Press Enter again

You should see a message like:

passwd: password updated successfully

Step 6: Exit and Test Your New Password

First, exit the root session:

exit

Now let's restart WSL completely to ensure all changes take effect:

wsl --shutdown

Wait a few seconds, then start WSL normally:

wsl

You should now be able to log in with your new password. Test it by running a command that requires sudo privileges:

sudo apt update

Enter your new password when prompted. If everything works correctly, you've successfully reset your password!

Troubleshooting Common Issues

Issue 1: "The system cannot find the file specified"

Problem: You get this error when trying to run WSL commands.

Solution:

Make sure WSL is properly installed
Verify the distribution name is spelled correctly (case-sensitive)
Try running wsl --list --verbose to confirm your distributions are installed

Issue 2: Can't Access PowerShell as Administrator

Problem: You don't have administrator rights or UAC is blocking you.

Solution:

Ask your system administrator for help
Try using Command Prompt instead of PowerShell
Ensure you're logged in with an account that has administrator privileges

Issue 3: WSL Doesn't Start After Shutdown

Problem: WSL won't start after running wsl --shutdown.

Solution:

Wait 10-15 seconds after shutdown before trying to start WSL
Try running wsl --distribution <name> to start a specific distribution
Restart your computer if WSL remains unresponsive

Issue 4: "passwd: Authentication token manipulation error"

Problem: The password change fails with this error.

Solution:

Make sure you're running as root (you should see root@ in your prompt)
Try the command again—sometimes there are temporary issues
Restart WSL and try the entire process again

Best Practices for WSL Password Management

Now that you've reset your password, here are some tips to avoid this situation in the future:

1. Use a Password Manager

Store your WSL password in a reputable password manager like:

1Password
LastPass
Bitwarden
Windows built-in password manager

2. Create a Memorable but Secure Password

Use a passphrase instead of a complex password (e.g., "coffee-morning-sunshine-2024")
Include numbers and special characters
Avoid using the same password as your Windows account

3. Document Your Setup

Keep a note (in a secure location) of:

Which WSL distributions you have installed
Your username in each distribution
Any special configurations you've made

4. Regular Usage

The best way to remember your password is to use WSL regularly. Consider:

Setting up daily development tasks in WSL
Using WSL for your primary development work
Creating aliases and shortcuts to make WSL more convenient

Understanding What We Just Did

For those curious about the technical details, here's what happened during the password reset process:

Administrative Access: By running PowerShell as an administrator, we gained the privileges needed to access WSL's root account.
Root Login: The wsl -u root command bypassed the normal user authentication and logged us in as the system administrator.
Password Database: The passwd command modified the /etc/shadow file, which stores encrypted user passwords in Linux.
System Restart: The wsl --shutdown command ensured all WSL processes were properly terminated and restarted with the new password settings.

Security Considerations

While this process is safe and legitimate, it's worth understanding the security implications:

Physical Access Required: This method requires physical access to the Windows machine and administrator privileges, which provides a reasonable security barrier.
No Data Loss: Resetting the password doesn't affect your files, installed programs, or configurations.
Root Access: Remember that the root account has unlimited power in Linux. Be cautious when operating as root.

When to Seek Additional Help

Contact a system administrator or experienced developer if:

You don't have administrator access to your Windows machine
WSL was set up by your company's IT department
You're working on a shared or managed computer
You encounter errors not covered in the troubleshooting section
You need to recover important data from WSL

Conclusion

Forgetting your WSL password is a common experience that doesn't need to cause panic. With administrator access to your Windows machine, you can reset your password in just a few minutes using the built-in root account access.

The key steps we covered were:

Opening an administrator terminal
Identifying your WSL distribution
Accessing WSL as root
Using the passwd command to reset your password
Testing the new password

Remember to store your new password securely and consider the best practices we discussed to avoid this situation in the future.

WSL is an incredibly powerful tool for developers, and small hiccups like forgotten passwords shouldn't discourage you from exploring the world of Linux development on Windows. With this knowledge in hand, you can confidently continue your development journey knowing that you can always regain access to your Linux environment when needed.

Have you encountered other WSL issues or found alternative solutions? Share your experiences in the comments below. For more beginner-friendly tech tutorials and development tips, follow me for regular updates on making complex technologies accessible to everyone.

How to Install PostgreSQL and Get Started (Beginner's Guide)

Peter Gatitu Mwangi — Wed, 06 Aug 2025 13:05:34 +0000

Learn to set up PostgreSQL step by step - no confusing tech jargon

PostgreSQL is a free database that stores your app's data. Think of it like a super organized filing cabinet for your website or app. Today, I'll show you exactly how to install it and start using it.

Why PostgreSQL?

Most apps need to save data somewhere. PostgreSQL is:

Free (saves you money)
Reliable (won't lose your data)
Popular (lots of help online)

Big companies like Instagram and Spotify use it, so you know it works.

Step 1: Install PostgreSQL

If you use Linux (Ubuntu):

sudo apt update

This updates your computer's software list (like checking for new apps in an app store)

sudo apt install postgresql postgresql-contrib

This installs PostgreSQL and some helpful tools

sudo service postgresql start

This starts PostgreSQL running on your computer

Check if it worked:

psql --version

You should see something like "psql 14.9" - that's the version number

If you use Mac:

First, install Homebrew (it's like an app store for your terminal):

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

Then install PostgreSQL:

brew install postgresql
brew services start postgresql

If you use Windows:

Go to postgresql.org
Click "Download"
Download the Windows installer
Run it and click "Next" until done

Step 2: Connect to Your Database

Think of this like logging into your filing cabinet.

On Linux:

sudo -i -u postgres
psql

PostgreSQL creates a special user account called "postgres" - we switch to that user first

On Mac/Windows:

psql postgres

You'll see something like postgres=# - that means you're in!

Step 3: Create Your First User

Right now, only the "postgres" user can access your database. Let's create your own account.

CREATE USER john WITH PASSWORD 'mypassword123';

Replace "john" with your name and use a strong password

Why do this? It's like giving someone their own key to the filing cabinet instead of sharing the master key.

Now create a database:

CREATE DATABASE my_first_app;

Give your user access to it:

GRANT ALL PRIVILEGES ON DATABASE my_first_app TO john;

This lets "john" read, write, and modify the "my_first_app" database

Connect to your new database:

\c my_first_app

Step 4: Give Schema Permissions

Schemas are like folders inside your database. PostgreSQL creates a default schema called "public" for every database.

Why this matters: Your user needs permission to create tables and store data in the schema.

Give your user schema permissions:

GRANT ALL ON SCHEMA public TO john;

This lets "john" create tables and manage data in the "public" schema

Give permissions to future tables:

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO john;

This automatically gives "john" access to any new tables created in the future

Why do both? The first command gives access to existing stuff. The second gives access to new stuff you create later.

Real example: Think of it like this - you give someone keys to a building (schema permission), then you also give them keys to any new rooms that get built (future table permissions).

Check your permissions:

\dn+

Shows all schemas and who has access to them

Step 5: Basic Configuration (Optional)

PostgreSQL has two important settings files. Think of them as the rule books.

Find your settings files:

SHOW config_file;
SHOW hba_file;

This shows you where the files are located

Change basic settings:

Open the main config file:

sudo nano /path/to/postgresql.conf

Common changes:

port = 5433

Changes the "door number" PostgreSQL uses (default is 5432)

max_connections = 100

How many people can connect at once (like seats in a restaurant)

Control who can connect:

Open the access file:

sudo nano /path/to/pg_hba.conf

Change this line:

local   all             all                                     md5

This makes people enter a password to connect (more secure)

Apply changes:

sudo service postgresql restart

Like restarting your computer after installing something new

Quick Commands to Remember

\l          -- Show all databases (like seeing all your folders)
\c dbname   -- Switch to a database (like opening a folder)
\dt         -- Show tables (like seeing files in a folder)
\dn+        -- Show schemas and permissions (like seeing folder permissions)
\q          -- Quit (like closing the program)

Common Problems and Fixes

"Can't connect to server"

PostgreSQL isn't running
Fix: sudo service postgresql start

"Authentication failed"

Wrong username/password
Fix: Check your username and password

"Permission denied for schema"

Your user can't create tables
Fix: GRANT ALL ON SCHEMA public TO yourusername;

"Port already in use"

Something else is using port 5432
Fix: Change the port number in settings

What You Just Learned

You now have:

PostgreSQL installed and running
Your own user account
A database ready for your app
Basic knowledge of how to configure it

Next Steps

Learn basic SQL commands (SELECT, INSERT, UPDATE)
Connect PostgreSQL to a simple app
Learn about database design

PostgreSQL might seem scary at first, but you just completed the hardest part - getting it set up! Now you can start building apps that save data.

Did this help you? Hit the clap button and follow for more beginner-friendly tech tutorials!

DEV Community: Peter Gatitu Mwangi

PostgreSQL Procedures & Functions

1. What Are They?

2. Basic Syntax

Function Syntax

Procedure Syntax

3. Example Table: bookshop.books

4. Creating a Function — Select All Books

How to Run

5. Creating a Procedure — Insert a Book

How to Run

6. Viewing the Inserted Data

7. Difference Between a Function and a Procedure

8. Example With Simple Error Handling

9. Summary for Students

10. Real-World Industry Applications

E-Commerce & Retail

Banking & Finance

Healthcare

Logistics & Supply Chain

Gaming & Entertainment

Analytics & Reporting

Security & Compliance

Key Industry Benefits

Career Relevance

How to Reset Your WSL Password: A Beginner's Guide to Getting Back Into Your Linux Environment

What is WSL and Why Do Passwords Matter?

When You Might Need This Guide

Prerequisites

Step-by-Step Password Reset Process

Step 1: Open PowerShell or Command Prompt as Administrator

Step 2: Identify Your WSL Distribution

Step 3: Access WSL as Root User

Step 4: Identify Your Username

Step 5: Reset the Password

Step 6: Exit and Test Your New Password

Troubleshooting Common Issues

Issue 1: "The system cannot find the file specified"

Issue 2: Can't Access PowerShell as Administrator

Issue 3: WSL Doesn't Start After Shutdown

Issue 4: "passwd: Authentication token manipulation error"

Best Practices for WSL Password Management

1. Use a Password Manager

2. Create a Memorable but Secure Password

3. Document Your Setup

4. Regular Usage

Understanding What We Just Did

Security Considerations

When to Seek Additional Help

Conclusion

How to Install PostgreSQL and Get Started (Beginner's Guide)

Why PostgreSQL?

Step 1: Install PostgreSQL

If you use Linux (Ubuntu):

If you use Mac:

If you use Windows:

Step 2: Connect to Your Database

On Linux:

On Mac/Windows:

Step 3: Create Your First User

Step 4: Give Schema Permissions

Give your user schema permissions:

Give permissions to future tables:

Check your permissions:

Step 5: Basic Configuration (Optional)

Find your settings files:

Change basic settings:

Control who can connect:

Apply changes:

Quick Commands to Remember

Common Problems and Fixes

What You Just Learned

Next Steps

3. Example Table: `bookshop.books`