In my application, when press button "Backup" in UI, it invokes pg_dump
to backup the database. It may take few minutes for the whole process.
If I want to pause the process, what should I do. And also how to resume
the process? Can I pause while pg_restore?
Thanks
KevinChen
> Row level: it would be very expensive to compute, store and keep up to date.
> And it doesn't protect you from corruption elsewhere in the block.
> Block level: there was some effort to implement it for 8.4, but it fell into
> some deadly traps.
Checksum is my primitive thought, is there ta
To: Chen, Dongdong (GE Healthcare)
Cc: j...@commandprompt.com; Alvaro Herrera; pgsql-general@postgresql.org
Subject: Re: [GENERAL] need help for PostgreSQL consistency check mechanism
On Thu, Apr 23, 2009 at 8:24 PM, Chen, Dongdong (GE Healthcare)
wrote:
> I wanna know if there is any way
.
ChenDongdong
-Original Message-
From: Joshua D. Drake [mailto:j...@commandprompt.com]
Sent: Friday, April 24, 2009 9:18 AM
To: Chen, Dongdong (GE Healthcare)
Cc: Alvaro Herrera; pgsql-general@postgresql.org
Subject: Re: [GENERAL] need help for PostgreSQL consistency check
mechanism
On Fri
, April 24, 2009 8:22 AM
To: Chen, Dongdong (GE Healthcare)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] need help for PostgreSQL consistency check
mechanism
Chen, Dongdong (GE Healthcare) wrote:
> We are now working on database check mechanism in our application. The
> situation i
We are now working on database check mechanism in our application. The
situation is when server shutdown abnormally, the postmaster.pid file
still exists when reboot, But the PostgreSQL database itself may not be
damaged. We just do not want to restore from backups when the database
is still good e
Hi:
I am a software engineer from GE. I am using JDBC to operate
PostgreSQL8.3 in Ubuntu8.04. The develop environment is Eclipse3.2 My
problem is:
There is a PostgreSQL table XX containing 5 fields: AA, BB, CC, DD,
EE, AA is primary key and auto-generated type, BB, CC, DD and EE is
string
