Now configure how the Postgres server will authenticate clients such as pgAdmin. $ psql -c "ALTER USER postgres WITH PASSWORD ' ' "ħ. Then switch to the Postgres system account and create a secure and strong password for PostgreSQL administrative database user/role as follows. Start by creating a password for a Postgres system user account using the passwd utility as shown. Next, secure the Postgres user account and the database administrative user account. Initialize PostgreSQL Database Step 2: Secure and Configure PostgreSQL Databaseĥ. # /usr/pgsql-12/bin/postgresql-12-setup initdb Then check if the service is up and running, and is enabled as shown. Once the installation is complete, initialize the PostgreSQL database, then start the PostgreSQL-12 service and enable it to automatically start at system boot. # dnf install postgresql12 postgresql12-serverĤ. Next, install the PostgreSQL 12 server and client packages.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |