Postgres problem

[Sivakatirswami]

Aloha, Hershel:

Interesting, you described almost word for word what I went through on 
my mac.. the business about pg_ctl not working is mysterious... I have 
the same problem... but I *can* start postgresql now with this:

/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

and it works fine.

good luck.

Sivakatirswami
www.himalayanacademy.com


On Jan 31, 2005, at 6:49 AM, Hershel Fisch wrote:

> 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
>>>
>>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>