However, I cannot get pgadmin4 to connect. The database migrated successfully and I can open the project on my local server. When I said my live server works, what I meant was that the project I am working on (Rails), I can open it up on my local server (I meant local, not live - think I was tired), and it opens. I did then try to download the Windows version of pgadmin4 separately, just to see if this would work, but it didn't. I'm trying to link as per above, pgadmin4 to my PostgreSQL via the Jammy download above. I went with Linux, hence I wanted to download pgadmin4 via Linux (as Windows was giving so many problems). Once complete, in my Ubuntu terminal was a server to a localhost where the web page was meant to appear. I downloaded Ubuntu Jammy from the list below - Īnd I then followed the commands at the bottom of the page to install desktop and web modes (as per a youtube video). Sorry, it's all new to me and so I don't fully understand myself. Are there command line instructions I can run in Ubuntu that circumvent the need to use pgadmin as a way around this? So that I can access the table data in the schema etc. With the help of pgAdmin it is very convenient to administer PostgreSQL servers, as well as to create databases (all the tools you need to do this are installed by default with the program). I don't feel like this should be so complicated, but it is and it is driving me insane. The pgAdmin program is one of the clients intended for PostgreSQL servers. But I cannot log into pgadmin 4 on the desktop download, it won't log in. I have created a database/user and migrated and can load my server. When I run 'sudo service postgresql status' in Ubuntu, it shows that postgres is active. But I've downloaded it via Ubuntu, so not sure why it would not be showing up. I know that it was there when I installed postgres via windows (before uninstalling the windows version). The one weird thing is that when I look for postgres in 'services', it is not there. All the details are correct, the port etc. I've no idea what I'm meant to do to get pgadmin to work. Installed pgadmin4 in Ubuntu as well - both the web and desktop, but the web loads an error page and the desktop doesn't connect. Had all sorts of problems downloading via windows, so I did it via Linux (Ubuntu). First things first, this is all pretty new to me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |