Hello world, May i have more info about 'slony1_extract_schema.sh ' command. I'm not sure to understand what it it it supposed to do.
For instance, looking at the doc ( http://slony.info/documentation/adminscripts.html 19.4. slony1_extract_schema.sh) : - "It dumps the origin node's schema, including the data in the Slony-I cluster schema." What is called 'origin node's schema' : My schema database before intrusive slony hacks? - "A slonik script is run to perform UNINSTALL NODE<http://slony.info/documentation/stmtuninstallnode.html>on the temporary database. This eliminates all the special Slony-I tables, schema, and removes Slony-I triggers from replicated tables." At this step, does it mean i got my schema and data before any intrusive slony hacks? - " Finally, pg_dump is run against the temporary database, delivering a copy of the cleaned up schema to standard output" I expected a dumped file or new 'mytmpbase' in postgres. I understand this a design choice. Why not making a real dump on disk? Why removing the mytmpbase after the treatment? Btw i would like to submit here a weird test : i perform the command wheras the 'mytmpbase' already exits with a user is connected : I run the command with the following usage : $> slony1_extract_schema.sh mybase mycluster mytmpbase - At the beginning, it complains : createdb: échec lors de la création de la base de données : ERREUR: La base de données « mytmpbase» existe déjà Sorry but my terminal are french. But i guess the translanlation woulk look like : createdb: error on creating database : ERROR: database « mytmpbase» already exists But it goes on. - Btw, it always says at the begining of its process : Warning: Set 1 does not origin on node 1 - original triggers and constraints will not be included in the dump What are the potential impacts on my dump and on my 'mytmpbase'? Is that in contradiction with the sentence 'delivering copy of the cleaned up schema' ? - At the end of this treatment: dropdb: échec de la suppression de la base de données: ERREUR: La base de données « mytmpbase» est actuellement accédée par d'autres utilisateurs As my terminal are still french go on approximatively translating : dropdb: error on deleting database : ERROR: database « mytmpbase» is beeing accessed by other users Indeed, 'mytmpbase' is not removed. May i trust it just like the dump into standard output? Will the restore of the dump be an image of 'mytmpbase'? Forgive me if this too dense, but i think any piece of answer will be usful not only for me but for the whole community, cheers,
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
