From: Scott Marlowe <scott.marlowe@gmail.com>
To: e t <albunix@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: server crash, need to restore DB functionality
Date: Tue, 29 Apr 2008 12:52:41 -0600
Message-ID: <dcc563d10804291152l50ff2f01n1a3f29e59402f7cc@mail.gmail.com> (raw)
In-Reply-To: <82d6a2d00804291018h3f05bbe3gb21cae15eb7a0643@mail.gmail.com>
References: <82d6a2d00804291018h3f05bbe3gb21cae15eb7a0643@mail.gmail.com>
On Tue, Apr 29, 2008 at 11:18 AM, e t <albunix@gmail.com> wrote:
> Hello,
>
> we run
>
> 7.4.7
>
> on a Redhat RHEL server.
Two points.
1: The 7.4.x series is pretty old. You should consider upgrading to a
newer version when you have time. 8.3.1 is stable but a little new.
8.2.7 is very stable and much faster than 7.4.
2: 7.4 series is up to 7.4.19. You may be missing 3 years of updates,
unless you are using RedHat's version and they are back porting fixes
to 7.4.7. I didn't think they did that, but Tom Lane would be a good
person to ask about that.
> Today that was a severe server crash and NOC seems to have repeatedly
> attempted a reboot without properly unmounting the file systems.
The machine that gives them a banana when they push a button probably
wasn't working quite right :)
> I am getting errors such as the following
>
> Apr 29 13:15:34 cp postgres[4961]: [106-1] ERROR: could not open relation
> "users_pkey": Permission denied
> Apr 29 13:15:34 cp postgres[4961]: [107-1] ERROR: could not open relation
> "users_pkey": Permission denied
> Apr 29 13:15:34 cp postgres[4957]: [113-1] ERROR: could not open relation
> "users_pkey": Permission denied
>
> when attempting to have my application connect to the DB
>
> Please let me know what sort of procedure are available to us
> to have such functionality restored.
you should restore from backup if possible.
> We do have backups.
pg_dump backups (good thing) or file system backups (maybe good,
likely not coherent)
> Being it is one day old, are we going to loose information when attempting
> to do a restore?
Well, if you can't connect, then no. OTOH, if you can still connect
and you've been updating data, then yes. you'll lost everything you
had since your last backup.
You may be able to fix things. Trying reindexing the failing table / indexes.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, albunix@gmail.com
Subject: Re: server crash, need to restore DB functionality
In-Reply-To: <dcc563d10804291152l50ff2f01n1a3f29e59402f7cc@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox