Os x postgres app5/17/2023 ![]() While Postico 2 is our latest and greatest version of Postico (see whats new in the changelog), we continue to support Postico 1.5. If you have an older Mac, we also have old versions of Postico available. Screen Shot at 18.20.57.png (380.Postico 2 is compatible with PostgreSQL 8.0 or later, Amazon Redshift, CockroachDB, Greenplum, and others. Screen Shot at 18.29.56.png (179.22 KiB) Viewed 6208 times Local Postgres stopped and pgAdmin connected to remote. Screen Shot at 18.30.08.png (216.3 KiB) Viewed 6208 times Give the connection a name. Screen Shot at 18.30.08.png Attachments Provide the host name or IP address in the connection configuration. ![]() You need to give it a name in the General tab and fill in the information on the Connection tab. You should be able to add the remote server through the "Dashboard" and "Add New Server". In this case I already have the server added to my list. Paralandra5:~ postgres$ bin/pg_ctl stop -D `pwd`/data I'll do this on my laptop and show you how it is working. Since you have installed Postgres 9.5 on your laptop, shut it down for now just to make things clearer. ![]() Your PgAdmin is trying to connect to Postgres on your laptop. Maybe it has to do with the pop-up "Allow Connection to postgres" appearing on the laptop all the time and it can't be terminated. In laptop I reinstall PostgreSQL from DaVinci installer but situation is the same - I cannot connect or add new server. If you can get the connection to Postgres, Resolve should work fine.Yes, on my desktop I can connect to pgAdmin. Note that I am not talking about Resolve here, just Postgres. Once you have PgAdmin working on your desktop and you have restarted Postgres, then go to your laptop and try to connect via PgAdmin. If you still cannot get in, try resetting the password following this post. Try both of those and you should be able to get PgAdmin to connect to the local Postgres first. On your desktop, can you connect to Postgres via PgAdmin? The default password for Postgres is usually 'postgres' but if it is installed by Resolve it is 'DaVinci' (case sensitive). ![]() Harold Tomlinson wrote:Let's go back to the basics. On the laptop, once I have the job queued up on the deliver page, I click on what looks like a WiFi symbol above the job name and select the host that will do the rendering. On the desktop I startup Resolve, open an empty project, then select "Remote Rendering" from the Workspace menu. Once that is done, I can access the project database and do remote rendering from my laptop. Perhaps that needs to be done in spite of the fact that your firewall is off. When I do that, I get the window allowing the firewall to permit incoming messages for Postgres and I can connect from pgAdmin on my laptop. Paralandra:~ haroldt$ sudo -i -u postgres bin/pg_ctl restart -D /Library/PostgreSQL/9.5/data/ To restart the server (from my account), I run: Paralandra:~ postgres$ cat data/pg_hba.conf The pg_hba.conf on my desktop is like this: In spite of the fact that the firewall is configured to allow Postgres to receive requests, I have to restart postgres manually after a reboot of the desktop to get the pop-up that allows incoming requests. I started by ensuring I could get to Postgres from my laptop via pgAdmin. Is the Project Server needed? I have my database shared and remote rendering working between my iMac Pro and MacBook Pro. Attachments Screenshot at 15.53.07.png (61.12 KiB) Viewed 7237 times I don't have a static public IP but my IP only seems to change when the router is restarted - so I think it's static for long enough for the sake of testing this. In pg_hba.conf i have: host all all 0.0.0.0/0 md5Īlso I've attached a screenshot my home router with port forwarding. In nf I have inserted at the bottom: listen_addresses = '*' Port forwarding for 5432 is configured at the router To recap this host Mac (Catalina) machine has: | DbCommon2 | ERROR | 19:54:03,920 | Cannot connect to database gustoX4.X.84.XX3! FATAL: no pg_hba.conf entry for host "82.XX2.2X4.40", user "postgres", database "gusto", SSL off When I try to connect the same database from a remote machine (3 different ones in 3 different locations) I get the error message immediately: I can connect to shared database from another machine on the same network - no problem there. Hi, I've deleted the database and done a fresh install to get the Project Server up and running again.
0 Comments
Leave a Reply. |