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. Zip

[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

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:

Re: [ADMIN] Off-topic - Hardware recommendation

2009-07-29 Thread Kevin Grittner
Benjamin Krajmalnik k...@illumen.com 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

[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 =

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

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, trend =

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 the

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com 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

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

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,

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Tom Lane
Benjamin Krajmalnik k...@illumen.com 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,

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

Re: [ADMIN] Error in creating the backend query

2009-07-29 Thread Tom Lane
Benjamin Krajmalnik k...@illumen.com 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.

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 Eisentrautpete...@gmx.net 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