BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: hema(at)crgroup(dot)co(dot)in
Subject: BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left
Date: 2020-08-18 13:43:40
Message-ID: 16584-b8fc3287c0279902@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16584
Logged by: hema tb
Email address: hema(at)crgroup(dot)co(dot)in
PostgreSQL version: 9.6.18
Operating system: linux 64 bit
Description:

I have taken the backup in the .bak format and I restored it to the new DB
using command "psql dbname < filename.bak". after restoration I tried to
connect the DB but I am getting this error "could not create relation-cache
initialization file "global/pg_internal.init.5635": No space left on
device". Anyway its connected and when i execute this \dt command, I got "No
relations found" error.
when I tried this command " GRANT ALL ON SCHEMA public TO public;" its
throwing an error like could not access status of transaction 0 DETAIL:
Could not write to file "pg_subtrans/00A1" at offset 139264: No space left
on device.

Can anyone help me to resolve this issue?

Thanks in Advance
Hema

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Magnus Hagander 2020-08-18 14:25:00 Re: BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left
Previous Message Tom Lane 2020-08-17 22:37:47 Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails