Thread: Windows 98 - getting (much) warmer
Thanks to Dave, I have IPC daemon running, 'initdb' doing its stuff. Postmaster starts and I have a 'pg_hba.conf' file. I started 'postmaster -i > pg_logfile 2>&1 &' I created (without error) another database 'createdb testdb'. But I still get an error when I try to psql into 'template1' or the new database. DEBUG: database system is in production state process_hba_record: invalid syntax in pg_hba.conf file Missing or erroneous pg_hba.conf file, see postmaster log for details -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au
[...] >DEBUG: database system is in production state >process_hba_record: invalid syntax in pg_hba.conf file >Missing or erroneous pg_hba.conf file, see postmaster log for details [...] And, and, what does it say ?! :)) (your pg_logfile I mean) 2 problems could cause this: a. you played with pg_hba.conf, but in this case you would have reverted the changes and had no problems; b. the CR/LF problem: either you have winzipped or pkunzipped the tar.gz distribution you have or you have "textmode" mountedthe place with pg_hba.conf. The CR/LF problem comes from the end-of-line character window apps use for ascii/textfiles, that doesn't match the unix apps use. SLao __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape!http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
"S. L." wrote: > > >DEBUG: database system is in production state > >process_hba_record: invalid syntax in pg_hba.conf file > >Missing or erroneous pg_hba.conf file, see postmaster log for details > [...] > And, and, what does it say ?! That is what it said?? This confused me a bit... The log file that tells you to look at itself? > a. you played with pg_hba.conf, but in this case you would have reverted the changes and had no problems; I think I did with the .sample file? ... does it use this to generate the new one? > b. the CR/LF problem: either you have winzipped or pkunzipped the tar.gz distribution you have or you have "textmode" mountedthe place with pg_hba.conf. The CR/LF problem comes from the end-of-line character window apps use for ascii/textfiles, that doesn't match the unix apps use. > the only non-commented lines are... host all 127.0.0.1 255.255.255.255 trust host all 192.168.0.0 255.255.255.0 trust -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au
Keith Gray wrote: > > "S. L." wrote: > > > > b. the CR/LF problem: now starts without error... but hangs in POSTGRES -- Keith Gray Technical Development Manager Heart Consulting Services P/L mailto:keith@heart.com.au