I am trying to create a postgres server on my local. But I am getting this error:

This is my first time using postgresql so kindly let me know what I am doing wrong here.

I watched some tutorials and tried following the steps in them. Please refer to the snapshot for details of the error.

CodePudding user response：

The screenshot you provided is actually the postgres client (pgadmin). You need to have the server installed and started on port 5432. Only then you will be able to connect the client on localhost:5432

Here is the installation/download link: https://www.postgresql.org/download/

Also, you can use docker to start such a database and then connect to it. https://hub.docker.com/_/postgres The command would be i.e.

docker run --name postgres -p 5432:5432 -d postgres

Keep in mind that all data will disappear with docker once you delete the container. However, you can use volumes to persist them and reuse during your development.