Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Steve Crawford
My quick-n-dirty "fix" is to make symbolic links in /usr/bin for all pg programs: But, as I noted, only after you are sure you have removed all vestiges of the old version. The symbolic links are just a convenience. The *right* solution if you're using an RPM-based Linux distro is to grab an

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Tom Lane
Steve Crawford <[EMAIL PROTECTED]> writes: > Brian Kitzberger wrote: >> It worked fine. I was able to create a database from a DDL I wrote and >> do insert into the tables and selects with correct results. So I was >> testing the pg_dump with I ran into problems. > And had you run /usr/local/pgs

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Steve Crawford
Brian Kitzberger wrote: Steve, You asked how I built the my install of 8.1.3. With the tar files at the root, I used the gunzip and tar commands from the web site on the base, docs, opt, and test tar files as suggested by the PostgreSQL.org web site, which made the postgresql-8.1.3 directory.

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Scott Marlowe
On Thu, 2006-03-23 at 15:32, Brian Kitzberger wrote: > Steve, > > Okay, not only am I new to PostgreSQL but I am new to Linux with a > little experience years ago with Unix. So I didn't know about rpm nor > does any one else here. But anyway, the result of running rpm is: Hey, we all started so

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Brian Kitzberger
Steve, You asked how I built the my install of 8.1.3. With the tar files at the root, I used the gunzip and tar commands from the web site on the base, docs, opt, and test tar files as suggested by the PostgreSQL.org web site, which made the postgresql-8.1.3 directory. I then did the steps sugge

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Alan Hodgson
On March 23, 2006 01:32 pm, "Brian Kitzberger" <[EMAIL PROTECTED]> wrote: > Steve, > > Okay, not only am I new to PostgreSQL but I am new to Linux with a > little experience years ago with Unix. So I didn't know about rpm nor > does any one else here. But anyway, the result of running rpm is: >

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Brian Kitzberger
Steve, Okay, not only am I new to PostgreSQL but I am new to Linux with a little experience years ago with Unix. So I didn't know about rpm nor does any one else here. But anyway, the result of running rpm is: postgresql-libs-7.4.8-0.6 postgresql-server-7.4.8-0.6 postgresql-jdbc-7.3-189.1 postg

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Steve Crawford
Brian Kitzberger wrote: Hi Steve, pg_dump --versionreturned 7.4.8 pg_dumpall --version returned 7.4.8 psql *version returned 7.4.8 which pg_dump returned /usr/bin/pg_dump which pg_dumpall returned /usr/bin/pg_dump which psql returned /usr/bin/psql To find the file I used from the root

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Tom Lane
"Brian Kitzberger" <[EMAIL PROTECTED]> writes: > which pg_dump returned /usr/bin/pg_dump > which pg_dumpall returned /usr/bin/pg_dump > which psql returned /usr/bin/psql Didn't you say that you had installed PG 8.1.3 in a separate directory tree (something about postgresql-8.1.3)? Maybe your

Re: [GENERAL] version problem with pg_dump

2006-03-23 Thread Brian Kitzberger
Hi Steve, pg_dump --versionreturned 7.4.8 pg_dumpall --version returned 7.4.8 psql *version returned 7.4.8 which pg_dump returned /usr/bin/pg_dump which pg_dumpall returned /usr/bin/pg_dump which psql returned /usr/bin/psql To find the file I used from the root find . -name pg_dump I