Liam;
I'm having additional problems that I thought might be attributable to the clumsy way I set up PostgreSQL, so I thought I'd run postmaster -i as you suggested.
When I try to run "postmaster -i" logged in as root, Linux slaps my wrist with:
"root" execution of the PostgreSQL server is not permitted.
The server must be started under an unprivileged user id to prevent
a possible system security compromise. See the documentation for
more information on how to properly start the server.
Can you point me to the proper way to run this command? Sorry for my ignorance with Linux and PostgreSQL.
>Michael,
>
>Have you started postmaster with the -i argument? If not, non-local users won't be able to connect.
>
>Regards,
>
>Liam
>
>
>>Hi, Leland - thanks for the response.
>>
>>Hmmm... Still getting 'Connectivity Error'. I can ping the Linux box, and I have a user set up. I have allowed all hosts on my internal IP (192.168.1.XXX). I'm using the default port address - what else might I have missed?
>>
>>TIA
>>
>>>Hi Michael,
>>>
>>>I don't use the postgres ODBC even though I have it installed on my system. I use a DSN_less connection like:
>>>
>>>
>>>if is_remote = .T.
>>> mystring="DATABASE=vfp2pg;SERVER=68.15.242.97; port=5432;UID=VfP2Pg;pwd=;provider=MSDASQLR;DRIVER=postgreSQL;"
>>>else
>>> mystring="DATABASE=vfp2pg;SERVER=192.168.1.78; port=5432;UID=VfP2Pg;pwd=;provider=MSDASQLR;DRIVER=postgreSQL;"
>>>endif
>>>
>>>oConnection=SQLSTRINGCONNECT(mystring)
>>>
>>>
>>>I have an example app that can be downloaded from my site that uses a VFP7 front-end to a postgres backend server. The Name of the download is smsql.ZIP. You might take a look at it as something that might help you get started. My site is:
>>>
>>>
https://www.smvfp.com>>>
>>>LelandJ
Kogo Michael Hogan
"Pinky, are you pondering what I'm pondering?"
I think so Brain, but "Snowball for Windows"?
Ideate Web Site