pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: hema@crgroup.co.in
Subject: BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left
Date: Tue, 18 Aug 2020 13:43:40 +0000
Message-ID: <16584-b8fc3287c0279902@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16584
Logged by:          hema tb
Email address:      hema@crgroup.co.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



view thread (2+ messages)  latest in thread

Message-ID: <16584-b8fc3287c0279902@postgresql.org>
Permalink:  ../16584-b8fc3287c0279902@postgresql.org/
Also on:    postgresql.org/message-id/16584-b8fc3287c0279902@postgresql.org

 · 

reply

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-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, hema@crgroup.co.in
  Subject: Re: BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left
  In-Reply-To: <16584-b8fc3287c0279902@postgresql.org>

* 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