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 suggested to do the install with slight variation. ./configure (I had to use the option --without-readline because it gave an error without it) gmake su gmake install useradd postgres mkdir /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su - postgres /usr/local/pgsql/bin/initdb -i -D /usr/local/pgsql/data (the -i options was suggesed) /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data >logfile 2>&1 & /usr/local/pgsql/bin/psql test 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. Brian >>> Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> 3/23/2006 12:50 PM >>> Brian Kitzberger wrote: > Hi Steve, > > pg_dump --version returned 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 It would be unusual for the files to be in those locations if you did the usual "./configure ; make ; make install". How, exactly, did you install PostgreSQL? As Scott suggested, try running "rpm -qa | grep -i postgres" (assuming rpm is at the core of your package management) and when you find that it was already installed, use rpm to erase it. Here, things can get interesting. While you may not have intentionally installed PostgreSQL, your package manager may have installed it for you to solve a dependency (PHP with PG support or some app that requires PG for example) you may find your package manager complaining about dependencies when you try to remove it. But worry about burning that bridge when you get to it. Cheers, Steve
