Re: [BUGS] Shared memory bug

2004-09-11 Thread Tom Lane
Rikardo Tinauer <[EMAIL PROTECTED]> writes: > But here comes something I think it is a bug. Shared memory can not > be recovered from this point on. Everthing operation I try to > perform on db says: out of shared memory. And the only option > I have is to shutdown postmaster and start it again. H

Re: [BUGS] BUG #1249: pg_restore doesnt handle restoring databases

2004-09-11 Thread Bill Schaub
On Fri, 10 Sep 2004, Tom Lane wrote: > Hmm. This is still broken in CVS tip, but I think the correct solution > is just to replace "\connect db user" with "\connect db" everywhere. > This will retain the starting real user authentication throughout the > restore process. We have completely aba

[BUGS] Shared memory bug

2004-09-11 Thread Rikardo Tinauer
Hello, I don't know whether this really is a bug or is just something I don't know how to configure in the db. I wrote a PL/SQL stored procedure which performs a huge transaction cca. 2 milion record insert. The procedure performs transacting and atfer a while error is thrwn: out od shared memo

Re: [BUGS] vacuum problem

2004-09-11 Thread Gaetano Mendola
John R Pierce wrote: About an hour after mailing that, I realized that the buggy RHEL2.1 system was running with Intel Hyperthreading enabled (so it appeared as 4 CPUs) while the no-problems RH8.0 system had hyperthreading enabled (we'd previously been benchmarking some multithreaded stuff both

Re: [BUGS] vacuum problem

2004-09-11 Thread John R Pierce
About an hour after mailing that, I realized that the buggy RHEL2.1 system was running with Intel Hyperthreading enabled (so it appeared as 4 CPUs) while the no-problems RH8.0 system had hyperthreading enabled (we'd previously been benchmarking some multithreaded stuff both ways). So, its *ju

Re: [BUGS] vacuum problem

2004-09-11 Thread Gaetano Mendola
John R Pierce wrote: > *HOWEVER*... About an hour after mailing that, I realized that the buggy RHEL2.1 system was running with Intel Hyperthreading enabled (so it appeared as 4 CPUs) while the no-problems RH8.0 system had hyperthreading enabled (we'd previously been benchmarking some multithre

Re: [BUGS] 8.0 beta service won't start

2004-09-11 Thread Magnus Hagander
>> This is almost certainly the "pid file does nto go away" >issue. Manually remove the .pid file in the data directory, >and start the service. >> >> I beleive this bug is fixed in beta-2. > >I think we fixed that after beta2. Oh, that might be so. Then let me rephrase - it's fixed in the MS

Re: [BUGS] vacuum problem

2004-09-11 Thread Tom Lane
"John R Pierce" <[EMAIL PROTECTED]> writes: >> You've got some background client holding a transaction open. Or else >> the test program isn't really committing when you think it is. > there are no background programs. I've done all the usual checking of `ps' > outputs looking for such. > in t

Re: [BUGS] 8.0 beta service won't start

2004-09-11 Thread Bruce Momjian
Magnus Hagander wrote: > This is almost certainly the "pid file does nto go away" issue. Manually remove the > .pid file in the data directory, and start the service. > > I beleive this bug is fixed in beta-2. I think we fixed that after beta2. -- Bruce Momjian| ht

Re: [BUGS] Installation failed on Win2k

2004-09-11 Thread Magnus Hagander
>Dear friends > >I'm not able to install postgresql on my Windows Machine: > > >RDBMS Version: 8.0.0 beta2-2dev >OS: Windows 2k - all patches installed (up to date) > >After klicking o.k. in the window that displays the Release Notes, >installation abords with the following message: > >"Installatio

Re: [BUGS] 8.0 beta service won't start

2004-09-11 Thread Magnus Hagander
Title: Meddelande This is almost certainly the "pid file does nto go away" issue. Manually remove the .pid file in the data directory, and start the service.   I beleive this bug is fixed in beta-2.   //Magnus -Ursprungligt meddelande-Från: Mike Hornick [mailto:[EMAIL PROTEC

Re: [BUGS] New PostgreSQL questions...

2004-09-11 Thread Harald Armin Massa
Chari, > 1. All earlier versions of PostgreSQL are able to be editted via an ssh > Shell or some other Unix-based platform. within the postgresql directory there is a /bin directory. There you will find psql.exe, which will allow you that shell access. Within PG_ADMIN there is also a SQL-Butt

Re: [BUGS] PostgreSQL 8.0 - very good

2004-09-11 Thread Harald Armin Massa
It's within the pginstaller at http://pgfoundry.org/projects/pginstaller (you can browse the cvs there. Service creation is done by the windows installer, so it's part of the skripts within wxs, user creation is done in CA-dll, source found in ca directory. ) Harald (but: it will be easier if yo

Re: [BUGS] Pb with ecpg and include file on PG 8.0.0

2004-09-11 Thread Bruce Momjian
Valerie Schneider DSI/DEV wrote: > ... > EXEC SQL INCLUDE DbTablesUtilPg.hh; > ... > >EXEC SQL PREPARE S FROM :sqlstmt; >EXEC SQL DECLARE C_FK_COL CURSOR FOR S; >EXEC SQL OPEN C_FK_COL; >EXEC SQL FETCH MAX_FK IN C_FK_COL INTO :fk_id_L , :valid_L, :target_t_L; > > with MAX_FK a va

Re: [BUGS] Can't run 8.0 ....

2004-09-11 Thread Bruce Momjian
Jon Wheatland wrote: > I just installed Postgres 8.0.0 in my PC environment. I created the > necessary users and rebooted the system. Saw that the post_svc.exe and the > postmaster.exe are running. However, the minute I try to connect to > 'template' I get "too many clients already. Check your