Tamilarasu P
asked on
Postgresql Database remote connection
Hi,
Now i am using Postgre sql in one machine.more than 3 person want to access this postgresql database.So each & everytime login that postgresql machine.So can you please suggest application using connect postgresql db access remote like SQL Express database connect instance remote using SQL management studio.
Now i am using Postgre sql in one machine.more than 3 person want to access this postgresql database.So each & everytime login that postgresql machine.So can you please suggest application using connect postgresql db access remote like SQL Express database connect instance remote using SQL management studio.
Removed SQL Server and MongoDB topics.
ASKER
where to download this software(new server registration) @shailesh
ASKER
I have PostgreSQL .I want PostgreSQL remote connection like SQL management studio
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You try these options...
psql -h <host> -p <port> -u <database>
psql -h <host> -p <port> -U <username> -W <password> <database>
or
You will need to modify pg_hba.conf to allow remote connections to the database. Information about pg_hba.conf can be found below.
http://www.postgresql.org/
After that, you can connect programmatically with a connection string, 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.
http://www.connectionstrin
Thanks,
Shail