Re: Problem creating a database

Joshua White wrote:
> > > > > > psql: FATAL: could not open file "base/618720/2610": No such file or directory
> > >
> > > "pg_index" initially uses file 2610.
> > >
> > > Anyway, your database seems to be quite wrecked, and you'd probably need
> > > an expert to save what can be saved.
> >
> So you're right about it being seriously corrupted somehow. All my custom databases seem to work fine.
> I have data checksums and amcheck enabled and haven't found any issues using the query below.
>
> SELECT bt_index_check(index => c.oid), c.relname, c.relpages
> FROM pg_index i
> JOIN pg_opclass op ON i.indclass[0] = op.oid
> JOIN pg_am am ON op.opcmethod = am.oid
> JOIN pg_class c ON i.indexrelid = c.oid
> JOIN pg_namespace n ON c.relnamespace = n.oid
> WHERE am.amname = 'btree'
> -- Don't check temp tables, which may be from another session:
> AND c.relpersistence != 't'
> AND i.indisready AND i.indisvalid
> ORDER BY c.relpages DESC;
>
> However, when I went to connect to template1, it failed:
>
> # \connect template1
> FATAL: could not open file "base/1/2610": No such file or directory
> Previous connection kept
>
> If template1 is corrupt, that would explain why I am unable to create new databases.

Right. I think that dumping what you can and importing it in a new cluster
is the way to go.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com