Mon May 4 04:34:53 PDT 2009
- Previous message: [Slony1-general] Another problem with slony1-ctl
- Next message: [Slony1-general] Stability of Slony 2.01
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I did some further investigation on this one, and this is what I found out: It seems that the scripts (11_create_addobj and 12_exec_addobj) generate bad return values, even though they executed successfully. When I leave out the "or die" in my perl script, both scripts are executed fine. Any explanation for this behaviour? Cheers Bastian Am 04.05.2009 um 11:05 schrieb Bastian Voigt: > Hi *, > > in my database I have one very large table wich is partioned using > PG's inheritance feature. To maintain this table, I have a cron > script that runs every month, creates a new table and modifies the > insert trigger. Now that my DB is being upgraded to a slony master- > slave setup I need to modify this monthly script, so that it adds > the newly created table to the repliation set. > > I tried to do this from perl: > > system("/opt/slony1-ctl/slony-ctl/outils/11_create_addobj.sh -c > vesseltracker -s 1 -f $filename") or die $!; > exec("/opt/slony1-ctl/slony-ctl/outils/12_exec_addobj.sh -c > vesseltracker -s 1") or die $!; > > The first script works, the second one gives me an error: > > "Inappropriate ioctl for device at /scripts/trackingtables.pl line > 124" > > Any idea where that might come from? > > > > Kind regards > Bastian > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general >
- Previous message: [Slony1-general] Another problem with slony1-ctl
- Next message: [Slony1-general] Stability of Slony 2.01
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list