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.
http://pgedit.com/
Power Tools for PostgreSQL