Postgresapp: The operation couldn’t be completed. (com.postgresapp.Postgres2.ClientLauncher error 0.)

[tarasinghmc]

Unable open app in terminal

[jakob]

Thanks for the bug report!

What version of macOS are you on?

What version of Postgres.app are you using?

[jakob]

So I've been playing around with this, and the problem seems to be caused by missing permissions on macOS Mojave.

You have to enable access for Postgres.app in System Preferences -> Security -> Privacy -> Universal Access and in System Preferences -> Security -> Privacy -> Automation.

Mojave made Apple Script practically unusable.

I guess the best thing to do would be to throw away the Apple Script, and just show a text field with the command for copy/pasting into terminal. Less convenient, but then at least we won't have to bug the user with 3 separate permission dialogs.

[tarasinghmc]

Thanks for giving valuable feedback.

On Tue, Oct 9, 2018 at 1:23 AM Jakob Egger [e-mail] wrote:

So I've been playing around with this, and the problem seems to be caused
by missing permissions on macOS Mojave.

You have to enable access for Postgres.app in System Preferences ->
Security -> Privacy -> Universal Access and in System Preferences ->
Security -> Privacy -> Automation.

Mojave made Apple Script practically unusable.

I guess the best thing to do would be to throw away the Apple Script, and
just show a text field with the command for copy/pasting into terminal.
Less convenient, but then at least we won't have to bug the user with 3
separate permission dialogs.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/PostgresApp/PostgresApp/issues/471#issuecomment-427958850,
or mute the thread
https://github.com/notifications/unsubscribe-auth/ANNv3q1j64ruvBDMH9xBQJos_b8V2KyZks5ui60sgaJpZM4XNZs6
.

[cursologo-gh]

I have the same issue. Still cant find a way to solve it

[jakob]

@cursologo-gh
Apple Script in Mojave requires a lot of permissions. Either you enable all the permissions in System Preferences (as stated above).

Alternatively, you can just type the command to connect in Terminal yourself:

Just type the following command to connect to the default database:

/Applications/Postgres.app/Contents/Versions/latest/bin/psql

If you have configured your $PATH, you can just type:

psql

If you want to connect to a different database, you can type

/Applications/Postgres.app/Contents/Versions/latest/bin/psql databasename

If you changed the default port, you can type

/Applications/Postgres.app/Contents/Versions/latest/bin/psql -p 5444

[cursologo-gh]

Thank you so much Jakob!!!.. I actually run both PATH="/Applications/Postgres.app/Contents/Versions/latest/bin:$PATH" mentioned on https://devcenter.heroku.com/articles/heroku-postgresql and https://postgresapp.com/documentation/cli-tools.html and it worked like a charm!!! but only using my house WiFi. Do I need to mess around with the postgresql.conf files each time I want to connect to my DB using a different connection?... Thanks anyways, it helped a lot and at least I can still continue working. Just wanted to understand how it works

[uythoang]

@jakob I think you mean System Preferences -> Security -> Privacy -> Accessibility. There is no Universal Access (Mojave 10.14.2)