RE: MS Access Frontend

2019-11-30 Thread Jason L. Amerson
. Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Saturday, November 30, 2019 01:52 PM To: Jason L. Amerson ; 'Martin Gainty' ; PostgreSQL Subject: Re: MS Access Frontend On 11/30/19 11:04 AM, Jason L. Amerson wrote: > Thanks Martin. I have decided to go another route

RE: MS Access Frontend

2019-11-30 Thread Jason L. Amerson
a different client. Jason L. Amerson From: Martin Gainty Sent: Saturday, November 30, 2019 08:02 AM To: Jason L. Amerson Subject: Re: MS Access Frontend Hi Jason this is how i got the majority of work in the 90s I have Database X that wont talk to Database Y you can write

MS Access Frontend

2019-11-29 Thread Jason L. Amerson
L. Amerson

RE: Remote Connection Help

2019-11-23 Thread Jason L. Amerson
made that much difference. Thanks again to everyone, Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Friday, November 22, 2019 01:11 PM To: Jason L. Amerson Cc: 'PostgreSQL' Subject: Re: Remote Connection Help On 11/22/19 8:27 AM, Jason L. Amerson wrote: > Whe

RE: Client Computers

2019-11-23 Thread Jason L. Amerson
Thanks Tim. Jason L. Amerson -Original Message- From: Tim Clarke Sent: Saturday, November 23, 2019 09:32 AM To: pgsql-general@lists.postgresql.org Subject: Re: Client Computers The ODBC drivers are generally very useful. Tim Clarke IT Director Direct: +44 (0)1376 504510 | Mobile

RE: Client Computers

2019-11-23 Thread Jason L. Amerson
Thanks Ron. Jason L. Amerson From: Ron Sent: Saturday, November 23, 2019 09:38 AM To: pgsql-general@lists.postgresql.org Subject: Re: Client Computers On 11/23/19 4:25 AM, Jason L. Amerson wrote: Do my Windows 10 computers that will be clients, need PostgreSQL installed

RE: Client Computers

2019-11-23 Thread Jason L. Amerson
Thanks Jason L. Amerson From: Daniel Baktiar Sent: Saturday, November 23, 2019 07:15 AM To: Jason L. Amerson Cc: PostgreSQL Subject: Re: Client Computers Hi Jason, AFAIK, you just need the pgadmin installed. Regards, Daniel On Sat, Nov 23, 2019 at 6:26 PM Jason L

Client Computers

2019-11-23 Thread Jason L. Amerson
Do my Windows 10 computers that will be clients, need PostgreSQL installed to connect remotely to my server or is pgAdmin or some other client all I need? Jason L. Amerson

RE: Remote Connection Help

2019-11-22 Thread Jason L. Amerson
any more of our time when I can just get rid of everything and start over. Also, do my Windows 10 computers that will be clients, need PostgreSQL installed in order to connect remotely to my server or is pgAdmin or some other client all I need? Jason L. Amerson -Original Message- From

RE: Remote Connection Help

2019-11-22 Thread Jason L. Amerson
with no confirmation or errors. Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Thursday, November 21, 2019 04:53 PM To: Jason L. Amerson Cc: 'Steve Crawford' ; 'PostgreSQL' Subject: Re: Remote Connection Help On 11/21/19 1:14 PM, Jason L. Amerson wrote: > 1) I have attac

RE: Remote Connection Help

2019-11-22 Thread Jason L. Amerson
. Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Thursday, November 21, 2019 04:32 PM To: Jason L. Amerson Cc: 'Steve Crawford' ; 'PostgreSQL' Subject: Re: Remote Connection Help On 11/21/19 1:14 PM, Jason L. Amerson wrote: > 1) I have attached a screenshot of the out

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
pg_settings show localhost. Jason L. Amerson -Original Message- From: Tom Lane Sent: Thursday, November 21, 2019 02:42 PM To: Jason L. Amerson Cc: 'Steve Crawford' ; 'Adrian Klaver' ; 'PostgreSQL' Subject: Re: Remote Connection Help "Jason L. Amerson" wri

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
in two different locations. I have one in "/usr/local/pgsql/data" and another set at "/etc/postgresql/9.4/main." I just discovered this situation. I edited both sets of files to have the same setting and still nothing. It seems that some-thing very screwy is going on. Jason L

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
t at “/etc/postgresql/9.4/main.” I just discovered this situation. I edited both sets of files to have the same setting and still nothing. It seems that something very screwy is going on. Jason L. Amerson From: Mark Johnson Sent: Thursday, November 21, 2019 02:02 PM To: Jason L. A

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
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? Jason L. Amerson -Origin

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
.” Jason L. Amerson From: Steve Crawford Sent: Thursday, November 21, 2019 12:05 PM To: Jason L. Amerson Cc: Adrian Klaver ; PostgreSQL Subject: Re: Remote Connection Help On Thu, Nov 21, 2019 at 8:48 AM Jason L. Amerson mailto:drja...@alphagenius.org> > wrote: 1

RE: ***SPAM*** Re: [SPAM] Remote Connection Help

2019-11-21 Thread Jason L. Amerson
I have removed the rules in the iptables and restarted it and got nothing. iptables is turned off and still nothing. Jason L. Amerson From: Moreno Andreo Sent: Thursday, November 21, 2019 11:27 AM To: pgsql-general@lists.postgresql.org Subject: ***SPAM*** Re: [SPAM] Remote Connection

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
using the static IP with SSH. 3) It is my own physical machine. It is running Ubuntu and has a static IP. Jason L. Amerson -Original Message- From: Adrian Klaver Sent: Thursday, November 21, 2019 11:11 AM To: Jason L. Amerson ; 'PostgreSQL' Subject: Re: Remote Connection Help On 11/21

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
Ubuntu machine. Jason L. Amerson From: Steve Atkins Sent: Thursday, November 21, 2019 09:49 AM To: pgsql-general@lists.postgresql.org Subject: Re: Remote Connection Help On 21/11/2019 14:30, Ekaterina Amez wrote: El 21/11/19 a las 15:21, Jason L. Amerson escribió: I am

RE: Remote Connection Help

2019-11-21 Thread Jason L. Amerson
-h xx.xx.xx.xx" while using my Ubuntu machine. Jason L. Amerson From: Jason L. Amerson Sent: Thursday, November 21, 2019 09:22 AM To: PostgreSQL Subject: Remote Connection Help I am at a loss for what to do. I have read article after article about how to allow remote connecti

Remote Connection Help

2019-11-21 Thread Jason L. Amerson
I am at a loss for what to do. I have read article after article about how to allow remote connections on my PostgreSQL server and none of what the articles say do, worked for me. I have edited the "postgresql.conf" file and changed "listen_address = 'localhost' to listen_address = '*'. I have