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.klaver@xxxxxxxxxxx> Sent: Thursday, November 21, 2019 03:17 PM To: Jason L. Amerson <drjason@xxxxxxxxxxxxxxx>; 'Tom Lane' <tgl@xxxxxxxxxxxxx> Cc: 'Steve Crawford' <scrawford@xxxxxxxxxxxxxxxxxxxx>; 'PostgreSQL' <pgsql-general@xxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx> > Sent: Thursday, November 21, 2019 02:42 PM > To: Jason L. Amerson <drjason@xxxxxxxxxxxxxxx> > Cc: 'Steve Crawford' <scrawford@xxxxxxxxxxxxxxxxxxxx>; 'Adrian Klaver' > <adrian.klaver@xxxxxxxxxxx>; 'PostgreSQL' > <pgsql-general@xxxxxxxxxxxxxxxxxxxx> > Subject: Re: Remote Connection Help > > "Jason L. Amerson" <drjason@xxxxxxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
Attachment:
PS AX.jpg
Description: JPEG image
