Connecting to PostGreSQL on same machine: Mac OSX

[Hershel Fisch]

On Friday, December 10, 2004, at 11:51 PM, Sivakatirswami wrote:

> Alright... I've successfully installed PostGreSQL on my mac... in the  
> terminal it's up and running, I've created a database and just now did
>
> select * from taskroster
>
> and got my two test rows returned... but..
>
> in the Mac's activity monitor... i don't see a process named "Postgres"
> just the tcsh shell I have open to talk to Postgres...
>
> And also, in rev, this fails:
>
>  put  
> revOpenDatabase("Postgresql","localhost","katir_test","postgres","myPas 
> sWord")
>
> could not connect to server: Connection refused
> 	Is the server running on host "localhost" and accepting
> 	TCP/IP connections on port 5432?
Hi , in order to run thru a tcp/ip connection it has to be enabled  
first , to do so eithre you enable the tcp/ip or you start it
with an -I flag.
su - postgres
password
postgres% "/usr/local/bin/postmaster -D /usr/local/pgsql/data –I" (  
this is the -I flag you enter)
Hershel Fisch



>
> my computer name on the lan is "katir.hindu.org"  but
>
>  put  
> revOpenDatabase("Postgresql","katir.hindu.org","katir_test","postgres", 
> "myPassWord")
>
> does not work either..
>
> I'm sure this must be simple...
>
> TIA
>
> Sannyasin Sivakatirswami
> Himalayan Academy Publications
> at Kauai's Hindu Monastery
> katir at hindu.org
>
> www.HimalayanAcademy.com,
> www.HinduismToday.com
> www.Gurudeva.org
> www.Hindu.org
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>