How does one setup a LEPP stack on Digital Ocean using Ubuntu 22.04 - 23.10?

Heya, @ebeecroft

LEPP might a suitable alternative to LEMP to optimize the stack for write-heavy operations.

I don’t think we have one article that covers the whole process, but you can use these two to complete the process.

You can complete the LEMP stack article, beside from the MySQL setup bit and then switch to our PostgreSQL article to complete the database bit.

https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-22-04

Hope that this helps!

Heya @ebeecroft,

Yes, you can go from MySQL to PostgreSQL making the setup LEPP, it’s quite alright.

First, let’s start with the L, A and P(php). You can follow this tutorial from DigitalOcean for that:

https://www.digitalocean.com/community/tutorials/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu

Skip the part for MySQL.

Now for Postregsql install on Ubuntu, you can do the following

Update your system’s package list: Open a terminal and run the following command to make sure your package list and installed packages are updated.

sudo apt update && sudo apt upgrade

nstall PostgreSQL: You can install PostgreSQL along with the PostgreSQL-contrib package which adds some additional utilities and functionality by running:

sudo apt install postgresql postgresql-contrib

Verify the installation: After installation, PostgreSQL should start automatically. You can check its status by running:

sudo systemctl status postgresql

Accessing PostgreSQL: By default, PostgreSQL creates a user named ‘postgres’ with the role ‘postgres’. You can switch to this user to start using PostgreSQL:

sudo -i -u postgres

You can then access the PostgreSQL command line interface by typing:

psql

To exit the PostgreSQL interface, type:

\q

Additional Configuration (Optional):

• You might want to create a new database or new roles. You can do these as the postgres user.
  • Adjust authentication methods and other settings by editing the configuration files typically found in /etc/postgresql/{version}/main/.

Secure PostgreSQL: While PostgreSQL is configured with reasonable defaults for security, you may need to adjust these settings based on your specific needs. For example, you might want to change the default listening addresses or implement more stringent password policies.