0

How client can connect production PostgreSQL database server remotely.

In client system there is no PostgreSQL installed.

user4287146
  • 179
  • 1
  • 1
  • 7
  • by just replace local host with production db Ip address – smali Jul 20 '16 at 12:09
  • The connection to a remote server is the same as to a "local" server: you specify the hostname (or IP address) of the server where Postgres is running –  Jul 20 '16 at 12:19
  • client will not have pg admin and we need to provide only select permission to him. – user4287146 Jul 20 '16 at 12:24
  • we are product based company ,we have production database , the client (XYZ) want to access the database to write sql and generate reports, i need to tell them how to access the production database with only select permission. – user4287146 Jul 20 '16 at 12:32

1 Answers1

0

By just replace localhost or 127.0.0.1 with production db IP address

If you want to connect it from IDE use Squirrel SQL or other Postgres DB clients to connect it.

good postgresql client for windows?

Your DB should be publicly accessible, or create a VPN setup between, and then you can use any of the above sql-client softwares

Community
  • 1
  • 1
smali
  • 4,687
  • 7
  • 38
  • 60
  • Client will not use pg admin, how to connect in other way. – user4287146 Jul 20 '16 at 12:15
  • can you elaborate who is client and how they want to access it? – smali Jul 20 '16 at 12:17
  • we are product based company ,we have production database , the client (XYZ) want to access the database to write sql and generate reports, i need to tell them how to access the production database with only select permission. – user4287146 Jul 20 '16 at 12:29