Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Greg Smith
Christine Penner wrote: I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres installed I have this in

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Chris Barnes
:49 -0800 > To: raand...@cyber-office.net; pgsql-general@postgresql.org > From: christ...@ingenioussoftware.com > Subject: Re: [GENERAL] Connect to Postgres problems > > I set up port forwarding. I assume that means all IP addresses using > port 5432 will be sent to my lap

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Christine Penner
I set up port forwarding. I assume that means all IP addresses using port 5432 will be sent to my laptop (that Postgres is running on). I don't remember setting up permissions for a specific IP in the router but it was a while ago so I could be wrong. When I get home I will have another look at

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Adrian Klaver
On 02/01/2010 09:16 AM, Christine Penner wrote: When we try to connect we don't get a specific error, just that it can't connect. I'm not sure what logs to look in or on what end. Christine Logging is set up in postgresql.conf per the comments in the file and for more information: http://

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Roderick A. Anderson
Christine Penner wrote: Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres installed I have thi

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Chris Barnes
> Date: Mon, 1 Feb 2010 09:13:34 -0800 > From: adrian.kla...@gmail.com > To: christ...@ingenioussoftware.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Connect to Postgres problems > > On 02/01/2010 09:10 AM, Christine Penner wrote: > > I have re start

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Christine Penner
When we try to connect we don't get a specific error, just that it can't connect. I'm not sure what logs to look in or on what end. Christine At 09:13 AM 01/02/2010, you wrote: On 02/01/2010 09:10 AM, Christine Penner wrote: I have re started the computer (a few times) since I did all that.

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Adrian Klaver
On 02/01/2010 09:10 AM, Christine Penner wrote: I have re started the computer (a few times) since I did all that. Christine What is the error that you are seeing on the client and in the logs? -- Adrian Klaver adrian.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Christine Penner
I have re started the computer (a few times) since I did all that. Christine At 09:08 AM 01/02/2010, you wrote: On 02/01/2010 08:36 AM, Christine Penner wrote: Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. T

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Rodrigo Gonzalez
Did you reload postgres configuration after changing pg_hba.conf? On Mon, 2010-02-01 at 08:36 -0800, Christine Penner wrote: > Hi, > > I'm having trouble getting a connection to Postgres to work from > outside of my local network. It was working fine at one point. Then I > had to change IP add

Re: [GENERAL] Connect to Postgres problems

2010-02-01 Thread Adrian Klaver
On 02/01/2010 08:36 AM, Christine Penner wrote: Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres

[GENERAL] Connect to Postgres problems

2010-02-01 Thread Christine Penner
Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres installed I have this in the pg_hba.conf file