K
K
kogot2014-12-11 02:54:19
PostgreSQL
kogot, 2014-12-11 02:54:19

How to connect to Postgres database?

Good afternoon,
Maybe someone knows how:
There is a third-party windows application that works with a PostgreSQL database. For this, 2 services are spinning, one Database server, the second as some kind of interface between the application and the database, because turning it off the application does not see the data.
I need to somehow connect to this database. More precisely, I need this base to make a .Net Web App based on it.
I already tried to change md5 to trust in the pg_hba.conf file, but I still can't connect to the database through SQL manager. And by doing this the app stops working.
Sobsno how you can find out / change the password to the database, well, or in any other way to make it possible to connect to the database.
Thanks in advance.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
S
Salavat Sharapov, 2014-12-11
@desperadik

try with pgAdmin

P
protven, 2014-12-11
@protven

Excuse me, postgre, under Windows? Try this
c:\path\to\psql.exe -U postgres
If under *nix, then so
su - postgres
psql
Well, change the pass further.

S
Swartalf, 2014-12-11
@Swartalf

Show pg_hba.conf
maybe you set trust for one type of connection, but tried another?
how do you connect and what settings?
local socket, localhost(ipv4 or ipv6), real address?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question