JIYIK CN >

USERNAMEMany PostgreSQL users may be asked for their database settings for the first time when logging in PASSWORD. However, just learning these settings is not all you need to know.

What is the server in Rails 4? The server in Rails 4 uses Ruby on Rails 4the PostgreSQL server with .

Hence, the backend is integrated with the frontend application using RORthe framework ( short for javascript).Ruby on Rails

Today we will dive into the basic setup of PostgreSQL and the default user configuration before that.

Initial configuration and setup of PostgreSQL

When you run PostgreSQL setup for the first time, you will encounter a similar situation.

It asks you for a password called POSTGRES. SUPERUSERSo when you open PGADMIN4or the console version PSQL, you will now need to log in with the username POSTGRESand the password you entered above.

How do I use PGADMIN4Login?

1. start up PGADMIN4.

2. On the startup screen, you will see the following.

   

3. Here you will enter the password you used during setup to log in.

   If you forget your password, you can simply click RESET MASTER PASSWORDand follow the on-screen instructions.

Now we will learn how to PSQLlog in using .

1. Open CMDand run it with user privileges.

2. In CMD, enter:

   ``cmd
   C:\Users\User_Name > cd C:\Program Files\PostgreSQL\14\bin

   
   或由你的系统指定。而不是 `14`，可能有不同的版本和不同的目录来打开 `bin` 文件夹。
   

3. Now you are 目录in , enter psql.exe.

   ``cmd
   C:\Program Files\PostgreSQL\14\bin> psql -U postgres

The above statement tends to turn on the as usernamewith , which is our default .psqlpostgressuperuser

4. This will guide you to:

Password for user postgres:

Here you will enter setupthe same password you set in to log in and click Enter. You are now logged in.

Superusers in PostgreSQLPOSTGRES

POSTGRESIt is the root of our database SUPERUSER. It has all known permissions to access and view the entire database objects, views, etc.

You can publish your SUPERUSERSor just those with limited access USERS. SUPERUSERis the only CREATEentity that can issue commands to add new users to the system.

Creating differentUSERS

You can create a new one with a unique name using the following statement SUPERUSER.

Create ROLE Wild_Cat WITH SUPERUSER

Or if you want to log in.

Create ROLE Wild_Cat Login

Then psqllog in using .

USERSView and ALTERForgot Password in PostgreSQL

If you have different ones USERS, you can view them as follows.

select * from pg_user;

Then, from the provided list, such as in our example we have user WILD_CAT, use ALTERthe statement to get RESETthe password.

From here, we can ALTERcall the statement as:

ALTER USER wild_cat WITH PASSWORD '[your_password]'

So today, we SERVER IN RAILS 4have seen various ways in which we can define and use SQL in PostgreSQL USERS. We hope that you will continue to learn and follow our tutorials to better understand the concepts behind different solutions to the problem.