PostgreSQL: One database to multiple user

Question

I have PostgreSQL 9.3 version. I have created database name db1 now I need it to share with other users who all are connected with the LAN's to connect other applications with the same database.

In SQL Server: We can do this by selecting server name with login details.

enter image description here

Question:

Is it possible in PostgreSQL?
If yes, how can do this?
What is the procedure?

Dave Cousineau · Accepted Answer · 2014-07-27 07:14:28Z

1

You will need to modify pg_hba.conf to allow remote connections to the database. Information about pg_hba.conf can be found here.

After that, you can connect programatically with a connection string, or similar to your image, with a GUI application like pgAdmin.

To connect (remotely or locally) from pgAdmin choose File -> Add Server... and enter the connection information into the dialog box. Here's an example of the window:

Your client computers will also need to have PostgreSQL drivers as well. If you're doing this in Windows, you'll probably be using ODBC. The PostgreSQL ODBC drivers are here. Info on the connection string format can be found here.

Here's an example of what pgAdmin looks like:

edited Jul 27, 2014 at 7:14

answered Jul 27, 2014 at 6:41

Dave Cousineau

13.4k8 gold badges70 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Sarfaraz Makandar Over a year ago

Thanks. Can you put some image of GUI like pgAdmin?

Sarfaraz Makandar Over a year ago

Yup! I have ODBC drivers.

Sarfaraz Makandar Over a year ago

Sorry! But I am still confusing about this. What is that function gin_extract_trgm does?

Dave Cousineau Over a year ago

It's just a random example image from Google image search. If you mean what is the window, it looks like it's a properties window for a function. It allows the user to define a function (similar or maybe the same as a "stored procedure") using the GUI. The function itself is not shown, so I have no idea what it does. (Googling it, it seems to be a part of Postgres itself).

Sarfaraz Makandar Over a year ago

Okay! But I want to see the window or GUI through which we connect to other server from other system.

Collectives™ on Stack Overflow

PostgreSQL: One database to multiple user

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related