On 2002.10.16 00:34 Nigel J. Andrews wrote:
> On Tue, 15 Oct 2002, Tom Lane wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > Rusty Wright wrote:
> > >> Are there commands provided with postgresql for checking the databases
> > >> and also for repairing them?
> >
> > > We don't have ch
t
> because I was searching for documentation on some sort of db check
> utility and didn't find anything.
>
>Date: Wed, 16 Oct 2002 16:40:21 -0400
>From: Vincent Janelle <[EMAIL PROTECTED]>
>To: Rusty Wright <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
&
m: Vincent Janelle <[EMAIL PROTECTED]>
To: Rusty Wright <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] newbie qs; fixing and checking databases
The rest of us read the documentation..
On Wed, 16 Oct 2002 13:12:07 -0700 (PDT)
Rusty Wright <[EMAIL PROT
To: "Bruce Momjian" <[EMAIL PROTECTED]>,
> "Rusty Wright" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: RE: [ADMIN] newbie qs; fixing and checking databases
>Date: Wed, 16 Oc
Some of us are just paranoid and like to be prepared when there really
is a fire.
From: "ken" <[EMAIL PROTECTED]>
To: "Bruce Momjian" <[EMAIL PROTECTED]>,
"Rusty Wright" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>, <[EMAIL
newbie qs; fixing and checking databases
Rusty Wright wrote:
> It seems to me that if the machine crashes in the middle of a
> transaction that there will be or is a very high chance of database
> corruption. I don't know if and how postgresql would detect and
> handle that after
Rusty Wright wrote:
> It seems to me that if the machine crashes in the middle of a
> transaction that there will be or is a very high chance of database
> corruption. I don't know if and how postgresql would detect and
> handle that after the system reboots. We are running mysql here and
> have
It seems to me that if the machine crashes in the middle of a
transaction that there will be or is a very high chance of database
corruption. I don't know if and how postgresql would detect and
handle that after the system reboots. We are running mysql here and
haven't had any data integrity pro
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Rusty Wright wrote:
>> Are there commands provided with postgresql for checking the databases
>> and also for repairing them?
> We don't have checks because thing rarely break.
Or at least: there are seldom any programmable-in-advance patterns to
our f
Rusty Wright wrote:
> Are there commands provided with postgresql for checking the databases
> and also for repairing them? I'd like to be able to run something to
> check the databases before our nightly backups.
We don't have checks because thing rarely break. You can do a VACUUM,
which does
Are there commands provided with postgresql for checking the databases
and also for repairing them? I'd like to be able to run something to
check the databases before our nightly backups.
Thanks
---(end of broadcast)---
TIP 5: Have you checked our
11 matches
Mail list logo
