[GENERAL] Clearing locks

2005-03-21 Thread Edwin New
back an incomplete transaction without access to the connection that created the lock? All I've been able to do is a complete stop/start of the database, but that is obviously sub-optimal. Thanks, Edwin New Software Developer Toll - Integrated Business Systems 43 - 63 Princes Highway, Doveton

Re: [GENERAL] PostgreSQL still for Linux only?

2005-03-08 Thread Edwin New
Title: RE: [GENERAL] PostgreSQL still for Linux only? I don't want to split hairs, but wasn't Firebird originally Interbase? If so, you'll find it was originally a *nix product before it was a Windows database (back in the Ashton-Tate days for those with long memories). Edwin New

[GENERAL] How to increase number of connections to 7.2.1

2004-10-17 Thread Edwin New
the server failing to restart. I know we should upgrade from 7.2.1 and that is going to happen soon, but this is a production server and I need a solution sooner. Thanks in advance, Edwin New Analyst Programmer Toll - Integrated Business Systems 43 - 63 Princes Highway, Doveton, VIC. 3175

Re: [GENERAL] How to increase number of connections to 7.2.1

2004-10-17 Thread Edwin New
To: Edwin New Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] How to increase number of connections to 7.2.1 Edwin New [EMAIL PROTECTED] writes: I need to increase the number of connections to PostgreSQL 7.2.1. I have tried changing the value of max_connections in Postgresql.conf. It was commented

Re: [GENERAL] ERROR: AllocSetFree: cannot find block containing c

2004-07-23 Thread Edwin New
months in favour of 7.4.2. I need to get the data out of it. Regards, Edwin. -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 July 2004 12:32 PM To: Edwin New Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] ERROR: AllocSetFree: cannot find block containing