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

Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database

From: John DeSoi <desoi(at)pgedit(dot)com>
To: NetSuporte <netsuporte(at)superig(dot)com(dot)br>
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: QT3 Designer Pgadmin III and PgAccess Cannot connect to PostgreSQL 7.4 database
Date: 2005-03-09 17:14:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Mar 9, 2005, at 12:02 PM, NetSuporte wrote:

> You are correct, here is the problem I inherited with this system and 
> it seem there are two different versions of postgresql here. One 
> install via the Debian package ( 7.4 ) with a different path than the 
> Postgresql directories I was trying to use they seem to be from 
> Postgresql ( 8.0.1). I thought I had 7.4 since the psql -V returned 
> that value.  Also I found two different paths . One is in 
> /usr/local/pgsql ( where the data directory is )  the other in  
> /usr/share/postgresql which has some configuration files,
> Since this discovery I think it might be best to remove all Postgresql 
> files and start over because when I try to run the 7.4 it says that 
> the files where created using 8.0.1. This way I won't be having so 
> many problems. Also I was told the data was no longer needed so I can 
> start over.
> Question is which version?

If you are starting over and there are no legacy issues to deal with, I 
highly recommend 8.0.1. It is very stable and includes lots of great 
new features over 7.4.

John DeSoi, Ph.D.
Power Tools for PostgreSQL

In response to

pgsql-novice by date

Next:From: Sean MontagueDate: 2005-03-09 17:29:02
Subject: Exporting Tables
Previous:From: Stephan SzaboDate: 2005-03-09 15:58:08
Subject: Re: Foreign key error, please help.

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