Re: Accessing Postgres Server and database from other Machine

lol. Been there. Done that

On Sat, Dec 5, 2020 at 1:36 AM Nicklas Avén <nicklas(dot)aven(at)jordogskog(dot)no>
wrote:

>
>
> On 4 December 2020 17:17:48 CET, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
> >On 12/4/20 8:03 AM, Paul Förster wrote:
> >> Hi Adrian,
> >>
> >>> On 04. Dec, 2020, at 16:13, Adrian Klaver
> ><adrian(dot)klaver(at)aklaver(dot)com> wrote:
> >>> That is the wrong file, the *.sample is the giveaway.
> >>
> >> hmmm, I'd rather call it essential reference documentation or
> >template for automation. It's perfectly well suited to automatically
> >strip all comments and then diff the result to ones real world
> >postgresql.conf or some other version postgresql.conf file to find
> >parameters that have been removed or changed with a new PostgreSQL
> >version. This is highly useful for planning migrations and have a quick
> >reference what to check for before actually migrating. So for me this
> >is much more than just a giveaway.
> >>
> >
> >Yes, but for changing the behavior of a running instance it is the
> >wrong
> >file and it's extension is a clue.
>
>
> You will prabably also need to change in tge pg_hba.conf file. At least in
> linux there is no entry for connections from the outside there. You will
> need a "host" entry accepting any ip address or specify what ip your
> collegue is connecting from if possible. I have missed this step a few
> times and banged my head.
>
> /Nicklas
>
>
>