Re: PostgreSQL 8.3

From: Johann Spies <jspies(at)sun(dot)ac(dot)za>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL 8.3
Date: 2009-09-17 13:38:46
Message-ID: 20090917133846.GB8645@sun.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Sep 17, 2009 at 11:53:10AM +0200, Johan Greyling wrote:

> I ahve PostgreSQL 8.3 installed, after I restart my pc, using the
> pgAdminIII it gives me connection...failed
>
> What can I do?

My first reaction would be to check whether the server is running
e.g. nmap localhost -p 5432

On my pc this shows:
Starting Nmap 4.68 ( http://nmap.org ) at 2009-09-17 15:31 SAST
Warning: Hostname localhost resolves to 2 IPs. Using 127.0.0.1.
Interesting ports on localhost (127.0.0.1):
PORT STATE SERVICE
5432/tcp open postgresql

Are you running pgAdminIII as a user that should be able to connect to
the database? And did you configure the connection details correctly
within PGAdminIII?

Regards
Johann

--
Johann Spies Telefoon: 021-808 4599
Informasietegnologie, Universiteit van Stellenbosch

"Honour the LORD with thy substance, and with the
firstfruits of all thine increase: So shall thy barns
be filled with plenty, and thy presses shall burst out
with new wine." Proverbs 3:9,10

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2009-09-17 13:57:08 Re: Loss of table structure on 7.3.19
Previous Message Andre Rothe 2009-09-17 13:36:46 Wrong column default values