Hi All,
is there an RPM for 4-1 for postgresql? I did a yum, and the latest is only 7-4
Installing: postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M
and I need at least 8-*
Any ideas where to find an RPM for CentOS4-1?
Cheers.
Mark Sargent.
On Sun, 2006-04-09 at 22:02 +0900, Mark Sargent wrote:
Hi All,
is there an RPM for 4-1 for postgresql? I did a yum, and the latest is only 7-4
Installing: postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M
and I need at least 8-*
Any ideas where to find an RPM for CentOS4-1?
---- you should upgrade your CentOS4 to 4.3 via yum
check http://dev.centos.org
I think there are rpms for postgresql-8.1
Craig
Craig White wrote:
you should upgrade your CentOS4 to 4.3 via yum
ok, for another day for now
check http://dev.centos.org
I think there are rpms for postgresql-8.1
yes, but I get the following,
[racket@ibmlap postgresql]$ rpm -Uvh postgresql-8.1.2-1.c4.i386.rpm warning: postgresql-8.1.2-1.c4.i386.rpm: V3 DSA signature: NOKEY, key ID 7203f491 error: Failed dependencies: postgresql = 8.1.3 is needed by postgresql-server-8.1.3-1PGDG.i686 postgresql = 8.1.3 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 [racket@ibmlap postgresql]$ rpm -Uvh postgresql-server-8.1.2-1.c4.i386.rpm warning: postgresql-server-8.1.2-1.c4.i386.rpm: V3 DSA signature: NOKEY, key ID 7203f491 error: Failed dependencies: postgresql = 8.1.2-1.c4 is needed by postgresql-server-8.1.2-1.c4.i386
Cheers.
Mark Sargent.
On Sun, 2006-04-09 at 22:28 +0900, Mark Sargent wrote:
Craig White wrote:
you should upgrade your CentOS4 to 4.3 via yum
ok, for another day for now
check http://dev.centos.org
I think there are rpms for postgresql-8.1
yes, but I get the following,
[racket@ibmlap postgresql]$ rpm -Uvh postgresql-8.1.2-1.c4.i386.rpm warning: postgresql-8.1.2-1.c4.i386.rpm: V3 DSA signature: NOKEY, key ID 7203f491 error: Failed dependencies: postgresql = 8.1.3 is needed by postgresql-server-8.1.3-1PGDG.i686 postgresql = 8.1.3 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 [racket@ibmlap postgresql]$ rpm -Uvh postgresql-server-8.1.2-1.c4.i386.rpm warning: postgresql-server-8.1.2-1.c4.i386.rpm: V3 DSA signature: NOKEY, key ID 7203f491 error: Failed dependencies: postgresql = 8.1.2-1.c4 is needed by postgresql-server-8.1.2-1.c4.i386
Cheers.
Mark Sargent.
That would be because you have non-centos postgres stuff installed ... if you remove that 8.1.3 (non centos) stuff, it should install and work
Johnny Hughes wrote:
That would be because you have non-centos postgres stuff installed ... if you remove that 8.1.3 (non centos) stuff, it should install and work
Hi All,
how do you mean, non-centos stuff? Are you referring to the RPMs for RHEL-es-4 that didn't work? I tried rpm -e "rpmname" but it said they were not installed. Cheers.
Mark Sargent.
Mark Sargent wrote:
Hi All,
how do you mean, non-centos stuff? Are you referring to the RPMs for RHEL-es-4 that didn't work? I tried rpm -e "rpmname" but it said they were not installed. Cheers.
Hi All,
an update on that,
[racket@ibmlap postgresql-8.1.3]$ rpm -qa | grep postgresql* postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-server-8.1.3-1PGDG error reading information on service postgresql: No such file or directory error: %preun(postgresql-server-8.1.3-1PGDG.i686) scriptlet failed, exit status 1 [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-8.1.3-1PGDG error: Failed dependencies: postgresql = 8.1.3 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-libs-8.1.3-1PGDG error: Failed dependencies: libpq.so is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 libpq.so.4 is needed by (installed) postgresql-8.1.3-1PGDG.i686 libpq.so.4 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686
Cheers.
Mark Sargent.
an update on that,
[racket@ibmlap postgresql-8.1.3]$ rpm -qa | grep postgresql* postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-server-8.1.3-1PGDG error reading information on service postgresql: No such file or directory error: %preun(postgresql-server-8.1.3-1PGDG.i686) scriptlet failed, exit status 1 [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-8.1.3-1PGDG error: Failed dependencies: postgresql = 8.1.3 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 [racket@ibmlap postgresql-8.1.3]$ sudo /bin/rpm -e postgresql-libs-8.1.3-1PGDG error: Failed dependencies: libpq.so is needed by (installed) postgresql-server-8.1.3-1PGDG.i686 libpq.so.4 is needed by (installed) postgresql-8.1.3-1PGDG.i686 libpq.so.4 is needed by (installed) postgresql-server-8.1.3-1PGDG.i686
If you want to use rpm to do this, then you should run 'rpm -qa postgres*' to see what rpms you need to get rid of, and then rpm -e them all on one line..... OR.. you can do this the easy/proper way with yum and simply do 'yum remove postresql' and let yum do the hard work for you. I'd also recommend using the repository file on dev.centos.org to let yum do the installing for you. There are a couple compat-libs packages you need to make postgresql work with php etc.
-- Any sufficiently advanced technology is indistinguishable from magic. -Arthur C. Clarke
Jim Perrin wrote:
If you want to use rpm to do this, then you should run 'rpm -qa postgres*' to see what rpms you need to get rid of, and then rpm -e them all on one line.....
[racket@ibmlap postgresql-8.1.3]$ rpm -qa | grep postgresql* postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG
Seems the same as before
OR.. you can do this the easy/proper way with yum and simply do 'yum remove postresql' and let yum do the hard work for you. I'd also recommend using the repository file on dev.centos.org to let yum do the installing for you. There are a couple compat-libs packages you need to make postgresql work with php etc.
[racket@ibmlap postgresql]$ sudo /usr/bin/yum remove postgresql* Password: Setting up Remove Process No Match for argument: postgresql-8.1.3.tar.bz2 No Match for argument: postgresql-server-8.1.2-1.c4.i386.rpm No Match for argument: postgresql-8.1.2-1.c4.i386.rpm Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package postgresql.i686 0:8.1.3-1PGDG set to be erased --> Running transaction check Setting up repositories addons 100% |=========================| 951 B 00:01 dag 100% |=========================| 1.1 kB 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql-server.i686 0:8.1.3-1PGDG set to be erased --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Removing: postgresql i686 8.1.3-1PGDG installed 11 M Removing for dependencies: postgresql-server i686 8.1.3-1PGDG installed 16 M
Transaction Summary ============================================================================= Install 0 Package(s) Update 0 Package(s) Remove 2 Package(s) Total download size: 0 Is this ok [y/N]: y Downloading Packages: Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction error reading information on service postgresql: No such file or directory error: %preun(postgresql-server-8.1.3-1PGDG.i686) scriptlet failed, exit status 1 Removing : postgresql ######################### [1/2]
Removed: postgresql.i686 0:8.1.3-1PGDG Dependency Removed: postgresql-server.i686 0:8.1.3-1PGDG Complete!
[racket@ibmlap postgresql]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files primary.xml.gz 100% |=========================| 29 kB 00:00 c4-testing: ################################################## 109/109 Added 109 new packages, deleted 0 old in 5.50 seconds Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql to pack into transaction set. postgresql-8.1.2-1.c4.i38 100% |=========================| 110 kB 00:01 ---> Package postgresql.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Finished Dependency Resolution Error: Missing Dependency: postgresql = 8.1.3 is needed by package postgresql-server
Cheers.
Mark Sargent.
On Sun, 2006-04-09 at 23:49 +0900, Mark Sargent wrote:
Jim Perrin wrote:
If you want to use rpm to do this, then you should run 'rpm -qa postgres*' to see what rpms you need to get rid of, and then rpm -e them all on one line.....
[racket@ibmlap postgresql-8.1.3]$ rpm -qa | grep postgresql* postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG
Seems the same as before
OR.. you can do this the easy/proper way with yum and simply do 'yum remove postresql' and let yum do the hard work for you. I'd also recommend using the repository file on dev.centos.org to let yum do the installing for you. There are a couple compat-libs packages you need to make postgresql work with php etc.
[racket@ibmlap postgresql]$ sudo /usr/bin/yum remove postgresql* Password: Setting up Remove Process No Match for argument: postgresql-8.1.3.tar.bz2 No Match for argument: postgresql-server-8.1.2-1.c4.i386.rpm No Match for argument: postgresql-8.1.2-1.c4.i386.rpm Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package postgresql.i686 0:8.1.3-1PGDG set to be erased --> Running transaction check Setting up repositories addons 100% |=========================| 951 B 00:01 dag 100% |=========================| 1.1 kB 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql-server.i686 0:8.1.3-1PGDG set to be erased --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Removing: postgresql i686 8.1.3-1PGDG installed 11 M Removing for dependencies: postgresql-server i686 8.1.3-1PGDG installed 16 M
Transaction Summary
Install 0 Package(s) Update 0 Package(s) Remove 2 Package(s) Total download size: 0 Is this ok [y/N]: y Downloading Packages: Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction error reading information on service postgresql: No such file or directory error: %preun(postgresql-server-8.1.3-1PGDG.i686) scriptlet failed, exit status 1 Removing : postgresql ######################### [1/2]
Removed: postgresql.i686 0:8.1.3-1PGDG Dependency Removed: postgresql-server.i686 0:8.1.3-1PGDG Complete!
[racket@ibmlap postgresql]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files primary.xml.gz 100% |=========================| 29 kB 00:00 c4-testing: ################################################## 109/109 Added 109 new packages, deleted 0 old in 5.50 seconds Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql to pack into transaction set. postgresql-8.1.2-1.c4.i38 100% |=========================| 110 kB 00:01 ---> Package postgresql.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Finished Dependency Resolution Error: Missing Dependency: postgresql = 8.1.3 is needed by package postgresql-server
yum remove postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG
(the above is one line)
If that has everything remove cleanly ... then try the install with yum.
Johnny Hughes wrote:
yum remove postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG
(the above is one line)
If that has everything remove cleanly ... then try the install with yum.
Hi All,
[racket@ibmlap postgresql]$ sudo /usr/bin/yum remove postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG Password: Setting up Remove Process No Match for argument: postgresql-8.1.3-1PGDG Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package postgresql-libs.i686 0:8.1.3-1PGDG set to be erased ---> Package postgresql-server.i686 0:8.1.3-1PGDG set to be erased --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Removing: postgresql-libs i686 8.1.3-1PGDG installed 931 k postgresql-server i686 8.1.3-1PGDG installed 16 M
Transaction Summary ============================================================================= Install 0 Package(s) Update 0 Package(s) Remove 2 Package(s) Total download size: 0 Is this ok [y/N]: y Downloading Packages: Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction error reading information on service postgresql: No such file or directory error: %preun(postgresql-server-8.1.3-1PGDG.i686) scriptlet failed, exit status 1 Removing : postgresql-libs ######################### [1/2]
Removed: postgresql-libs.i686 0:8.1.3-1PGDG postgresql-server.i686 0:8.1.3-1PGDG Complete! [racket@ibmlap postgresql]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Package postgresql.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: libpq.so.4 for package: postgresql --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql-libs to pack into transaction set. postgresql-libs-8.1.2-1.c 100% |=========================| 14 kB 00:00 ---> Package postgresql-libs.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: postgresql = 8.1.3 for package: postgresql-server --> Finished Dependency Resolution Error: Missing Dependency: postgresql = 8.1.3 is needed by package postgresql-server
Not sure what to do next? Cheers.
Mark Sargent
On Mon, 10 Apr 2006, Mark Sargent wrote:
Johnny Hughes wrote:
yum remove postgresql-server-8.1.3-1PGDG postgresql-8.1.3-1PGDG postgresql-libs-8.1.3-1PGDG
(the above is one line)
If that has everything remove cleanly ... then try the install with yum.
Apparently you have bad packages installed that you cannot easily uninstall because of a broken script (something in the preun or postun script fails and aborts the removal).
So the easiest thing to do is:
rpm -e --noscripts postgresql postgresql-libs postgresql-server
And then reinstall postgresql the normal way.
And next time, do not install packages you find somewhere on the net if you don't know what you (or the packages) are doing.
Kind regards, -- dag wieers, dag@wieers.com, http://dag.wieers.com/ -- [all I want is a warm bed and a kind word and unlimited power]
check http://dev.centos.org
I think there are rpms for postgresql-8.1
Yes there are, as well as the compatibility libs required so that they work seamlessly with current versions of php and other centos applications. It makes updating loads easier.
-- Any sufficiently advanced technology is indistinguishable from magic. -Arthur C. Clarke
Craig White wrote:
On Sun, 2006-04-09 at 22:02 +0900, Mark Sargent wrote:
Hi All,
is there an RPM for 4-1 for postgresql? I did a yum, and the latest is only 7-4
Installing: postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M
and I need at least 8-*
Any ideas where to find an RPM for CentOS4-1?
you should upgrade your CentOS4 to 4.3 via yum
check http://dev.centos.org
I think there are rpms for postgresql-8.1
if you are using pkgs form the dev.centos.org repository - please provide feedback, so that those packages can be moved into the mirror.centos.org repositories.
inspite of the large number of people using these rpms from dev.centos.org - almost none have bothered to take half a minute and provide feedback either via email on the centos-devel mailing list or the bugs.centos.org tracker for these packages.
We *need* that feedback! A lot of other users can also gain from this...
so once again, if you are using these rpms, let us know if they work for you.
On Mon, 2006-04-10 at 22:38 +0100, Karanbir Singh wrote:
Craig White wrote:
On Sun, 2006-04-09 at 22:02 +0900, Mark Sargent wrote:
<snip>
if you are using pkgs form the dev.centos.org repository - please provide feedback, so that those packages can be moved into the mirror.centos.org repositories.
inspite of the large number of people using these rpms from dev.centos.org - almost none have bothered to take half a minute and provide feedback either via email on the centos-devel mailing list or the bugs.centos.org tracker for these packages.
We *need* that feedback! A lot of other users can also gain from this...
so once again, if you are using these rpms, let us know if they work for you.
You know how folks are. If you want to assure feedback, start removing pkgs from dev and don't put in updates. When (in)activity hurts *them*, you'll hear about it.
MHO
Mark Sargent wrote:
Hi All,
is there an RPM for 4-1 for postgresql? I did a yum, and the latest is only 7-4
Installing: postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M
and I need at least 8-*
Any ideas where to find an RPM for CentOS4-1?
Cheers.
Mark Sargent.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
you can use the www.postgresql.org redhat binaries :
http://www.postgresql.org/ftp/binary/v8.1.3/linux/rpms/redhat/rhel-es-4/
if you use php or perl o dovecot or any other dependency to postgresql you must rebuild those rpms with the postgresql 8.1.3 installed and do this every time there's an update for those rebuilded packages
leonel
Leonel Nunez wrote:
you can use the www.postgresql.org redhat binaries :
http://www.postgresql.org/ftp/binary/v8.1.3/linux/rpms/redhat/rhel-es-4/
I tried these already, sorry for not saying so, and they didn't work. Nothing installed.
if you use php or perl o dovecot or any other dependency to postgresql you must rebuild those rpms with the postgresql 8.1.3 installed and do this every time there's an update for those rebuilded packages
little over my head, but thanx. Cheers.
Mark Sargent.
On Sun, 2006-04-09 at 22:02 +0900, Mark Sargent wrote:
Hi All,
is there an RPM for 4-1 for postgresql? I did a yum, and the latest is only 7-4
Installing: postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M
and I need at least 8-*
Any ideas where to find an RPM for CentOS4-1?
There are postgres 8 rpms in the CentOS testing tree.
http://lists.centos.org/pipermail/centos-devel/2005-December/002017.html
The latest version in there now is:
postgresql-server-8.1.2
Thanks, Johnny Hughes
Johnny Hughes wrote:
There are postgres 8 rpms in the CentOS testing tree.
http://lists.centos.org/pipermail/centos-devel/2005-December/002017.html
The latest version in there now is:
postgresql-server-8.1.2
Hi All,
I have just tried this with limited success,
[racket@ibmlap ~]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql-8.1.0-4.c4 Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files primary.xml.gz 100% |=========================| 11 kB 00:00 update : ################################################## 23/23 Added 1 new packages, deleted 0 old in 0.96 seconds primary.xml.gz 100% |=========================| 35 kB 00:00 extras : ################################################## 159/159 Added 26 new packages, deleted 0 old in 2.45 seconds Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql to pack into transaction set. postgresql-8.1.0-4.c4.i38 100% |=========================| 109 kB 00:01 ---> Package postgresql.i386 0:8.1.0-4.c4 set to be updated --> Running transaction check --> Processing Dependency: libpq.so.4 for package: postgresql --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql-libs.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Installing: postgresql i386 8.1.0-4.c4 c4-testing 2.7 M Installing for dependencies: postgresql-libs i386 8.1.2-1.c4 c4-testing 178 k
Transaction Summary ============================================================================= Install 2 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 2.8 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql-8.1.0-4 100% |=========================| 2.7 MB 00:24 (2/2): postgresql-libs-8. 100% |=========================| 178 kB 00:01 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: postgresql-libs ######################### [1/2] Installing: postgresql ######################### [2/2]
Installed: postgresql.i386 0:8.1.0-4.c4 Dependency Installed: postgresql-libs.i386 0:8.1.2-1.c4 Complete!
Then I did a whereis/which after running updatedb, and was expecting to find pgsql in /usr/local/ or elsewhere, but nothing.
[racket@ibmlap ~]$ rpm -qa | grep postgresql* postgresql-8.1.0-4.c4 postgresql-libs-8.1.2-1.c4
[racket@ibmlap usr]$ sudo find / -name postgresql Password: /usr/bin/find: /proc/3991/task: No such file or directory /home/racket/downloads/postgresql
[racket@ibmlap pgsql]$ rpm -qi | grep postgresql* rpmq: no arguments given for query
Perhaps I'm still doing something fundamentally wrong? Cheers.
Mark Sargent.
hi all,
I am very new to centos. Centos 4.3 installed
I need to connect an usb2ethernet device with an asix8877..
Usbnet is not ready to accept this device, only asix8817...
I have a patch for usbnet, i need to compile and install it, any sugestion is welcome,
Regards,
Olivier
olivier.taylor wrote:
hi all,
I am very new to centos. Centos 4.3 installed
I need to connect an usb2ethernet device with an asix8877..
Usbnet is not ready to accept this device, only asix8817...
I have a patch for usbnet, i need to compile and install it, any sugestion is welcome,
Please do not post in someone elses thread with totally irrelevant content. It's rude and annoying. Start your own thread. Cheers.
Mark Sargent
Hi All,
furthermore, I installed postgresql-server and then did another updatedb and ran rpm -qa and rpm -qi,
[racket@ibmlap pgsql]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql-server Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql-server to pack into transaction set. postgresql-server-8.1.2-1 100% |=========================| 84 kB 00:01 ---> Package postgresql-server.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: postgresql = 8.1.2-1.c4 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Installing: postgresql-server i386 8.1.2-1.c4 c4-testing 3.8 M Updating for dependencies: postgresql i386 8.1.2-1.c4 c4-testing 2.7 M
Transaction Summary ============================================================================= Install 1 Package(s) Update 1 Package(s) Remove 0 Package(s) Total download size: 6.5 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql-8.1.2-1 100% |=========================| 2.7 MB 00:16 (2/2): postgresql-server- 100% |=========================| 3.8 MB 00:18 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Updating : postgresql ######################### [1/3] Installing: postgresql-server ######################### [2/3] Cleanup : postgresql ######################### [3/3]
Installed: postgresql-server.i386 0:8.1.2-1.c4 Dependency Updated: postgresql.i386 0:8.1.2-1.c4 Complete! [racket@ibmlap pgsql]$ sudo updatedb Password:
[racket@ibmlap pgsql]$ whereis pgsql pgsql: /usr/lib/pgsql /usr/share/pgsql
[racket@ibmlap pgsql]$ cd /usr/share/pgsql
[racket@ibmlap pgsql]$ ls conversion_create.sql pg_service.conf.sample psqlrc.sample timezone information_schema.sql postgres.bki recovery.conf.sample pg_hba.conf.sample postgres.description sql_features.txt pg_ident.conf.sample postgresql.conf.sample system_views.sql
[racket@ibmlap pgsql]$ whereis postgresql postgresql:
[racket@ibmlap pgsql]$ which pgsql /usr/bin/which: no pgsql in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/lib/jre/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18/skype:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/usr/lib/jre/bin)
[racket@ibmlap pgsql]$ which postgresql /usr/bin/which: no postgresql in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/lib/jre/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18/skype:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/usr/lib/jre/bin)
[racket@ibmlap pgsql]$ rpm -qa | grep postgresql*
[racket@ibmlap pgsql]$ rpm -qi postgresql Name : postgresql Relocations: (not relocatable) Version : 8.1.2 Vendor: CentOS Release : 1.c4 Build Date: Thu 26 Jan 2006 06:47:30 AM JST Install Date: Sun 16 Apr 2006 06:08:42 PM JST Build Host: insanity.cognitive-dissonance.org Group : Applications/Databases Source RPM: postgresql-8.1.2-1.c4.src.rpm Size : 10486980 License: BSD Signature : DSA/SHA1, Thu 26 Jan 2006 08:32:24 AM JST, Key ID 5c37c0b17203f491Packager : Jim Perrin jperrin@centos.org URL : http://www.postgresql.org/ Summary : PostgreSQL client programs and libraries. Description : PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). The postgresql package includes the client programs and libraries that you'll need to access a PostgreSQL DBMS server. These PostgreSQL client programs are programs that directly manipulate the internal structure of PostgreSQL databases on a PostgreSQL server. These client programs can be located on the same machine with the PostgreSQL server, or may be on a remote machine which accesses a PostgreSQL server over a network connection. This package contains the docs in HTML for the whole package, as well as command-line utilities for managing PostgreSQL databases on a PostgreSQL server.
If you want to manipulate a PostgreSQL database on a remote PostgreSQL server, you need this package. You also need to install this package if you're installing the postgresql-server package.
[racket@ibmlap pgsql]$ rpm -qi postgresql-server Name : postgresql-server Relocations: (not relocatable) Version : 8.1.2 Vendor: CentOS Release : 1.c4 Build Date: Thu 26 Jan 2006 06:47:30 AM JST Install Date: Sun 16 Apr 2006 06:09:42 PM JST Build Host: insanity.cognitive-dissonance.org Group : Applications/Databases Source RPM: postgresql-8.1.2-1.c4.src.rpm Size : 10086308 License: BSD Signature : DSA/SHA1, Thu 26 Jan 2006 08:32:27 AM JST, Key ID 5c37c0b17203f491Packager : Jim Perrin jperrin@centos.org URL : http://www.postgresql.org/ Summary : The programs needed to create and run a PostgreSQL server. Description : The postgresql-server package includes the programs needed to create and run a PostgreSQL server, which will in turn allow you to create and maintain PostgreSQL databases. PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). You should install postgresql-server if you want to create and maintain your own PostgreSQL databases and/or your own PostgreSQL server. You also need to install the postgresql package. [racket@ibmlap pgsql]$ rpm -qa | grep postgresql* [racket@ibmlap pgsql]$
Sorry, I'm a little lost with this. Cheers.
Mark Sargent.
On Sun, 2006-04-16 at 18:38 +0900, Mark Sargent wrote:
Hi All,
furthermore, I installed postgresql-server and then did another updatedb and ran rpm -qa and rpm -qi,
[racket@ibmlap pgsql]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql-server Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql-server to pack into transaction set. postgresql-server-8.1.2-1 100% |=========================| 84 kB 00:01 ---> Package postgresql-server.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check --> Processing Dependency: postgresql = 8.1.2-1.c4 for package: postgresql-server --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Installing: postgresql-server i386 8.1.2-1.c4 c4-testing 3.8 M Updating for dependencies: postgresql i386 8.1.2-1.c4 c4-testing 2.7 M
Transaction Summary
Install 1 Package(s) Update 1 Package(s) Remove 0 Package(s) Total download size: 6.5 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql-8.1.2-1 100% |=========================| 2.7 MB 00:16 (2/2): postgresql-server- 100% |=========================| 3.8 MB 00:18 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Updating : postgresql ######################### [1/3] Installing: postgresql-server ######################### [2/3] Cleanup : postgresql ######################### [3/3]
Installed: postgresql-server.i386 0:8.1.2-1.c4 Dependency Updated: postgresql.i386 0:8.1.2-1.c4 Complete! [racket@ibmlap pgsql]$ sudo updatedb Password:
[racket@ibmlap pgsql]$ whereis pgsql pgsql: /usr/lib/pgsql /usr/share/pgsql
[racket@ibmlap pgsql]$ cd /usr/share/pgsql
[racket@ibmlap pgsql]$ ls conversion_create.sql pg_service.conf.sample psqlrc.sample timezone information_schema.sql postgres.bki recovery.conf.sample pg_hba.conf.sample postgres.description sql_features.txt pg_ident.conf.sample postgresql.conf.sample system_views.sql
[racket@ibmlap pgsql]$ whereis postgresql postgresql:
[racket@ibmlap pgsql]$ which pgsql /usr/bin/which: no pgsql in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/lib/jre/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18/skype:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/usr/lib/jre/bin)
[racket@ibmlap pgsql]$ which postgresql /usr/bin/which: no postgresql in (/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/usr/lib/jre/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18/skype:/home/racket/bin:/home/racket/downloads/skype/skype-1.2.0.18:/usr/local/mysql/bin:/usr/lib/jre/bin)
[racket@ibmlap pgsql]$ rpm -qa | grep postgresql*
[racket@ibmlap pgsql]$ rpm -qi postgresql Name : postgresql Relocations: (not relocatable) Version : 8.1.2 Vendor: CentOS Release : 1.c4 Build Date: Thu 26 Jan 2006 06:47:30 AM JST Install Date: Sun 16 Apr 2006 06:08:42 PM JST Build Host: insanity.cognitive-dissonance.org Group : Applications/Databases Source RPM: postgresql-8.1.2-1.c4.src.rpm Size : 10486980 License: BSD Signature : DSA/SHA1, Thu 26 Jan 2006 08:32:24 AM JST, Key ID 5c37c0b17203f491Packager : Jim Perrin jperrin@centos.org URL : http://www.postgresql.org/ Summary : PostgreSQL client programs and libraries. Description : PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). The postgresql package includes the client programs and libraries that you'll need to access a PostgreSQL DBMS server. These PostgreSQL client programs are programs that directly manipulate the internal structure of PostgreSQL databases on a PostgreSQL server. These client programs can be located on the same machine with the PostgreSQL server, or may be on a remote machine which accesses a PostgreSQL server over a network connection. This package contains the docs in HTML for the whole package, as well as command-line utilities for managing PostgreSQL databases on a PostgreSQL server.
If you want to manipulate a PostgreSQL database on a remote PostgreSQL server, you need this package. You also need to install this package if you're installing the postgresql-server package.
[racket@ibmlap pgsql]$ rpm -qi postgresql-server Name : postgresql-server Relocations: (not relocatable) Version : 8.1.2 Vendor: CentOS Release : 1.c4 Build Date: Thu 26 Jan 2006 06:47:30 AM JST Install Date: Sun 16 Apr 2006 06:09:42 PM JST Build Host: insanity.cognitive-dissonance.org Group : Applications/Databases Source RPM: postgresql-8.1.2-1.c4.src.rpm Size : 10086308 License: BSD Signature : DSA/SHA1, Thu 26 Jan 2006 08:32:27 AM JST, Key ID 5c37c0b17203f491Packager : Jim Perrin jperrin@centos.org URL : http://www.postgresql.org/ Summary : The programs needed to create and run a PostgreSQL server. Description : The postgresql-server package includes the programs needed to create and run a PostgreSQL server, which will in turn allow you to create and maintain PostgreSQL databases. PostgreSQL is an advanced Object-Relational database management system (DBMS) that supports almost all SQL constructs (including transactions, subselects and user-defined types and functions). You should install postgresql-server if you want to create and maintain your own PostgreSQL databases and/or your own PostgreSQL server. You also need to install the postgresql package. [racket@ibmlap pgsql]$ rpm -qa | grep postgresql* [racket@ibmlap pgsql]$
Sorry, I'm a little lost with this. Cheers.
----- nowhere do you actually say what you are trying to do.
Are you trying to start postgresql server?
/sbin/service postgresql start
Are you trying to get postgresql server to start on each boot?
/sbin/chkconfig postgresql on
Are you trying to use the client application?
/usr/bin/psql [options]
Are you trying to locate the configuration files?
/var/lib/pgsql/data
Craig
Craig White wrote:
nowhere do you actually say what you are trying to do.
Are you trying to start postgresql server?
/sbin/service postgresql start
Are you trying to get postgresql server to start on each boot?
/sbin/chkconfig postgresql on
Are you trying to use the client application?
/usr/bin/psql [options]
Are you trying to locate the configuration files?
/var/lib/pgsql/data
Hi All,
1st, let me apologize for being slack. I should do more research before asking in here. Anyway, I got it running, but, am new to pgsql and am getting this,
[racket@ibmlap lib]$ psql template1 psql: FATAL: role "racket" does not exist
so I went into to the data dir and looked around and thought I could add to the below files.
pg_ident below,
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: host all all 127.0.0.1/32 ident sameuser # IPv6 local connections: host all all ::1/128 ident sameuser
pg_hba.conf is below,
# MAPNAME IDENT-USERNAME PG-USERNAME racket racket postgres
I know I'm close with this. Cheers.
Mark Sargent.
On Sun, 2006-04-16 at 17:53 +0900, Mark Sargent wrote:
Johnny Hughes wrote:
There are postgres 8 rpms in the CentOS testing tree.
http://lists.centos.org/pipermail/centos-devel/2005-December/002017.html
The latest version in there now is:
postgresql-server-8.1.2
Hi All,
I have just tried this with limited success,
[racket@ibmlap ~]$ sudo /usr/bin/yum --enablerepo c4-testing install postgresql-8.1.0-4.c4 Setting up Install Process Setting up repositories dag 100% |=========================| 1.1 kB 00:00 c4-testing 100% |=========================| 951 B 00:00 update 100% |=========================| 951 B 00:00 base 100% |=========================| 1.1 kB 00:00 addons 100% |=========================| 951 B 00:00 extras 100% |=========================| 1.1 kB 00:00 Reading repository metadata in from local files primary.xml.gz 100% |=========================| 11 kB 00:00 update : ################################################## 23/23 Added 1 new packages, deleted 0 old in 0.96 seconds primary.xml.gz 100% |=========================| 35 kB 00:00 extras : ################################################## 159/159 Added 26 new packages, deleted 0 old in 2.45 seconds Parsing package install arguments Resolving Dependencies --> Populating transaction set with selected packages. Please wait. ---> Downloading header for postgresql to pack into transaction set. postgresql-8.1.0-4.c4.i38 100% |=========================| 109 kB 00:01 ---> Package postgresql.i386 0:8.1.0-4.c4 set to be updated --> Running transaction check --> Processing Dependency: libpq.so.4 for package: postgresql --> Restarting Dependency Resolution with new changes. --> Populating transaction set with selected packages. Please wait. ---> Package postgresql-libs.i386 0:8.1.2-1.c4 set to be updated --> Running transaction check
Dependencies Resolved
============================================================================= Package Arch Version Repository Size ============================================================================= Installing: postgresql i386 8.1.0-4.c4 c4-testing 2.7 M Installing for dependencies: postgresql-libs i386 8.1.2-1.c4 c4-testing 178 k
Transaction Summary
Install 2 Package(s) Update 0 Package(s) Remove 0 Package(s) Total download size: 2.8 M Is this ok [y/N]: y Downloading Packages: (1/2): postgresql-8.1.0-4 100% |=========================| 2.7 MB 00:24 (2/2): postgresql-libs-8. 100% |=========================| 178 kB 00:01 Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing: postgresql-libs ######################### [1/2] Installing: postgresql ######################### [2/2]
Installed: postgresql.i386 0:8.1.0-4.c4 Dependency Installed: postgresql-libs.i386 0:8.1.2-1.c4 Complete!
Then I did a whereis/which after running updatedb, and was expecting to find pgsql in /usr/local/ or elsewhere, but nothing.
[racket@ibmlap ~]$ rpm -qa | grep postgresql* postgresql-8.1.0-4.c4 postgresql-libs-8.1.2-1.c4
[racket@ibmlap usr]$ sudo find / -name postgresql Password: /usr/bin/find: /proc/3991/task: No such file or directory /home/racket/downloads/postgresql
[racket@ibmlap pgsql]$ rpm -qi | grep postgresql* rpmq: no arguments given for query
Perhaps I'm still doing something fundamentally wrong? Cheers.
Mark Sargent.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
"man whereis" ...BUGS Since whereis uses chdir(2V) ...
whereis has a hard-coded path, so may not always find what you’re looking for.
I suspect it goes somewhere like /usrshare... Do an updatedb and then locate.
Then I did a whereis/which after running updatedb, and was expecting to find pgsql in /usr/local/ or elsewhere, but nothing.
Distribution related packages don't go in /usr/local. That's generally for people building software from source. Distribution related packages live mostly in /usr. As Johnny pointed out, rpm -ql <packagename> will show you what files are in that rpm. Keep in mind that some names may not be exactly has you expect them.
-- Any sufficiently advanced technology is indistinguishable from magic. -Arthur C. Clarke
-
Craig White -
Dag Wieers -
Jim Perrin -
Johnny Hughes -
Karanbir Singh -
Leonel Nunez -
Mark Sargent -
olivier.taylor -
William L. Maltby