Re: Accessing Postgres Server and database from other Machine

Поиск
Список
Период
Сортировка
От Tim Clarke
Тема Re: Accessing Postgres Server and database from other Machine
Дата
Msg-id eb0c2eb6-faea-c4bc-86f8-4d4bb80930ab@minerva.info
обсуждение исходный текст
Ответ на Re: Accessing Postgres Server and database from other Machine  (Hemil Ruparel <hemilruparel2002@gmail.com>)
Список pgsql-general
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@gmail.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@gmail.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@gmail.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@minerva.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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Hemil Ruparel
Дата:
Сообщение: Re: Accessing Postgres Server and database from other Machine
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Accessing Postgres Server and database from other Machine