[GENERAL] - Regarding Schema ROLLBACK
Hello All,
I have run CREATE SCHEMA xyz accidentally, and it replaced my existing
schema (xyz) with tables, and i have lost all my data.
Is there any way to rollback or get the schema back with old tables and
data.
Any help would be appreciated.
--
Regards :
Venktesh Guttedar.
On Tue, Nov 28, 2017 at 7:23 AM, VENKTESH GUTTEDAR <
venkteshguttedar@gmail.com> wrote:
Hello All,
I have run CREATE SCHEMA xyz accidentally, and it replaced my existing
schema (xyz) with tables, and i have lost all my data.Is there any way to rollback or get the schema back with old tables
and data.Any help would be appreciated.
--
Regards :
Venktesh Guttedar.
*>Is there any way to rollback or get the schema back with old tables and
data.*
*Hopefully you have a pg_dump of the database or schema.*
*If it in in plain format, you can edit the dump and recover the tables
that way.*
*If it is in custom format, you can use the -l option to list and edit,
then restore with -L option.*
*https://www.postgresql.org/docs/9.6/static/app-pgrestore.html
<https://www.postgresql.org/docs/9.6/static/app-pgrestore.html>*
*Otherwise, your next option would be trying to use PITR recovery,
providing you have available WAL files.*
*https://www.postgresql.org/docs/9.6/static/continuous-archiving.html
<https://www.postgresql.org/docs/9.6/static/continuous-archiving.html>*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR <
venkteshguttedar@gmail.com> wrote:
I have run CREATE SCHEMA xyz accidentally, and it replaced my existing
schema (xyz) with tables, and i have lost all my data.
As far as I know "CREATE SCHEMA" by itself cannot "drop" data nor would it
successfully execute if a schema of the same name already exist...
As Melvin says if you've truly dropped the data you will need to resort to
backups of some form.
David J.
On 28 Nov 2017, at 16:43, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tue, Nov 28, 2017 at 5:23 AM, VENKTESH GUTTEDAR <venkteshguttedar@gmail.com> wrote:
I have run CREATE SCHEMA xyz accidentally, and it replaced my existing schema (xyz) with tables, and i have lost all my data.As far as I know "CREATE SCHEMA" by itself cannot "drop" data nor would it successfully execute if a schema of the same name already exist...
As Melvin says if you've truly dropped the data you will need to resort to backups of some form.
David J.
Just what I was thinking. Are you looking in the correct database?
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
