David Bear writes:
> While running a yum update on a system, the update fails with the message:
> Transaction Check Error:
> package postgresql-libs-8.3.11-1PGDG.el5.x86_64 (which is newer than
> postgresql-libs-8.1.22-1.el5_5.1.i386) is already installed
It looks to me like yum would like to i
mbro...@gmail.com (Mike Broers) writes:
> Lately I have been paranoid about the possibility of transaction wrap
> around failure due to a potential orphaned toast table. I have yet to
> prove that I have such an object in my database.. but I am running
> Postgres 8.3 with auto_vacuum enabled and a
Based on the below error message it looks like the Database and tables
already exists. Please check the database.
When you do a regular pg_dump, it won't include all the roles. You to
include roles have should always use pg_dumpall -l ( you can read up more
using #man pg_dumpall).
Good luck!
~De
On Thu, 2011-01-13 at 14:57 -0700, David Bear wrote:
>
> I've modified all the /etc/yum.repos.d/ files to exclude=postgresql*
This is wrong, if you include pgdg repo in the word "all" above.
What did you exclude exactly?
> I've checked, and I don't have postgresql-libs-8.1.22-1.el5_5.1.i386
>
On Thu, 2011-01-13 at 15:41 -0600, Campbell, Lance wrote:
> Thanks for the reply. I get the following error message when
> installing on redhat 6
>
> pgadmin3-1.12.2-1.rhel6.x86_64 requires
> libwx_gtk2u_core-2.8.so.0()(64bit)
You will need wxGTK files:
http://yum.pgrpms.org/9.0/redhat/rhel-6-
Lately I have been paranoid about the possibility of transaction wrap around
failure due to a potential orphaned toast table. I have yet to prove that I
have such an object in my database.. but I am running Postgres 8.3 with
auto_vacuum enabled and am doing nightly manual vacuums as well and canno
While running a yum update on a system, the update fails with the message:
Transaction Check Error:
package postgresql-libs-8.3.11-1PGDG.el5.x86_64 (which is newer than
postgresql-libs-8.1.22-1.el5_5.1.i386) is already installed
I've checked, and I don't have postgresql-libs-8.1.22-1.el5_5.1.
Thanks for the reply. I get the following error message when installing on
redhat 6
pgadmin3-1.12.2-1.rhel6.x86_64 requires libwx_gtk2u_core-2.8.so.0()(64bit)
I did a search at: http://rpm.pbone.net/index.php3
Do I need to install this rpm to get past this issue?
ftp.sourceforge.net/pub/sourc
On Wed, 2011-01-12 at 14:35 -0600, Campbell, Lance wrote:
> Is there a graphical admin tool for RedHat 6? When I went to download
> PgAdmin I noticed it told what RPM to use for RedHat5. But I did not
> see it available for RedHat6.
You can find it in http://yum.pgrpms.org .
Regards,
--
Devrim
Στις Wednesday 12 January 2011 18:45:20 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > Στις Wednesday 12 January 2011 17:07:53 ο/η Tom Lane έγραψε:
> >> Right offhand I'd wonder whether that was more bound by gettimeofday or
> >> by printf. Please try it without printf in the loop.
>
> >
Στις Thursday 13 January 2011 14:13:21 ο/η Achilleas Mantzios έγραψε:
> SELECT distinct
> m.id,coalesce(m.givenname,''),coalesce(m.midname,''),m.surname from
> marinerstates ms,vessels vsl,mariner m
> where m.id=ms.marinerid and ms.vslid=vsl.id and ms.state='Active' and
> coalesce(ms.endtime,n
Στις Wednesday 12 January 2011 18:45:20 ο/η Tom Lane έγραψε:
> Achilleas Mantzios writes:
> > Στις Wednesday 12 January 2011 17:07:53 ο/η Tom Lane έγραψε:
> >> Right offhand I'd wonder whether that was more bound by gettimeofday or
> >> by printf. Please try it without printf in the loop.
>
> >
Στις Wednesday 12 January 2011 19:17:28 ο/η Mark Felder έγραψε:
> On Wed, 12 Jan 2011 10:45:20 -0600, Tom Lane wrote:
> >
> > The short of it is that cheap motherboards tend to provide cheap clock
> > hardware that takes about a microsecond to read.
>
> I'm not sure how gettimeofday() works, but
Στις Wednesday 12 January 2011 21:17:00 ο/η Alex Hunsaker έγραψε:
> 2011/1/12 Achilleas Mantzios :
>
> >
> > Changed that to smth like: micros_total = micros_total + (double) micros;
> > instead of the printf to beat any compiler optimization, and still linux
> > runs at light speed:
> > FBSD_TES
14 matches
Mail list logo
