Forums

I'm not able to use Postico to see the postgresql database created within PythonAnywhere with the provided credentials (Address, Port, etc.). I would like to use a gui to control my postgresql DB. Please help,

If you run pgadmin on your local machine, you can connect it to your PythonAnywhere Postgres instance.

On the "Properties" page of the server setup dialog:

• "Name": a name you can choose
• "Host": the hostname for your Postgres instance from the "Databases" tab inside PythonAnywhere.
• "Port": the port for your Postgres instance from the same "Databases" tab.
• "Username": a username you've created on your postgres instance (perhaps the "super" user you set up on the "Databases" tab).
• "Password": the Postgres password for that user.

Also, importantly, on the "SSH Tunnel" page

• Check the "Use SSH tunneling" checkbox,
• "Tunnel host" should be "ssh.pythonanywhere.com"
• "Tunnel port" should be "22"
• "Username" should be "lilijane"
• Select the "Password" toggle in the "Authentication" section
• "Password/Passphrase" should be the password you use to log in to the PythonAnywhere website.

Sorry, I should have said -- I don't use Postico, but it looks like it has similar setup for using SSH Tunnels to connect, so perhaps you should try that first.

After I added the SSH information I was able to connect to the database using Postico! Thank you!