Hello all.
This is a first time I receive such an issue.
My database was corrupted some way.
When I'm trying to access the database via psql I receive:
root@udb:/etc/bacula# psql -U bacula
psql: FATAL: could not read block 0 in file "base/16387/86057840": read only 0
of 8192 bytes
So I want t
sion critical, so if you want - I can experiment on this.
On Wed, 09 Nov 2011 21:04:47 +0800
Craig Ringer wrote:
> On 11/09/2011 07:02 PM, Ruslan A. Bondar wrote:
> > Hello all.
> >
> > This is a first time I receive such an issue.
> > My database was corrupted some way.
No, this was a clean install of 9.0.x.
Maybe It was upgraded from 9.0.3 to 9.0.4. I'm not sure.
On Wed, 09 Nov 2011 09:21:18 -0600
"Kevin Grittner" wrote:
> "Ruslan A. Bondar" wrote:
>
> > ERROR: could not access status of transaction 15892843
> >
Why have you decided it isn't using indexes?
If index exists - postgres will use it.
To write a script for this I need at least database version.
On Wed, 09 Nov 2011 16:22:20 +0100
Silvio Brandani wrote:
> Our database seems not using index anymore, please help with, is a
> production database
> > So I've stopped software caused these inserts and deletes, but
> > reindexing shows same warnings. I've restarted postgresql server.
>
> How did you restart PostgreSQL?
>
> If there were backends hung in the vfs, did the eventually terminate
> by themselves? If not, did you terminate them you
