Connecting to PostgreSQL DB?

Pierre Sahores psahores at easynet.fr
Tue Aug 26 11:27:00 EDT 2003


Allo Peter,

Postgres is to the SGBDR what Rev/MC are to development : a very great
ACID RDBMS, always more powerfull than needed and never down. Have fun
!!!

Bests, Pierre

Le mar 26/08/2003 à 17:41, Peter Reid a écrit :
> Alex & Pierre
> 
> Thank you both for guiding the blind!  You were both correct, I 
> needed to enable the tcpip_socket option.  However, despite several 
> "pg_ctl reload" attempts, the running copy of PostgreSQL wouldn't 
> listen on port 5432.  In the end I rebooted my iMac (acting as a db 
> server) and restarted a new session of PostgreSQL.  this sorted it!
> 
> I can now connect using Rev 2.1 as well as using the admin tools I mentioned.
> 
> Thanks again.
> 
> Best regards
> 
> Peter
> 
> >Make sure that pgsql is indeed running on port 5432. I could be 
> >wrong, but I think the default installation of pgsql runs with 
> >tcp/ip socket off, and only running a local unix domain socket. 
> >Opening the daemon on 5432 requires explicit configuration in 
> >postgresql.conf. see also pg_hba.conf.
> >
> >You can try "telnet localhost 5432" to see if there is anything 
> >listening on that port and rule out whether it's a firewall issue or 
> >just nothing is listening on 5432.
> >
> >Alex Rice, Software Developer
> >Architectural Research Consultants, Inc.
> >http://ARCplanning.com
> 
> 
> >Have an eye on your "../pgsql/data/postgresql.conf" file and do test in
> >the first lines of it by activing the TCP/IP connection and so :
> >
> >
> >>  #       Connection Parameters
> >>  #
> >>  #tcpip_socket = false
> >>  tcpip_socket = true
> >>
> >>  #ssl = false
> >>
> >>  #max_connections = 32
> >>  #superuser_reserved_connections = 2
> >>
> >>  #port = 5432
> >>  port = 5432
> >
> >Bests Regards, Pierre
> >--
> >Bien cordialement, Pierre Sahores
> >
> >Inspection académique de Seine-Saint-Denis
> >Applications et SGBD ACID SQL (WEB et PGI)
> >Penser et produire "delta de rentabilité"




More information about the use-livecode mailing list