[PERFORM] Encoding on 8.0.4

2005-11-03 Thread Don Drake
I recently upgraded my DB from 7.4.3 to 8.0.4 and I've noticed the following errors appearing in my serverlog: 2005-11-03 05:56:57 CST 127.0.0.1(38858) ERROR:  Unicode characters greater than or equal to 0x1 are not supported 2005-11-03 06:04:09 CST 127.0.0.1(38954) ERROR:  invalid byte s

Re: [PERFORM] Server crashing

2005-04-11 Thread Don Drake
d the DB. I've done this on my Linux server many times and it never complained. I won't be doing that again. -Don On Apr 11, 2005 1:29 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > Don Drake <[EMAIL PROTECTED]> writes: > > My server is crashing on a delete statement.

[PERFORM] Server crashing

2005-04-10 Thread Don Drake
My server is crashing on a delete statement. Here's the error message in the log file: LOCATION: ShutdownXLOG, xlog.c:3090 LOG: 0: database system is shut down LOCATION: ShutdownXLOG, xlog.c:3104 LOG: 0: database system was shut down at 2005-04-10 21:54:34 CDT LOCATION: StartupXLOG,

Re: [PERFORM] Postgres stopped running (shmget failed)

2005-01-25 Thread Don Drake
On Tue, 25 Jan 2005 11:18:05 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Don Drake <[EMAIL PROTECTED]> writes: > > This morning I found the postgres not running and the following in my log > > file: > > > 2005-01-25 01:38:22 FATAL: could not create shared

[PERFORM] Postgres stopped running (shmget failed)

2005-01-25 Thread Don Drake
My db server is running under high load recently and the number of connections during the morning hours is actually very high. This morning I found the postgres not running and the following in my log file: DETAIL: The postmaster has commanded this server process to roll back the current transac

[PERFORM] Table Partitions: To Inherit Or Not To Inherit

2004-11-16 Thread Don Drake
I've read the previous thread on the list regarding partitioning mechanisms and I just wrote a plpgsql function to create the partition tables (by date) as well as another function used to do the insert (it determines which table will be inserted). The creation of the partition tables uses the inh