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
"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
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
"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
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
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-
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
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
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
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
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
"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
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
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
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
15 matches
Mail list logo