Re: Remote Connection Help

change your listen_on setting to '*'
and add an entry to your hosts file for your machine.something like this:
192.168.1.10 thuban.mydomain thuban
Replace 192.168.1.10 with your ip address.

On Thu, Nov 21, 2019 at 3:14 PM Jason L. Amerson <drjason(at)alphagenius(dot)org>
wrote:

> 1) I have attached a screenshot of the output of "ps ax | grep post" on
> the Ubuntu machine.
>
> 2) Since I was new to PostgreSQL, I followed a tutorial online. I did
> install from source which I already knew how to do. I got the source
> package from PostgreSQL. I basically followed these instructions:
>
> sudo ./configure
> make world
> su
> make install
> adduser postgres
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
> /usr/local/pgsql/bin/createdb test
> /usr/local/pgsql/bin/psql test
>
> Then I set the following environment variables:
>
> LD_LIBRARY_PATH=/usr/local/pgsql/lib
> export LD_LIBRARY_PATH
>
> PATH=/usr/local/pgsql/bin:$PATH
> export PATH
>
> MANPATH=/usr/local/pgsql/share/man:$MANPATH
> export MANPATH
>
> Jason L. Amerson
>
>
> -----Original Message-----
> From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> Sent: Thursday, November 21, 2019 03:17 PM
> To: Jason L. Amerson <drjason(at)alphagenius(dot)org>; 'Tom Lane' <
> tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Cc: 'Steve Crawford' <scrawford(at)pinpointresearch(dot)com>; 'PostgreSQL' <
> pgsql-general(at)lists(dot)postgresql(dot)org>
> Subject: Re: Remote Connection Help
>
> On 11/21/19 12:07 PM, Jason L. Amerson wrote:
> > pg_settings show localhost.
>
> Lets back up a bit and:
>
> 1) Show output of ps ax | grep post on Ubuntu machine.
>
> 2) Explain how you installed Postgres, source, package and if package from
> what repo?
>
> >
> > Jason L. Amerson
> >
> >
> > -----Original Message-----
> > From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> > Sent: Thursday, November 21, 2019 02:42 PM
> > To: Jason L. Amerson <drjason(at)alphagenius(dot)org>
> > Cc: 'Steve Crawford' <scrawford(at)pinpointresearch(dot)com>; 'Adrian Klaver'
> > <adrian(dot)klaver(at)aklaver(dot)com>; 'PostgreSQL'
> > <pgsql-general(at)lists(dot)postgresql(dot)org>
> > Subject: Re: Remote Connection Help
> >
> > "Jason L. Amerson" <drjason(at)alphagenius(dot)org> writes:
> >> Yes "listen_addresses" is not commented. I did notice when I did the
> > netstat, for tcp, it was all "127.0.0.1" on various ports including
> > 5432 but I have a listing for tcp6 that has my static IP using port
> > 32305. Would that make a difference?
> >
> > Hm, well, *something* is overriding the setting. What did you find in
> > pg_settings?
> >
> > regards, tom lane
> >
> >
> >
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'