CODEWITHSUNDEEP
postgresqldatabase-connectivity
David Alexandru
David Alexandru

Reputation: 25

Access embedded postgreSQL database

Can an embedded postgreSQL 9.1.1 database be simultaneously accessed externally by another application?

I installed a separate postgreSQL server on the same machine, but the embedded database doesn't seems to be visible.

The other problem is that I cant find out the password for the user that the application is using to connect to its internal database file.

Upvotes: 0

Views: 2385

Answers (1)

Ihor Romanchenko
Ihor Romanchenko

Reputation: 28551

If you want to connect to a postgresql server, that was installed on you machine by some software you need:

1) Find the cluster directory of the installed postgresql server.

2) Search for the postgresql.conf file in cluster directory. There you will find a port, the server is listening to.

3) Search for pg_hba.conf file in cluster directory. Adding host all all 127.0.0.1/32 trust line to this conf file will allow you to access the server without password.

4) Start the postgres server, specifying the cluster directory from step 1 . (Search for postgres binaryes, installed by the application.). If it is already running - you need to restart it.

5) Connect to the DB using post from step 2 and any postgres login (Try login postgres it is a default one)

Upvotes: 2

Related Questions