Skip site navigation (1) Skip section navigation (2)

Re: Postgresql for Dummies?

From: Ron St-Pierre <rstpierre(at)syscor(dot)com>
To: Daniel Lerch <daniel(at)mountainmeasurement(dot)com>,pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgresql for Dummies?
Date: 2004-10-12 21:07:38
Message-ID: 416C479A.2090702@syscor.com (view raw or flat)
Thread:
Lists: pgsql-novice
Daniel Lerch wrote:

> OK, I'll check that book out.
>
> I tried running pgAdminIII, but when I tried to connect to my psql  
> server I got the error:
> "SSL error: wrong version number" 

An SSL error....?

>
> I'll try to figure this out, but one thing it led me to was realizing 
> that I don't know what verision of psql I'm actually running, and I 
> don't know how to find out (I noticed that pgAdminIII is for 
> postgreSQL 7.3 and 7.4).  Is there a 'version' command within psql? 

psql --version
     psql (PostgreSQL) 7.4.1
     contains support for command-line editing
or from within psql
select version();
                                 version
     ---------------------------------------------------------------
      PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
     (1 row)

If you've got an earlier version of postgres you can download the 
appropriate pgAdmin version (pgAdminII probably), which used to be 
available on the website http://pgadmin.postgresql.org/pgadmin2/downloads/

Ron

>
>
> Thanks,
> -d
>
>> I suggest that you visit a bookstore and actually look at some of the 
>> postgres books out there. I've got Practical Postgres (Worsley & 
>> Drake) and it would probably be suitable for you. While many of these 
>> books are aimed at developers quite a few of them also spell out a 
>> lot of the basics too, so they'll tell you about SQL and how to use 
>> postgres. There are a handful of beginner-intermediate postgresql 
>> books out there, including Bruce Momjian's book Learning PostgreSQL 
>> (forgive me if I get this wrong).
>>
>> Also, pgAdminIII is a good gui tool for accessing postgres.
>>
>> Ron
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>



In response to

Responses

pgsql-novice by date

Next:From: Bruno Wolff IIIDate: 2004-10-13 03:36:41
Subject: Re: Postgresql for Dummies?
Previous:From: Daniel LerchDate: 2004-10-12 20:54:16
Subject: Re: Postgresql for Dummies?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group