From: | "Jason L(dot) Amerson" <drjason(at)alphagenius(dot)org> |
---|---|
To: | "'Adrian Klaver'" <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | "'Steve Crawford'" <scrawford(at)pinpointresearch(dot)com>, "'PostgreSQL'" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Remote Connection Help |
Date: | 2019-11-21 21:14:17 |
Message-ID: | !&!AAAAAAAAAAAuAAAAAAAAAGmIF169jV1Ig2e+e0GOo/YBAMO2jhD3dRHOtM0AqgC7tuYAAAAAAA4AABAAAABM2v1p8+7ITIOK7/K4ym/CAQAAAAA=@alphagenius.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
Attachment | Content-Type | Size |
---|---|---|
PS AX.jpg | image/jpeg | 706.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Kerber | 2019-11-21 21:22:55 | Re: Remote Connection Help |
Previous Message | Jason L. Amerson | 2019-11-21 21:05:34 | RE: Remote Connection Help |