Re: Accessing Postgres Server and database from other Machine

On 12/4/20 2:27 AM, Muthukumar.GK 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.

That is the wrong file, the *.sample is the giveaway. Assuming you are
on Windows the correct file is:

C:\Program Files\PostgeSQL\13\data\postgresql

Un-comment and change setting there and then restart server.

> 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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com