Connecting to pgadmin

1

Hi all,

I’m trying to connect the Postgres DB I have deployed on render to my local pgadmin 4 application so I can visualize the data…that said I’m a bit of a noob and I’m not sure how to make the connection. Would I use the internal or external connection string for this? Or do I have to input the hostname, port, database, and username somewhere (I’ve tried this but seems that the hostname should be an IP address)?

1 Like
2

Hi!

You can enter the connection information manually in PGAdmin. Create a new server (Servers > right-click > Create > New Server).

Under the new server ‘Connection’ tab, enter the following:

  • Host name/address: The host name is the part of the external connection string between the ‘@’ and your database name. For example oregon-postgres.render.com

  • Port: Default is 5432

  • Maintenance database: Render database name

  • Username: Render database user name

When you save and connect you’ll be prompted for your password. You can choose to save it with the connecting in PGAdmin.

17 Likes
3

That worked, thank you so much!!

4

Thanks a lot, :blush:

5

I am trying to connect to pgadmin with all the user and host information, password and more and it does not work, and it gives me the following error: ‘ServerManager’ object has no attribute ‘user_info’

6

Searching for that error ‘ServerManager’ object has no attribute ‘user_info’ seems it could point to an outdated pgAdmin version, e.g. https://stackoverflow.com/questions/69378663/how-can-i-solve-servermanager-object-has-no-attribute-user-info-error-in-pos

Maybe try upgrading pgAdmin.

Alan