PostgreSQL cannot connect: service definition not found

geoB

In Windows 10 Pro 64-bit & new installation of PostgreSQL 9.4, attempting to connect to the server in pgAdmin III results in

error screen

The service is running and the service name is correct, as seen here

windows service dialog

I am brand new to PostgreSQL, but fwiw, I've configured a working Symfony 2.7 application to use PostgreSQL and have successfully (according to the Symfony console) created a database and its schema.

What is required to get pgAdmin to connect properly?

geoB

It turns out that the error message is grossly misleading. There is no issue with the service definition. Instead, I learned that when logged in as a user other than the user that created the PostgreSQL installation (e.g., postgres) one needs to do this at the command prompt:

runas /user:postgres "C:\Program Files\PostgreSQL\9.4\bin\pgAdmin3.exe"

There may be a more elegant solution than making the above a cmd file. I'd like to know what that is!

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0

関連記事

分類Dev

PostgreSQL cannot connect: service definition not found

分類Dev

Azure Devops cannot connect to Service Fabric Cluster

分類Dev

Cannot connect to KAFKA running on Azure App Service

分類Dev

Cannot connect to remote PostgreSQL instance from Django app running within Docker container

分類Dev

pymysql cannot connect to mysql

分類Dev

Cannot connect users

分類Dev

BeautifulSoup: Table cannot be found

分類Dev

ActivityMainBindingImpl cannot be found

分類Dev

PostgreSQL: cannot see schemas

分類Dev

Changing public url in knative service definition

分類Dev

Renderer cannot be used in Service?

分類Dev

Cannot Run Mongo as Service

分類Dev

Python Connect to Microsoft Analysis Service

分類Dev

WCF Endpoint not found for service interface

分類Dev

Chrome Extension cannot connect to websocket

分類Dev

Type provider cannot connect to localDB

分類Dev

Cannot connect remotely using ssh

分類Dev

Cannot connect VM's in VirtualBox

分類Dev

Hadoop Java Class cannot be found

分類Dev

macOS notarization: altool cannot be found

分類Dev

Blazor InputFile IFileListEntry cannot be found

分類Dev

Bamboo maven plugin cannot be found

分類Dev

On Apple Silicon: ruby-build: definition not found: 3.0.0

分類Dev

Web service can connect in IE, but can't connect by Visual studio

分類Dev

how to connect to database service using cluster ip

分類Dev

Airflow scheduler can not connect to Kubernetes service api

分類Dev

Service Fabric: The EntryPoint Blah.exe is not found

分類Dev

Go To Definition: "Cannot navigate to the symbol under the caret."

分類Dev

RealmSwift initialize list : Cannot specialize a non-generic definition

Related 関連記事

ホットタグ

アーカイブ