2022-02-26

Logging in Postgres sql from cmd using a specific post

How can i use the command prompt to log into Postgres installation? I am trying to use this command on C:\Program Files\PostgreSQL\14\data directory

psql -h localhost -p 5433

Since there is some other program which has another installation of an earlier release of Postgres on port 5432, thus port 5433. But it is producing this error:

psql: error: connection to server at "localhost" (::1), port 5433 failed: FATAL:  role "user1" does not exist

https://docs.bitnami.com/virtual-machine/infrastructure/postgresql/administration/connect-remotely/



No comments:

Post a Comment