Skip site navigation (1) Skip section navigation (2)

Re: erroneous restore into pg_catalog schema

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: "Erik Rijkers" <er(at)xs4all(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: erroneous restore into pg_catalog schema
Date: 2013-01-13 15:53:30
Message-ID: m238y513lx.fsf@2ndQuadrant.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
"Erik Rijkers" <er(at)xs4all(dot)nl> writes:
> (and yes, I did restore a 65 GB table into the pg_catalog schema of a dev machine; how can I
> remove it? I could initdb, but it's 200+ GB; I'd rather not have to rebuild it)

See allow_system_table_mods

  http://www.postgresql.org/docs/9.2/static/runtime-config-developer.html

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


In response to

pgsql-hackers by date

Next:From: Kevin GrittnerDate: 2013-01-13 15:58:32
Subject: Re: [Pgbuildfarm-members] Version 4.10 of buildfarm client released.
Previous:From: Dimitri FontaineDate: 2013-01-13 15:44:51
Subject: Re: ToDo: log plans of cancelled queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group