Обсуждение: Re: version problem with pg_dump
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 postgresql-7.4.8-0.6 qt3-postgresql-3.3.1-35.11 I did an ls in the /usr/bin directory and sure enough there are the other files I could not find before. So I guess I will have to cross the bridge. As a test, I just mv the file /usr/bin/pg_dump. If rpm had a dependence on that file would it cause some kind of error message in trying to move it? I was able to successfully move the file to the root. Brian >>> Steve Crawford <scrawford@pinpointresearch.com> 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
On March 23, 2006 01:32 pm, "Brian Kitzberger" <KITZBERGERB@mail.co.stanislaus.ca.us> 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: > > postgresql-libs-7.4.8-0.6 > postgresql-server-7.4.8-0.6 > postgresql-jdbc-7.3-189.1 > postgresql-7.4.8-0.6 > qt3-postgresql-3.3.1-35.11 > > I did an ls in the /usr/bin directory and sure enough there are the > other files I could not find before. So I guess I will have to cross > the bridge. As a test, I just mv the file /usr/bin/pg_dump. If rpm had > a dependence on that file would it cause some kind of error message in > trying to move it? I was able to successfully move the file to the > root. > RPM won't say anything unless you run rpm commands (ie. rpm -e package to remove it). The only one of those you're likely to have a dependency problem with is postgresql-libs. perl-DBD-Pg, and possibly a few other packages (like PHP, as a previous poster mentioned), will be linked to that. -- Alan
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 somewhere. Welcome to the club, eh? > postgresql-libs-7.4.8-0.6 > postgresql-server-7.4.8-0.6 > postgresql-jdbc-7.3-189.1 > postgresql-7.4.8-0.6 > qt3-postgresql-3.3.1-35.11 > > I did an ls in the /usr/bin directory and sure enough there are the > other files I could not find before. So I guess I will have to cross > the bridge. As a test, I just mv the file /usr/bin/pg_dump. If rpm had > a dependence on that file would it cause some kind of error message in > trying to move it? I was able to successfully move the file to the > root. Nah, RPM won't stop you doing things like that. It will, however, let you know files are missing if you know the commands to throw at it. Take a look here: http://www.rpm.org/ Also, if you're gonna be using linux and postgresql, I'd recommending downloading and installing some fairly recent versions of each. For linux distros, there are hundreds of choices. Fedora Core 5 just came out, but 4 is much more stabilized now. Debian, Suse, Ubuntu are all good distros. You can get RedHat Enterprise clones called "white box linux" or "centos" which are basically exactly the same with different names inside them. Then you can just install postgresql with the yum package manager manager with a command like: yum install postgres* and that's it.