Re: Postgres problem

2005-01-31 Thread 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

Re: Postgres problem

2005-01-31 Thread Thomas Gutzmann
On Mon, 31 Jan 2005 11:31:07 -0500 Hershel Fisch <[EMAIL PROTECTED]> wrote: hostall all ::1 :::::::trust What are all these 's for ? IPv6 ... pretty useless currently :-) ___ use-revolution

Re: Postgres problem

2005-01-31 Thread Hershel Fisch
On 1/31/05 1:47 AM, "Pierre Sahores" <[EMAIL PROTECTED]> 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

Re: Postgres problem

2005-01-31 Thread Hershel Fisch
On 1/31/05 1:28 AM, "Thomas Gutzmann" <[EMAIL PROTECTED]> wrote: > Hi Hershel, > > on my mac it works with: > > pg_ctl start -D /usr/local/pgsql/data -l /usr/local/pgsql/logfile -o -i On this one I get , "pg_ctl: command not found. > & > > local all all > trust > hostall

Re: Postgres problem

2005-01-31 Thread Hershel Fisch
On 1/31/05 12:13 AM, "Len Morgan" <[EMAIL PROTECTED]> wrote: > 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). That's exactly wh

Re: Postgres problem

2005-01-31 Thread Hershel Fisch
On 1/31/05 1:28 AM, "Thomas Gutzmann" <[EMAIL PROTECTED]> wrote: > Hi Hershel, > > on my mac it works with: > > pg_ctl start -D /usr/local/pgsql/data -l /usr/local/pgsql/logfile -o -i > & > > local all all > trust > hostall all 127.0.0.1 255.255.255.255 > t

Re: Postgres problem

2005-01-30 Thread Pierre Sahores
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. 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

Re: Postgres problem

2005-01-30 Thread Thomas Gutzmann
Hi Hershel, on my mac it works with: pg_ctl start -D /usr/local/pgsql/data -l /usr/local/pgsql/logfile -o -i & local all all trust hostall all 127.0.0.1 255.255.255.255 trust hostall all 10.0

Re: Postgres problem

2005-01-30 Thread Len Morgan
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 Revol

Postgres problem

2005-01-30 Thread Hershel Fisch
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