[GENERAL] Clearing locks

2005-03-21 Thread Edwin New
roll 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 Princ

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 memori

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

2004-10-17 Thread Edwin New
: 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 &g

[GENERAL] How to increase number of connections to 7.2.1

2004-10-17 Thread Edwin New
ted in 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.

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

2004-07-23 Thread Edwin New
t six 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 conta