Re: [ADMIN] Warm/hot backup server question

2007-10-08 Thread Joshua D. Drake
On Mon, 8 Oct 2007 21:34:10 -0400 "Faber J. Fedor" <[EMAIL PROTECTED]> wrote: > On 07/10/07 21:42 -0400, Tom Lane wrote: > > If they won't let you update to 7.4.18 (the current release in that > > branch), you would be best advised to resign at once, before you get > > blamed for the train wreck t

Re: [ADMIN] Warm/hot backup server question

2007-10-08 Thread Faber J. Fedor
On 07/10/07 21:42 -0400, Tom Lane wrote: > If they won't let you update to 7.4.18 (the current release in that > branch), you would be best advised to resign at once, before you get > blamed for the train wreck that is inevitably in this system's future. Done. Now, how are you on giving advice to

Re: [ADMIN] Installing postgreSQL

2007-10-08 Thread Scott Marlowe
On 10/8/07, Malm Paul <[EMAIL PROTECTED]> wrote: > > Hi, > I'm trying to install PostgreSQL 8.2.5 on a WIN XP computor. > I have removed the path to cygwin, but It will still not be installed. > > The error I'm getting is: > > Your local 'Administrators' group contains 'Interactive users' > This is

Re: [ADMIN] postgres: will not recognise existing tables

2007-10-08 Thread Scott Marlowe
On 10/6/07, Darren Reed <[EMAIL PROTECTED]> wrote: > I've run into this problem twice in the last few days. > > postgresql is running, shutdown, reboot, restart, and tables are missing. > > The shutdown is clean: > LOG: unexpected EOF on client connection > LOG: received smart shutdown request >

Re: [ADMIN] PL/JAVA ResultSetProvider Problem

2007-10-08 Thread Rodrigo De León
On 10/8/07, yogesh <[EMAIL PROTECTED]> wrote: > Does any Body have some Idea? Please provide DDL + sample data to try and help you better. ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at

Re: [ADMIN] Postgresql takes more time to update

2007-10-08 Thread Peter Koczan
On 10/7/07, Suresh Gupta VG <[EMAIL PROTECTED]> wrote: > > Hi Peter, > > > > Thanks for your reply and to your colleague Scott. Can you pls explain > below sentence marked in red. > > > > - - -- - > > As an alternative to Scott's suggestion (upg

[ADMIN] PL/JAVA ResultSetProvider Problem

2007-10-08 Thread yogesh
Hello EveryBody, I have a problem in Postgres using resultsetProvider. I have to fire a query to database that return multiple records with multiple fields. Now on the Basis of the Results I have to fire number of different queries and get the result. ad put it in the Result Set. Example

[ADMIN] Installing postgreSQL

2007-10-08 Thread Malm Paul
Hi, I'm trying to install PostgreSQL 8.2.5 on a WIN XP computor. I have removed the path to cygwin, but It will still not be installed. The error I'm getting is: Your local 'Administrators' group contains 'Interactive users' This is a common configuration error that causes sequrity issues.For t

FW: [ADMIN] Postgresql takes more time to update

2007-10-08 Thread Suresh Gupta VG
Bounced this mail, so sending you again. with thanks and regards, G.V. Suresh Gupta Sr. Software Engineer Batelco Phase II Mo: +91 9890898688 Ph : +9120 66453213 From: Suresh Gupta VG Sent: Sunday, October 07, 2007 12:40 PM To: 'Peter Koczan';

Re: [ADMIN] Postgresql takes more time to update

2007-10-08 Thread Suresh Gupta VG
Hi Peter, Thanks for your reply and to your colleague Scott. Can you pls explain below sentence marked in red. - - -- - As an alternative to Scott's suggestion (upgrading to the newest 7.4), you could update your postgresql installation

[ADMIN] warm/hot backup of Postgresql

2007-10-08 Thread Faber Fedor
Hi, I've been tasked with the problem of creating hot/warm backup server of a live Postgresql server. The problem is two-fold: 1) it's version 7.4.9 and an upgrade is not feasible at this time and b) there are multiple instances of postgresql running on the box; not multiple databases, multiple *

Re: [ADMIN] Is my database now too big?

2007-10-08 Thread Darren Reed
Scott Marlowe wrote: ... Any reasonably modern version of pgsql should simply stop accepting requests rather than suffering loss due to txid wraparound.So,I can think of two possibilities here. Bad hardware or operator error. Assuming you've checked out your machine thoroughly for bad hardware,

[ADMIN] postgres: will not recognise existing tables

2007-10-08 Thread Darren Reed
I've run into this problem twice in the last few days. postgresql is running, shutdown, reboot, restart, and tables are missing. The shutdown is clean: LOG: unexpected EOF on client connection LOG: received smart shutdown request LOG: shutting down LOG: database system is shut down LOG: dat