[GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
Hi All, I was wondering if anyone has had this problem and knows an answer. This is the first time I have used postgres so I am at a loss after trying many things as to how to solve the problem. I've unremmed the line hba_file = 'ConfigDir/pg_hba.conf' in the postgresql.conf file as I want to

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Chris
Alan Deane wrote: Hi All, I was wondering if anyone has had this problem and knows an answer. This is the first time I have used postgres so I am at a loss after trying many things as to how to solve the problem. I've unremmed the line hba_file = 'ConfigDir/pg_hba.conf' in the

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
: pgsql-general@postgresql.org Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' Alan Deane wrote: Hi All, I was wondering if anyone has had this problem and knows an answer. This is the first time I have used postgres so I am at a loss after trying

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Chris
Alan Deane wrote: Hi Chris, Thanks for your reply. Maybe I should have reworded it slightly better or fuller. I assumed that having ConfigDir/pg_hba.conf line in postgresql.conf would look for the hba file in the directory relative to where postgres is installed. I.e. the data directory and

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Scott Mead
Re-REM (called commenting for us non-windows geeks :-) the line Look in your data directory, the file exists and is used automatically, you don't need to point the postgresql.conf file to it explicitly. Look at: http://www.postgresql.org/docs/8.3/interactive/client-authentication.html For

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
. _ From: Scott Mead [mailto:scott.li...@enterprisedb.com] Sent: 30 July 2009 01:14 To: a...@anitltd.co.uk Cc: Chris; pgsql-general@postgresql.org Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' Re-REM (called commenting for us non-windows geeks

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' Alan Deane wrote: Hi Chris, Thanks for your reply. Maybe I should have reworded it slightly better or fuller. I assumed that having ConfigDir/pg_hba.conf line in postgresql.conf would look for the hba file in the directory

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Chris
Alan Deane wrote: Sorry, yes the error, Doh!. Standard Server doesn't Listen (sounds like my ex :)) Here it is in full. Server doesn't listen could not connect to server; Connection timed out (0x274C/10060) Is the server running on host 192.168.2.99 and accepting TCP/IP connection on

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Scott Mead
-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Sent: 30 July 2009 01:23 To: a...@anitltd.co.uk Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' Alan Deane wrote: Hi Chris

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Sent: 30 July 2009 02:23 To: a...@anitltd.co.uk Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' On Wed, Jul 29, 2009 at 9:14 PM, Alan Deane a...@anitltd.co.uk wrote: Sorry, yes the error, Doh!. Standard Server doesn't Listen (sounds like my ex :)) Here it is in full. Server doesn't listen could not connect

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' Hi Chris, I can connect to the server locally with PgAdmin using localhost: 5432 192.168.2.99: 5432 127.0.0.1 : 5432 As for the Windows event logs they are all fine. The server logs. Look OK except for %LOG: invalid length

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Alan Deane
-general-ow...@postgresql.org] On Behalf Of Alan Deane Sent: 30 July 2009 03:15 To: a...@anitltd.co.uk; 'Chris' Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf' Ok, I have just had a look at the firewall network monitor

Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'

2009-07-29 Thread Scott Mead
. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Chris Sent: 30 July 2009 01:23 To: a...@anitltd.co.uk Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] V8.3 fails to start after unremming hba_file = 'ConfigDir