Tue Jun 2 08:29:15 PDT 2009
- Previous message: [Slony1-general] How to shut-down slony replication
- Next message: [Slony1-general] How to shut-down slony replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Bastian Voigt a écrit : > 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? >> Hi, I did some improvments in return codes in suscripts. Hope it may have solved this problem. Just let me know. These improvments may be found in version 1.1.3 package : http://pgfoundry.org/frs/download.php/2250/slony1-ctl-1.1.3.tar.gz Best regards, - -- Stéphane Schildknecht PostgreSQLFr - http://www.postgresql.fr -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFKJUVLA+REPKWGI0ERAgd6AJ9dE+4nnSRX/g+CNqZZYf+nZRJ7cwCfb8/p 4BwK1AnvTkZPYeK2wAG/f7g= =lLIj -----END PGP SIGNATURE-----
- Previous message: [Slony1-general] How to shut-down slony replication
- Next message: [Slony1-general] How to shut-down slony replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list