Total n00b question here. I am using pgAdmin to attempt to administer a remote PostgreSQL server. I click the connect icon, fill out the form, click 'OK'. The form goes away and in the status bar it says:
Connecting to database... Done.
The problem is, nothing else changes. My server doesn't come up under 'Server Groups' in the object browser, I get no server properties or statistics, or anything else. Yes, the server is running, yes, pg_hba.conf
has been modified to allow my access, and yes, the username/password are right.
I was getting errors from pgAdmin before. I fixed all of those things, now I get nothing.
After you start pgAdmin server the icon with elephant head should appear. If you click it you will have an option Shut down server . Just to clarify: pressing the button asks you if you're sure you want to shut down the server but it just means the admin tool.
If pgAdmin displays this message, there are two possible reasons for this: the database server isn't running - simply start it. the server isn't configured to accept TCP/IP requests on the address shown.
Connect to Server¶ To access the dialog, right click on the server name in the pgAdmin tree control, and select Connect Server… from the context menu. Provide authentication information for the selected server: Use the Password field to provide the password of the user that is associated with the defined server.
Have you tried restarting the program and/or your computer?
I had the same issue where I was trying to add a connection but nothing was showing up after trying a few times. I closed it and opened it up again and I had 4 of the same connections!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With