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 <drja...@alphagenius.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.kla...@aklaver.com> > Sent: Thursday, November 21, 2019 03:17 PM > To: Jason L. Amerson <drja...@alphagenius.org>; 'Tom Lane' < > t...@sss.pgh.pa.us> > Cc: 'Steve Crawford' <scrawf...@pinpointresearch.com>; 'PostgreSQL' < > pgsql-general@lists.postgresql.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 <t...@sss.pgh.pa.us> > > Sent: Thursday, November 21, 2019 02:42 PM > > To: Jason L. Amerson <drja...@alphagenius.org> > > Cc: 'Steve Crawford' <scrawf...@pinpointresearch.com>; 'Adrian Klaver' > > <adrian.kla...@aklaver.com>; 'PostgreSQL' > > <pgsql-general@lists.postgresql.org> > > Subject: Re: Remote Connection Help > > > > "Jason L. Amerson" <drja...@alphagenius.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.kla...@aklaver.com > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'
