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: =E9chec lors de la cr=E9ation de la base de donn=E9es : ERREUR:
   La base de donn=E9es =AB mytmpbase=BB existe d=E9j=E0
   Sorry but my terminal are french. But i guess the translanlation woulk
   look like :
   createdb: error on creating database : ERROR:  database =AB mytmpbase=BB
   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: =E9chec de la suppression de la base de donn=E9es: ERREUR:  La
   base de donn=E9es =AB mytmpbase=BB est actuellement acc=E9d=E9e par d'au=
tres
   utilisateurs
   As my terminal are still french go on approximatively translating :
   dropdb: error on deleting database : ERROR: database  =AB mytmpbase=BB 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,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080313/=
94c6b23c/attachment-0001.htm