Hello,
Is there a way to recover from the following error?
I have (had) an existing database and wish not
to lose the data tables.
Thanks for any help,
Pete
[EMAIL PROTECTED] /]$ pg_ctl start
postmaster successfully started
[EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at
peter Willis [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at
2004-10-18 11:41:55 PDT
LOG: open of /web2-disk1/grip/database/pg_xlog/ (log
file 0, segment 0) failed: No such file or directory
LOG: invalid primary checkpoint
Tom Lane wrote:
peter Willis [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at
2004-10-18 11:41:55 PDT
LOG: open of /web2-disk1/grip/database/pg_xlog/ (log
file 0, segment 0) failed: No such file or directory
LOG: invalid
On Tue, Oct 19, 2004 at 03:49:04PM -0700, pw wrote:
I set up a cron job to pg_dump and gzip every hour and
dump any backup gz files older than 1 week.
Huh ... be sure to keep some older backup anyway! There was just
someone on a list (this one?) whose last two weeks of backups contained
no
On Tue, Oct 19, 2004 at 03:49:04PM -0700, pw wrote:
I set up a cron job to pg_dump and gzip every hour and
dump any backup gz files older than 1 week.
Huh ... be sure to keep some older backup anyway! There was just
someone on a list (this one?) whose last two weeks of backups
Mike Nolan wrote:
On Tue, Oct 19, 2004 at 03:49:04PM -0700, pw wrote:
I set up a cron job to pg_dump and gzip every hour and
dump any backup gz files older than 1 week.
Huh ... be sure to keep some older backup anyway! There was just
someone on a list (this one?) whose last two weeks of backups