Re: can't connect to PostgreSQL Database using pgAdminII

I just went through this same thing today. You will also need to go
into your postgresql.conf file and set tcpip_socket=true and yes spaces
matter (tcpip_socket = true will not work).

jim

Telecontrol Networking wrote:

>did you started your database using the -i parameter ?
>
>send-me the startup string you are using.
>
>
>---------------------------------
>Marco Túlio Oliveira
>IT-Manager
>www.telecontrol.com.br
>----- Original Message -----
>From: "dojie pornea" <dojiep(at)yahoo(dot)com>
>To: <pgsql-admin(at)postgresql(dot)org>
>Sent: Thursday, November 13, 2003 11:39 AM
>Subject: [ADMIN] can't connect to PostgreSQL Database using pgAdminII
>
>
>
>
>>I already created the database, the services are good
>>as well as the network connection but still I can't
>>connect to the Database. I'm using pgAdminII for
>>win98. The errors I've encountered are listed below:
>>
>>
>>Could not connect to the server;
>>Could not connect to remote socket.
>>
>>Check each of the following possible causes of this
>>error:
>>- The server or port specified is incorrect.
>>
>>- The client workstation cannot establish a network
>>connection to the server. Try using 'ping' on the
>>workstation to check the network.
>>
>>- The server is not listening on a TCP/IP port. Make
>>sure that the postmaster was started with the -i
>>option, or that tcpip_socket = true is set in
>>$PGDATA/postgresql.conf.
>>
>>
>>__________________________________
>>Do you Yahoo!?
>>Protect your identity with Yahoo! Mail AddressGuard
>>http://antispam.yahoo.com/whatsnewfree
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>>
>>
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
>
>
>

--

Jim Bagley
Database Manager
Trader Electronic Media
(757) 321-8409 (work)
(757) 343-1768 (cell)

www.Employmentguide.com <http://www.employmentguide.com> - Bringing
Employers and Jobseekers Together.
www.ForRent.com <http://www.forrent.com> - Nation's Leading Apartment
Rental Source.
www.HarmonHomes.com <http://www.harmonhomes.com> - Your Home Site on the
Web.
www.ParenthoodWeb.com <http://www.parenthoodweb.com> - Pregnancy and
Parenting Advice, Baby Names and More.
www.Roomsaver.com <http://www.roomsaver.com> - 6000+ Lodging Coupons.
www.TraderOnline.com <http://www.traderonline.com> - Boats, RVs,
Collector Cars, Motorcycles and More.