![]() ![]() ![]() Now, change the Admin database password- psql -c "ALTER USER postgres WITH PASSWORD 'your-password' " Login using Postgres system account- su - postgres ![]() To make sure our PostgreSQL is secured with a strong password, set a password for its system user and default database admin user account using the below-given commands-Ĭhange user password sudo passwd postgres To check the status and confirm the service is running without any errors, here is the command to follow: sudo systemctl status postgresql Step 6: Configure PostgreSQLįew things which a user would like to perform on its newly installed Linux database server. sudo systemctl start postgresql sudo systemctl enable postgresql sudo postgresql-setup -initdb Step 5: Start and Enable ServiceĪfter completing the initialization, let’s start and enable the PostgreSQL server service so that we can use and can start it automatically with the system boot. For that use initdb which will create a new PostgreSQL database cluster refers to a collection of databases managed by a single server instance. Now, before starting and enabling the service of the Database, let’s initialize it. sudo dnf install postgresql15.x86_64 postgresql15-server Step 3: Initialize the PostgreSQL Database It will install both the client and server parts of the PostgreSQL Database system on your Linux. So, what you have to do is just run the given command. Well, the best thing currently you don’t need to add any repository to get the PostgreSQL version 15 on your Amazon Linux 2023 because it is available through its system default repo. So, get access to your terminal or connect to your Amazon Linux instance via SSH and run the following command: sudo dnf update Step 2: Install PostgreSQL 15 on Amazon Linux 2023 Plus, this will also refresh the DNF package cache. On any Linux before installing packages, a user should run a system update command that will ensure all the latest available updates are installed on the system. At least 1GB of free Hard disk space, 2GB of RAM, and a single-core CPU. To follow this tutorial you must have Amazon Linux 2023 installed on AWS Ec2 Instance or Docker with Admin user rights. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |