Re: [BUGS] BUG #5291: Password change restrictions

2010-01-19 Thread Bruce Momjian
Chris Arensdorf wrote: > > The following bug has been logged online: > > Bug reference: 5291 > Logged by: Chris Arensdorf > Email address: chris.arensd...@gdc4s.com > PostgreSQL version: 8.4.2 > Operating system: Linux RedHat 5.3 > Description:Password change restrict

Re: [BUGS] BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

2010-01-19 Thread Tom Lane
"WildWezyr" writes: > If I eliminate polish national chars from function spb_getWord i.e. it will > generate words with plain ascii chars there is no error and everything works > fine. What that sounds like is a locale/encoding conflict. Postgres depends on strcoll() or local equivalent to produ

[BUGS] BUG #5291: Password change restrictions

2010-01-19 Thread Chris Arensdorf
The following bug has been logged online: Bug reference: 5291 Logged by: Chris Arensdorf Email address: chris.arensd...@gdc4s.com PostgreSQL version: 8.4.2 Operating system: Linux RedHat 5.3 Description:Password change restrictions Details: I would like to make an e

[BUGS] BUG #5290: Simple loop with insert into and check to avoid duplicate values fails

2010-01-19 Thread WildWezyr
The following bug has been logged online: Bug reference: 5290 Logged by: WildWezyr Email address: wi.ld.we.z...@gmail.com PostgreSQL version: 8.4.2 Operating system: Windows Vista Description:Simple loop with insert into and check to avoid duplicate values fails Detai

Re: [BUGS] BUG #5288: Restoring a 7.4.5 -Fc dump using -j 2 segfaults (patch included)

2010-01-19 Thread Tom Lane
Jon Erdman writes: > That would seem to indicate that in the case of partial archives these > missing deps wouldn't cause any worse failure than they otherwise would, > since they'd be just as missing if you did a normal restore vs. a > parallel one. The dependency info isn't used at all unless y

Re: [BUGS] BUG #5288: Restoring a 7.4.5 -Fc dump using -j 2 segfaults (patch included)

2010-01-19 Thread Tom Lane
Chris Travers writes: > Just to clarify, the only part that would not be supported would be > the parallel part, right? Yeah, you can still restore as long as you don't use -j. The other alternative is to use a more modern pg_dump to dump from the old server. regards, to

Re: [BUGS] BUG #5288: Restoring a 7.4.5 -Fc dump using -j 2 segfaults (patch included)

2010-01-19 Thread Jon Erdman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Chris Travers wrote: > Just weighing in here. > > On Tue, Jan 19, 2010 at 9:15 AM, Tom Lane wrote: >> It doesn't seem worth it >> to try to support parallel restore from nearly-obsolete versions, and >> I suspect that we couldn't do it even if we tri

Re: [BUGS] BUG #5288: Restoring a 7.4.5 -Fc dump using -j 2 segfaults (patch included)

2010-01-19 Thread Chris Travers
Just weighing in here. On Tue, Jan 19, 2010 at 9:15 AM, Tom Lane wrote: > It doesn't seem worth it > to try to support parallel restore from nearly-obsolete versions, and > I suspect that we couldn't do it even if we tried --- the reason the > representation got changed is that the old way simply

Re: [BUGS] BUG #5288: Restoring a 7.4.5 -Fc dump using -j 2 segfaults (patch included)

2010-01-19 Thread Tom Lane
Jon Erdman writes: > Tom Lane wrote: >> It seems like a good idea to put a range check into that loop as well, >> but I think it should throw error not silently ignore bad data ... > If things can be referenced that are not even in the dump, wouldn't it > be somewhat likely that the dependency du

Re: [BUGS] BUG #5288: Restoring a 7.4.5 -Fc dump using -j 2 segfaults (patch included)

2010-01-19 Thread Jon Erdman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane wrote: > "Jon Erdman (aka StuckMojo)" writes: >> So, I still run 7.4.5 for my medical billing app, and in playing around with >> 8.5 at AustinPUG last week I discovered that if I try to restore one of my >> backups from 7.4 (produced with 7.4

Re: [BUGS] BUG #5288: Restoring a 7.4.5 -Fc dump using -j 2 segfaults (patch included)

2010-01-19 Thread Tom Lane
"Jon Erdman (aka StuckMojo)" writes: > So, I still run 7.4.5 for my medical billing app, and in playing around with > 8.5 at AustinPUG last week I discovered that if I try to restore one of my > backups from 7.4 (produced with 7.4 pg_dump) into 8.5devel using 8.5 > pg_restore and -j 2, it immediat

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-19 Thread Kevin Grittner
yua ** wrote: > What kind of information shall, I geve you There are some good guidelines here: http://wiki.postgresql.org/wiki/SlowQueryQuestions -Kevin -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpre

[BUGS] BUG #5289: Unpredictable error in plpgsql function loop

2010-01-19 Thread WildWezyr
The following bug has been logged online: Bug reference: 5289 Logged by: WildWezyr Email address: wi.ld.we.z...@gmail.com PostgreSQL version: 8.3.3, 8.4.2 Operating system: Windows Vista Description:Unpredictable error in plpgsql function loop Details: For these tab

Re: [BUGS] BUG #5284: Postgres CPU 100% and worker took too long to start; cancelled... Systemdown

2010-01-19 Thread yua ゅぁ
Hello. >You haven't really provided us with much detail here, but it kind of >sounds like your system is overloaded. >...Robert Thank you for your kindness. Following modules are used  mod_auth_pgsql-2.0.3_1  postgresql-client-8.3.9_1,1  postgresql-server-8.3.9_1  p5-DBD-Pg-2.16.0  php5-pdo_