Postgres problem

[Hershel Fisch]

On 1/31/05 1:47 AM, "Pierre Sahores" <psahores at easynet.fr> wrote:

> Hello,
> 
> 1.- Prefer the Marc Liyanage's installers, if possible.
> 
> 2.- Take care to have the TCP/IP connections activated in the
> postgresql.conf pref file.
This is where all major problems started, before I edited the above file I
was able to connect locally , now I can't even start.
hershel
> 
> Best, Pierre
> 
> Le 31 janv. 05, à 06:13, Len Morgan a écrit :
> 
>> What version of Postgres are you using?
>> 
>> Have you tried connecting with psql (i.e., at the command line?) You
>> will need the -i flag (or setting the tcp/ip parameter in the
>> postgresql.conf file and restarting).
>> Also, is there any reason you aren't using pg_ctl to start the server?
>> I'm new to Revolution but I've using Postgresql since it was
>> Postgres95, so hopefully I've learned a little that could help you
>> out.
>> 
>> Len Morgan
>> 
>> 
>> Hershel Fisch wrote:
>> 
>>> Hi all, I'm trying to get my postgres to work on a network, I tried
>>> to mess
>>> around with the "pba_config" file
>>> host all all 0.0.0.0 trust
>>> started with "/usr/local/bin/postmaster -D /usr/local/pgsql/data -i"
>>> as I
>>> use it locally with RR and was not able to get it work on a network.
>>> I then tried to change the postgresql.config file and removed the "#
>>> " and
>>> changed tcp/ip to true , didn't do it . Then I changed it back to the
>>> way it
>>> was and Š then if I started it without the -Iflag it starts but
>>> wouldn¹t
>>> accept any tcp/ip connections even locally so I started it with the
>>> ˇI flag
>>> ,but wouldnÅt start "FATAL: postgresql.conf:1: syntax error,
>>> token="#"" .
>>> Now I can't start postgres with an -i flag at all.
>>> and how do I get the network working ? Mac 10.3.
>>> I really would appreciate the help.
>>> THANKS , A MILL. Hershel
>>> _______________________________________________
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>> 
>>> 
>>> 
>> 
>> 
>> 
>> -- 
>> No virus found in this outgoing message.
>> Checked by AVG Anti-Virus.
>> Version: 7.0.300 / Virus Database: 265.7.5 - Release Date: 1/26/2005
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
>>