Re: [ADMIN] Vacuumdb error - corruption

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

Re: [ADMIN] Converting from 7.4.19 To 8.3.1 & want to use autovacuum

> 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

[ADMIN] Corrupt table, is zero_damaged_pages available in v7.2?

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

Re: [ADMIN] HA for high insert volume

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:

[ADMIN] Increasing the length of a VARCHAR column without table rewrite

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

[ADMIN] How to log canceled SQL statement due to statement timeout

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

Re: [ADMIN] How to log canceled SQL statement due to statement timeout

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

Re: [ADMIN] postgres on CVFS / StorNext filesystem

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