Search Postgresql Archives

Re: version problem with pg_dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux