> -Original Message-
> From: Bhella Paramjeet-PFCW67 [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 24, 2008 1:13 PM
> To: Tom Lane
> Cc: pgsql-admin@postgresql.org; Subbiah Stalin-XCGF84
> Subject: Re: Vacuumdb error - corruption
>
>
> According to our sysadmin there are no bad disk
> Hi,
>
> Barbara Stephenson a écrit :
> > We are new about autovacuum launcher on 8.3.1 and we are not sure what
> the
> > parameters should be set to. Is setting them to default ok until we can
> > monitor if it's vacumming too much?
> >
>
> You can do that. But the default are, as always with
We have "one" corrupted table in a v7.2.4 database. The others are good.
We have identified the table should have 25 rows in it, and using pg_dump we
can get the first 10.
I was wondering if we could use the zero_damaged_pages under v7.2 to
hopefully skip over the corrupted data and read the re
ion solutions is not simple enough. (I have used Oracle's
Advanced replication in the past)
Thanks
Eric Comeau
<[EMAIL PROTECTED]>
-Original Message-
From: Andrew Sullivan [mailto:andrew@;libertyrms.info]
Sent: Friday, November 01, 2002 1:27 PM
To: [EMAIL PROTECTED]
Subject: Re:
ALTER TABLE ALTER column TYPE varchar(xxx)
We need to increase the length of a varchar(256) column in two of our
largest tables preferrably to TEXT.
Is there a way to do this without having to go through a complete table
rewrite?
I have googled and seen the todo on the wiki, but I'm wonde
We currently have statement timeout set
statement_timeout = 1080 # 3 hrs
and we receive the following in the postgresql.log
[1-1] ERROR: canceling statement due to statement timeout
Is there a way to have the SQL statement logged as well?
We have set the log_min_duration_state
On 11-04-13 12:37 PM, Kevin Grittner wrote:
Eric Comeau wrote:
We currently have statement timeout set
statement_timeout = 1080 # 3 hrs
and we receive the following in the postgresql.log
[1-1] ERROR: canceling statement due to statement timeout
Is there a way to have the
On 11-05-17 02:56 PM, Maria L. Wilson wrote:
Anybody have any experience or issues running postgres (version8.4) on a
CVFS filesystem?
thanks much
Maria Wilson
NASA/Langley Research Center
Hampton, Virginia 23681
m.l.wil...@nasa.gov
Why would you want to do this?
What are you hoping to