[ADMIN] Encoding problem using pg_dumpall

2009-01-29 Thread Moshe Ben-Shoham
ue, publish_tag) TO stdout; pg_dumpall: pg_dump failed on database "opencms", exiting it probably means that some UTF-8 characters cannot be represented in WIN1252 which is the encoding of the output file. Is there any solution to this problem? Thanks, Moshe Ben Shoham. The i

[ADMIN] Inserts hang in DB and error messages in log

2009-05-20 Thread Moshe Ben-Shoham
Hi, We're working with version 8.3.5-1. Lately we started seeing insert statements hang in the DB. The statements come from two different clients. When it happens, I see the following messages in the log every second or so: 2009-05-21 08:56:49 IDT ERROR: permission denied to set pa

[ADMIN] PostgreSQL crashes

2009-05-27 Thread Moshe Ben-Shoham
Hi, We're using postgresql-8.3.5-1. Lately, once in a while, the PostgreSQL service crashes and the following appears in the log. Any idea what could cause that? I believe there are two problems here: one is the process 2604 exiting with code 128, and the other one is the re-initializat

Re: [ADMIN] PostgreSQL crashes

2009-05-27 Thread Moshe Ben-Shoham
It's on Windows Server 2003 Thanks, Moshe. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Wednesday, May 27, 2009 5:33 PM To: Moshe Ben-Shoham Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] PostgreSQL crashes "Moshe Ben-Shoham" writes: > 2

Re: [ADMIN] PostgreSQL crashes

2009-09-07 Thread Moshe Ben-Shoham
FATAL: pre-existing shared memory block is still in use 2009-09-07 12:16:02 IDTHINT: Check if there are any old server processes still running, and terminate them. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Sunday, May 31, 2009 7:39 PM To: Moshe Ben-Shoham Cc: pgsql-