Re: [ADMIN] Gradual increase in CPU utilization by postmaster

2001-06-21 Thread Yasuo Ohgaki
> "Yasuo Ohgaki" <[EMAIL PROTECTED]> writes: > > Postmaster size and CPU time increases gradually as time passes. > > After 25 minutes elapsed, postmaster size became about 7000. > > CPU time increased to about 90% from 70%. > > > Terminating script and executing again will result in the same high

[ADMIN] Lost oid restoring dump with blobs

2001-06-21 Thread Volkmar Wieners
Hi! I've a restoring problem with a pg-db contains images stored in blobs: I want to copy the whole content of the db with a dump-file from a solaris to a linux server (both postgresql 7.1.2). While inserting the dump (created by pg_dump) pg_restore changes all "oids" of the blobs into new ones.

Re: [ADMIN] Problems upgrading from 7.1beta4 to 7.1.0

2001-06-21 Thread Tom Lane
James Moore <[EMAIL PROTECTED]> writes: > Yesterday I attempted to upgrade a system running 7.1 beta4 RPMS that I > built from the SRPM to 7.1.0 RPMS built from the SRPMS. I assumed that > since the version number difference was minor I wouldn't have a > problem If you're going to run beta relea

Re: [ADMIN] Gradual increase in CPU utilization by postmaster

2001-06-21 Thread Tom Lane
"Yasuo Ohgaki" <[EMAIL PROTECTED]> writes: > Postmaster size and CPU time increases gradually as time passes. > After 25 minutes elapsed, postmaster size became about 7000. > CPU time increased to about 90% from 70%. > Terminating script and executing again will result in the same higher > CPU a