Re: Accessing Postgres Server and database from other Machine

On 04/12/2020 12:56, Hemil Ruparel wrote:
I dont think you can use pgAdmin to do that kind of thing but I may be wrong. Google how to restart a service in Windows and then restart postgres

On Fri, Dec 4, 2020 at 5:36 PM Muthukumar.GK <muthankumar(at)gmail(dot)com<mailto:muthankumar(at)gmail(dot)com>> wrote:
No.I did not restart postgres.Please let me know the steps to restart postgres using pgadmin4 tool.

On Fri, Dec 4, 2020 at 5:26 PM Hemil Ruparel <hemilruparel2002(at)gmail(dot)com<mailto:hemilruparel2002(at)gmail(dot)com>> wrote:
Are you sure you restarted postgres after the change in configuration?

On Fri, Dec 4, 2020 at 3:58 PM Muthukumar.GK <muthankumar(at)gmail(dot)com<mailto:muthankumar(at)gmail(dot)com>> wrote:
Hi Team,

I have created Database in postgresqlv13 . My Office colleague needs to access my postgres server and database from his machine. There is a config file called 'Postgresql.conf.sample' in program files folder. Even if I changed the connection settings of listen address from localhost to *( Connection Settings - #Listen address ='*' ) in config file. But still my colleague is not able to connect it. Kindly provide some guidance on this.

Regards
Muthu

It looks to me like the line is still commented out (as it is by default). Remove any "#" (hash or pound) symbol from the beginning of the line then restart Postgres.

Tim Clarke MBCS
IT Director
Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420

Telephone: Witham: +44(0)1376 503500 | London: +44 (0)20 3009 0853 | Frankfurt: +49 (0)69 7191 6000 | Hong Kong: +852 5803 1687 | Toronto: +1 647 503 2848
Web: https://www.manifest.co.uk/

Minerva Analytics Ltd - A Solactive Company
9 Freebournes Court | Newland Street | Witham | Essex | CM8 2BL | United Kingdom

________________________________

Copyright: This e-mail may contain confidential or legally privileged information. If you are not the named addressee you must not use or disclose such information, instead please report it to admin(at)minerva(dot)info<mailto:admin(at)minerva(dot)info>
Legal: Minerva Analytics is the trading name of: Minerva Analytics Ltd: Registered in England Number 11260966 & The Manifest Voting Agency Ltd: Registered in England Number 2920820 Registered Office at above address. Please Click Here https://www.manifest.co.uk/legal/ for further information.