How to check list of database in postgres present on non default port?

Question

I have two postgres versions on my system. I want to check the list of database that is available on older version of postgres (port: 3433). Is there any way to check this?

Note - On running psql command it is showing the latest version of postgres that I have installed in system and \l command shows databases present in that version.

Laurenz Albe · Accepted Answer · 2021-03-23 09:13:14Z

1

The simplest variant is

psql -p 3433 -l

This assumes that you are operating system user postgres.

answered Mar 23, 2021 at 9:13

Laurenz Albe

257k22 gold badges314 silver badges390 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

User · Accepted Answer · 2021-03-23 07:39:54Z

0

I was able to check the list of database using the following command -

psql -h localhost -p 3433 -d test -U user

Here -h represents the host, -p represents the port, -d represents the database and -u represents the username.

After that you have to enter the password and run command \l to view the list of database.

answered Mar 23, 2021 at 7:39

User

2292 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to check list of database in postgres present on non default port?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related