when you see "postgres=#" prompt, which means the active database's name is 'postgres', not the username, in the surprise of non-explanation shown from any beginner's guide at the same time the more surprise of the decision the postgresql dev team, historically Berkeley, has made on the default name of database and default username as samely as 'postgres' which may give PostgreSQL good old Atomicity or Consistency or Isolation thing though, type "CREATE DATABASE dvdrental " and press enter (assuming you are using sample db 'dvdrental' from ).just enter all of prompt to go as default setting, and when you're asked password, just type password and press enter even the cursor is not moving.download pgAdmin from official pgAdmin homepage and install it.download postgresql package from and install it but DO UNCHECK pgAdmin during installation.So, the exact tutorial of installing postgresql and connecting sample db is this, not the one from Solution is just downloading and installilng pgAdmin from official pgAdmin homepage version, not the one that is included in the package. I am really curious that how someone can say despite all the things above the postgreSQL be still easy and beginner friendly database engine. Or am I missing something important as much as website's tutorial even has done too? Or is the compatibility of PostgreSQL really really bad so that it couldn't even run on windows 10? So I don't understand in the first place why couldn't I run front end as it was installed.ĭoes it need to be deployed on some kind of dedicated server? (which I guess that the sample db from has problem first place or the sample db might not have been loaded properly, but this thing I cannot be sure and I cannot figure out how I can check it out)Īnd in psql, SELECT first_name FROM customer command doesn't run (they must be in the sample database as the website's explanation) So I gave up the front end (even I tried to connect db that I load by pg_restore so that the location of db now become the subfolder of PostgreSQL, like ProgramFiles \ PostgreSQL \ 15 \ data, through dBeaver, it doesn't have contents. I tried pg_ctl start - D "~~~~~database location", pg_ctl stop, pg_ctl restart things and it says server cannot start sometimes but finally after trying and trying it says server is running.Įven after that though pgadmin still stuck at Loading. In the log of pgadmin, it says the URL couldn't be found which I guess it tried to connect to database through 127.0.0.1:5432 or localhost:5432 or 0.0.0.0:5432 as I tried to access them too through chrome browser leading to just failed connection. listen_address value was "*" in the first place. I changed settings of port number from nf to random number in the case of somekind of port confusion thing but didn't help. js file type doesn't have Content Type value in the first place. I searched about the matter and I changed pg_hba.conf from 127.0.0.1 to 0.0.0.0, which I cannot understand why should I do that in the first place. and in psql, SELECT version() command ran successfully.īut when I execute pgadmin4, It doesn't pass the "Loading pgAdmin 4 v7.4." screen. and I installed postgreSQL, did pg_restore to load sample database file. I choose postgreSQL as I've heard it is the most beginner friendly but, I cannot pass the very beginning part of tutorial all the day.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |