Thu Mar 23 05:20:23 PST 2006
- Previous message: [Slony1-general] How to Syn two postgre database data on windows server 2003?
- Next message: [Slony1-general] How to Syn two postgre database data on windows server 2003?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi. Sorry very late reaction. Usage in Windows is the same as the thing of *nix. However, It is necessary to get to know some Windows rules. 1.) setting of eventlog C:\Program Files\PostgreSQL\8.1\lib>regsvr32 slevent.dll 2.) Registration of service C:\Program Files\PostgreSQL\8.1\bin>slon --help 2006-03-23 21:56:00 JST CONFIG main: slon version 1.2.0 starting up usage: slon [options] clustername conninfo Options: -d <debuglevel> verbosity of logging (1..4) -s <milliseconds> SYNC check interval (default 10000) -t <milliseconds> SYNC interval timeout (default 60000) -g <num> maximum SYNC group size (default 6) -c <num> how often to vacuum in cleanup cycles -p <filename> slon pid file -f <filename> slon configuration file -a <directory> directory to store SYNC archive files -q <num> Terminate when this node reaches # of SYNCs -r <num> # of syncs for -q option -l <interval> this node should lag providers by this interval Windows service registration: slon -regservice [servicename] slon -unregservice [servicename] slon -listengines [servicename] slon -addengine [servicename] <configfile> slon -delengine [servicename] <configfile> ex.) C:\Program Files\PostgreSQL\8.1\bin>slon -regservice Service registered. Before you can run Slony, you must also register an engine! WARNING! Service is registered to run as Local System. You are encouraged to change this to a low privilege account to increase system security. C:\Program Files\PostgreSQL\8.1\bin>slon -addengine slon1.conf Engine added. NOTE! You need to restart the Slony service before this takes effect. C:\Program Files\PostgreSQL\8.1\bin>slon -listengines 1 engine(s) registered for service 'Slony-I' Engine 1: C:\Program Files\PostgreSQL\8.1\bin\slon1.conf 3.) slonik Please use not the here document of sh script but the script described directly. ex.) C:\Program Files\PostgreSQL\8.1\bin>slonik Slonscript.txt In pgAdmin, operation of the object is possible by GUI. :-) Regards, Hiroshi Saito ----- Original Message ----- From: "calendarw" Hi, I haven't see my "C:\Program Files\PostgreSQL\8.0\bin" has file "slon", so how to install it on windows? thanks calendarw On 3/21/06, Jim C. Nasby > > On Sat, Mar 18, 2006 at 05:37:26PM +0800, calendarw wrote: > > Hi, > > I am a beginner of postgresql, and I want to let two postgre database > > table become same, so how to do it? > > I have seen the Help but I still not understand how to make it work, > and I > > see it has a configure file, what is needed to add in? > > Have you read the documentation that comes with Slony? (BTW, any reason > that's not online somewhere??) Have you g one through the example in > those docs? > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby at pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 >
- Previous message: [Slony1-general] How to Syn two postgre database data on windows server 2003?
- Next message: [Slony1-general] How to Syn two postgre database data on windows server 2003?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list