PgSql

RV: Problem at install / uninstall postgresql
Hello! I?m installing postgresql in a O.S. Linux Ubuntu 6.06 and I have the next printout at installation process: Setting up postgresql-7.4 (7.4.12-3) ... Error: cluster configuration already exists I can?t find information about how I can solve the problem at Internet a... 25 Aug 2006 06:50

Replication
Ühel kenal päeval, E, 2006-08-21 kell 21:46, kirjutas Fujii Masao: Stefan Kaltenbrunner wrote: It is however async replication so you can loose data commited on the master but not yet replicated to the slaves in case you loose the master completely. Yes, here is an insufficient point of Slony-... 25 Aug 2006 12:48

WIP: bitmap indexes
Gavin Sherry <swm(a)linuxworld.com.au> writes: Attached is an update to the patch implementing bitmap indexes Jie sent last week. What's the current status of this patch ... has any work been done since the first of the month? I suppose the patch as given here no longer applies to HEAD, because of recent ch... 5 Sep 2006 19:05

Simplifying "standby mode"
I'm in process of reviewing the restartable-recovery patch, http://archives.postgresql.org/pgsql-patches/2006-07/msg00356.php and I'm wondering if we really need to invent a "standby mode" boolean to get the right behavior. The problem I see with that flag is that it'd be static over a run, whereas the behavior we... 13 Sep 2006 05:19

Bug in sql_fmgr when envoked via copy
A fresh cvs update of -HEAD produces the following when I attempt to import a dump that has a domain using a SQL function as part of the check constraint.. This error only shows while using COPY for more than 1 row. Inserts work fine. Find attached a simple self contained test case. gdb ../bin/postgres post... 4 Aug 2006 17:57

Attack against postgresql.org ...
There are some days where High Speed Internet for Personal use just should never have been invented ... Over the past 24 hours, we've been experiencing a problem with the network that has taken us a bit to identify as being at our end, and a little bit longer to identify as being with the postgresql.org vSer... 28 Jul 2006 13:44

timezones to own config file
I looked into the timezone specifications and basically extracted a list of existing offsets from the zic database. My proposed format for the timezone files is something like this: HADT -32400 D # Hawaii-Aleutain Daylight Time # (America/Adak) HAST -36000 # Hawaii-Aleutain Standar... 14 Jun 2006 18:00

Extended SERIAL parsing
Hi, after some experimentation, I came up with the attached patch, which implements parsing the following SERIAL types: SERIAL SERIAL GENERATED { ALWAYS | BY DEFAULT } SERIAL GENERATED [ ALWAYS | BY DEFAULT ] AS IDENTITY( sequence options ) The underlying type is still int4 or int8, so the problems you dis... 12 Jun 2006 19:27

psql \copy warning
I use the \copy command from psql to load data into postgres. I was fiddling with setting up a database on a HEAD build, and I got the following new warning testy=# \copy episodes from 'episodes.data' with delimiter as '\t' WARNING: nonstandard use of escape in a string literal LINE 1: COPY episodes FROM STDIN... 25 May 2006 12:31

PANIC: could not locate a valid checkpoint record
Other than backing up $PGDATA and running pg_resetxlog Is there any advice ? Dave Nov 16 18:03:30 dx1-ptr postgres[22337]: [6-2] '2005-11-16 17:47:31' Nov 16 18:03:32 dx1-ptr postgres[29335]: [2-1] LOG: received fast shutdown request Nov 16 18:03:32 dx1-ptr postgres[29335]: [3-1] LOG: aborting any ... 16 Nov 2005 16:50