Re: [BUGS] 8.2 pg_freespacemap crash

I wrote: > Hmm. Actually the freespace.c code rounds that number up to the next > multiple of CHUNKPAGES: > /* Allocate page-storage arena */ > nchunks = (MaxFSMPages - 1) / CHUNKPAGES + 1; While that's true, on closer inspection the *real* problem is that CHUNKPAGES is only correct f

[BUGS] Backup -- Feridun Türk

İ have two question, Backup and restore with C# (windos form) interface, or postgre scripts? -- Regards, Feridun Türk

Re: [BUGS] Backup -- Feridun Türk

feridun türk wrote: İ have two question, Backup and restore with C# (windos form) interface, or postgre scripts? thats one question, and its missing information, but as expressed, it seems a choice between two alternatives... A) use the existing pg_dump utility, or B) write your own backup p

[BUGS] 8.2 pg_freespacemap crash

Hi, We've been hit by a pg_freespacemap contrib module crash (SIGSEGV), gdb showed it was in line 162 of it's pg_freespacemap.c file. fctx->record[i].reltablespace = fsmrel->key.spcNode; Thanks to Andrew Gierth (irc:RhodiumToad) and after some analysis and we've been able to understan

Re: [BUGS] 8.2 pg_freespacemap crash

Dimitri Fontaine writes: > Thanks to Andrew Gierth (irc:RhodiumToad) and after some analysis and we've > been able to understand what happened: MaxFSMPages is not the maximum number > of elements (tables and indexes) contained into the FSM memory, and the > contrib believes it is. Hmm. Actua

Re: [BUGS] postgresql-8.3.6-1PGDG : redirect_stderr = on does not start server

Heikki Linnakangas writes: > suresh adapa wrote: >> If I have the above line the and try to start, I can see below in the >> pgstartup.log >> >> FATAL: unrecognized configuration parameter "redirect_stderr" > redirect_stderr was renamed to logging_collector in version 8.3. In general, copying

Re: [BUGS] PostgreSQL 8.3.7: soundex function returns UTF-16 characters

Frans writes: > Does it make sense that the locale setting > influences the workings of the soundex function? Yeah, it absolutely would, because soundex depends on the C library's isalpha() and toupper() functions, and those are influenced by locale. It is clear from looking at the code that so

Re: [BUGS] postgresql-8.3.6-1PGDG : redirect_stderr = on does not start server

suresh adapa wrote: I have build postgresql-8.3.6-1PGDG for rhel5.3 x86_64 But I have problem while starting the postgresql server. When I comment "redirect_stderr" in /var/lib/pgsql/data/postgresql.conf file the server starts properly. If I have the above line the and try to start, I can see

[BUGS] postgresql-8.3.6-1PGDG : redirect_stderr = on does not start server

Hello Sir, I have build postgresql-8.3.6-1PGDG for rhel5.3 x86_64 But I have problem while starting the postgresql server. When I comment "redirect_stderr" in /var/lib/pgsql/data/postgresql.conf file the server starts properly. If I have the above line the and try to start, I can see

Re: [BUGS] PostgreSQL 8.3.7: soundex function returns UTF-16 characters

Tom Lane wrote: Frans writes: Tom Lane wrote: The fuzzystrmatch module doesn't really work with utf8 (nor any other multibyte encoding), because it depends on the functions. What you'll probably get when applying it to non-ascii utf8 is an invalidly encoded string. Well, in 8.