AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Connect to postgres db sqlpro9/25/2023 ![]() 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) Storage type: Select General Purpose (SSD).For more information about storage, see Storage for Amazon RDS. To see a list of supported instance classes, see Amazon RDS Pricing. Is the server running on host "192.168.1.3" and accepting Instance specifications: DB instance class: Select the default, d b.t2.micro - 1 vCPU, 1 GIB RAM.This equates to 1 GB memory and 1 vCPU. | DbCommon2 | ERROR | 16:50:33,836 | Cannot connect to database rundrshareddatabase192.168.1.3! could not connect to server: Connection timed out (0x0000274C/10060) Connect to database: Method 1 : enter to db : sudo -u postgres psql Connect to db : \c dbname Method 2 : directly connect to db : sudo -u postgres psql -d mydatabasename. | DbCommon2 | ERROR | 16:47:17,910 | Cannot connect to database rundrshareddatabase127.0.0.1! FATAL: database "rundrshareddatabase" does not exist | SyManager.Signals | INFO | 16:46:36,373 | Main view page is changed to 12 ![]() 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: SQLPro for Postgres is a lightweight but powerful PostgreSQL database client, which allows quick and simple access to Postgres Servers including cloud services. I have bought only one license because I dont need the collaborative workflow option. To create a new database using psql, follow these steps: Open a terminal or command prompt. ![]() 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. For days now I have been trying to figure out how to get my two workstations connected via a Postgre SQL Database Server.
0 Comments
Read More
Leave a Reply. |