Re: [ADMIN] General queries regarding backup

2009-07-29 Thread Deepak Bala
Thanks for your replies Peter. On Wed, Jul 29, 2009 at 12:45 PM, Peter Eisentraut wrote: > On Wednesday 22 July 2009 08:25:36 Deepak Bala wrote: >> Hi everyone, >> >> I have some queries regarding the PITR backup procedure on Postgres >> 8.3. Here are the steps I follow for backup >> >> 1. I set u

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Tom Lane
"Benjamin Krajmalnik" writes: > So the plpgsql stored procedure is definitely the source. If you want to convince me of that you need to provide a *self contained* demonstration. An out-of-context procedure definition isn't helpful because I can't test it. regards, tom l

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Benjamin Krajmalnik
I wish that were the case. I am running 8.3.7 built from the FreeBSD ports. All insertions and updates to that table (or any others) are done exclusively through that (or other) stored procedures. We only use ad-hoc queries for selecting data for presentation purposes. Our code does not cast any co

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Tom Lane
"Benjamin Krajmalnik" writes: > Below is the full stored procedure. All I can do is repeat that plpgsql does not behave that way. It never has AFAIR, and it most definitely doesn't in any version new enough to recognize the COST option to CREATE FUNCTION (ie, 8.3 and up). In fact, I don't belie

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Benjamin Krajmalnik
Below is the full stored procedure. The error as captured in pg_log is as follows: 2009-07-29 11:19:01 MDT 172.20.1.33ERROR: syntax error at or near "is" at character 192 2009-07-29 11:19:01 MDT 172.20.1.33STATEMENT: update tblksalerts set cleartime = '2009-07-29 10:49:50'::TIMESTAMP, laststatus

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Alvaro Herrera
Benjamin Krajmalnik wrote: > I tried it with both on and off, and it did not make a difference. Please show a complete example. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Tom Lane
Alvaro Herrera writes: > Benjamin Krajmalnik wrote: >> Please note the "lasteventsource is null" instead of "lasteventsource = >> null" which is being generated when the value of x_eventsource is null. > Do you have transform_null_equals set? Even if he did, that wouldn't affect the source form

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Benjamin Krajmalnik
I tried it with both on and off, and it did not make a difference. > -Original Message- > From: Alvaro Herrera [mailto:alvhe...@commandprompt.com] > Sent: Wednesday, July 29, 2009 3:20 PM > To: Benjamin Krajmalnik > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Error in creating th

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Alvaro Herrera
Benjamin Krajmalnik wrote: > update tblksalerts set cleartime = '2009-07-29 10:49:50'::TIMESTAMP, > laststatusid = 7::INTEGER, lastreplytext = '0'::VARCHAR, lasttesttime = > '2009-07-29 10:49:50'::TIMESTAMP, lasteventsource is NULL::VARCHAR, > lasteventid is NULL::INTEGER, replyval = 0::REAL, tren

Re: [ADMIN] Off-topic - Hardware recommendation

2009-07-29 Thread Michael Monnerie
On Mittwoch 29 Juli 2009 Benjamin Krajmalnik wrote: > My question deals more than anything on the Fibre Channel host > adapter - is anyone using a Finre Channel adapter on FreeBSD which > they can recommend? We have two HP DL 385 accessing a Fibre Channel Subsystem http://www.starline.de/infortren

[ADMIN] Error in creating the backend query

2009-07-29 Thread Benjamin Krajmalnik
PostgreSQL 8.3.7 running on FreeBSD. The following query: update tblksalerts set cleartime = x_cleartime, laststatusid = x_statusid, lastreplytext = x_replytxt, lasttesttime = x_testtime

Re: [ADMIN] Off-topic - Hardware recommendation

2009-07-29 Thread Kevin Grittner
"Benjamin Krajmalnik" wrote: > The nature of the application dictates that we use shared storage to > provide high availability (in case one of the servers has a > failure). At the risk of starting a flame war, I'd suggest that you compare the cost and benefit of the proposed solution to repl

Re: [ADMIN] Off-topic - Hardware recommendation

2009-07-29 Thread Alan McKay
You are probably best off asking this on a FreeBSD list. -- “Don't eat anything you've ever seen advertised on TV” - Michael Pollan, author of "In Defense of Food" -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgr

[ADMIN] Off-topic - Hardware recommendation

2009-07-29 Thread Benjamin Krajmalnik
I apologize for the slightly off-topic question. I will be building a new PostgreSQL server running 8.4 on FreeBSD 7.2 64-bit. The nature of the application dictates that we use shared storage to provide high availability (in case one of the servers has a failure). After doing some research in t

Re: [ADMIN] General queries regarding backup

2009-07-29 Thread Peter Eisentraut
On Wednesday 22 July 2009 08:25:36 Deepak Bala wrote: > Hi everyone, > > I have some queries regarding the PITR backup procedure on Postgres > 8.3. Here are the steps I follow for backup > > 1. I set up WAL archiving and checked that this is working. > 2. Execute SELECT pg_start_backup('label') > 3