Ok, thanks.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [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
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
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
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
Sorry, nevermind; I discovered \? and figured it out.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
I'm someone with some mysql experience and need to set up postgres for
a product we're evaluating. In mysql I can use SHOW DATABASES to list
all of the databases on the system, USE DB1 to switch to one of the
databases, SHOW TABLES to list all of the table names in the database
I'm USEing, and DE
