I hope its okey that I posted this like this. I hope this helps, sorry for all this text. | DbCommon2 | ERROR | 16:52:00,221 | Cannot connect to database rundrshareddatabase192.168.1.3! could not connect to server: Connection timed out (0x0000274C/10060) Is the server running on host "192.168.1.3" and accepting | DbCommon2 | ERROR | 16:50:33,836 | Cannot connect to database rundrshareddatabase192.168.1.3! could not connect to server: Connection timed out (0x0000274C/10060) | DbCommon2 | ERROR | 16:47:17,910 | Cannot connect to database rundrshareddatabase127.0.0.1! FATAL: database "rundrshareddatabase" does not exist Seguí todas las instrucciones de instalación que siguieron mis compañeros de grupo (para OS X Catalina) per. | SyManager.Signals | INFO | 16:46:36,373 | Main view page is changed to 12 Hola Estoy teniendo problemas son Postgres a la hora de abrir mi aplicación, parece que Rails no logra conectar con el servidor. LOG File of the Computer who shall connect via access key: | DbCommon2 | INFO | 16:41:19,921 | Finished upgrading database rundrshareddatabase127.0.0.1 from to | DbCommon2 | INFO | 16:41:00,371 | Initializing fresh database rundrshareddatabase127.0.0.1 | DbCommon2 | ERROR | 16:01:53,487 | No valid database connection! | Main | INFO | 16:01:53,267 | Finished loading Application style sheet | Main | INFO | 16:01:53,205 | Installed custom font: Open Sans Semibold | Main | INFO | 16:01:53,205 | Installed custom font: Open Sans | SyManager | WARN | 16:01:53,205 | Failed to load user preferences. | Undefined | INFO | 16:01:53,189 | Loaded log config from C:\ProgramData\Blackmagic Design\DaVinci Resolve\Preferences\log-conf.xml LOG File on the Computer which shall act as a server: I have bought only one license because I dont need the collaborative workflow option. I exported the log files for you guys so maybe someone understands the problem. One of them shall act as the database server (means it is always turned on, right?), the other one just wont connect to it via the access key. My Problem: I have two workstations in my house and I want to work on my projects with both, I have to change between them occasionally. Installing PostgreSQL with Homebrew is very easy.For days now I have been trying to figure out how to get my two workstations connected via a Postgre SQL Database Server. When you do that, the folder will be moved to the trash. When doing so, you will be prompted to input your administrator password. Cannot run psql -l because I get the same error, no matter which user I run psql as. You have to move the PostgreSQL folder and the remaining contents into the trash. EDIT: Stumbled upon psql: FATAL: role postgres does not exist. At the end, it will tell you that the uninstall is complete, but that your data was not removed. Click on that to uninstall PostgreSQL from your machine. Inside, you will see something called the PostgreSQL uninstaller. To uninstall the install, click on your Macintosh HD icon on your desktop, go into Library folder, and then into your PostgreSQL folder which resides inside the Library folder. It involved getting rid of the standard account which had been created by the Migration Assistant during the restoration of my data and subsequent migration to my new computer, getting rid of the install I had made yesterday, re-installing PostgreSQL with Homebrew, and making sure that I added a postgres user afterwards that contained a password (it does not by default). It had screwed up my PostgreSQL install when it was migrated to my current machine, and getting rid of all traces of my download(s) from was a bit of a challenge. Part of it actually had to do with the (relatively new) Migration Assistant on Mac OSX. Support status of SQLPro for Postgres on Apple Silicon Macs and Apple M1 Processors. Unfortunately, I had initially stumbled clumsily and imperfectly through the process, making a few errors along the way. Which takes me back to my battle with PostgreSQL on my machine in a way that suited my needs.Īs I had mentioned in my previous post, I wanted the ability to play around with PostgreSQL and view it in a Graphical User Interface (GUI), but also have all the features of a Homebrew install. If you don’t know how to use them properly, your programming will suffer! Getting to know the tools you use as a developer is just as important as learning to program. This post was originally published on my developer blog June 17, 2018. This post assumes that you have already backed up your existing databases somewhere (if you cared about them!).
0 Comments
Leave a Reply. |