Batch processors

[Pierre-andre]

Hehe

Oki thanks

[ROCLASI]

Glad you saw it! Did not want to correct you again :lol:

:P

[pbakker]

You were both too late...

[axterics]

The only thing you need to know/realize that this 'eats' one client license!

The licence is eaten always? Only when the headless client perform the cronjob or always when the headless client is started (in a production server = always)?

[Jan Aleman]

The only thing you need to know/realize that this 'eats' one client license!

The licence is eaten always? Only when the headless client perform the cronjob or always when the headless client is started (in a production server = always)?

Technically it is running at all times so yes it eats a license. You could overcome this by using external schedulers but unless you have a lot of free time (as in free beer) it's more economical to buy a license.

[IT2Be]

The batchprocessor is fired up when the server starts and as long as it is alive (server down or manual quit via server pages) there is a client.
Which makes sense...

[rogel]

At the moment, the server is working on Windows. But this method have to work with Linux and Mac OS/X.

In first, I wanted to create a stored procedure in PostgreSQL and executed it from servoy. But Postres don't allow to create Procedure, only function. Unfortunately I can't execute a REINDEX, PG_DUMP OR VACUUM command on database in function because "REINDEX cannot be executed inside a transaction block."
http://www.postgresql.org/docs/8.2/inte ... index.html


So I choosed to use cronjob. I created a Startup script :

var jobname = "backup"
var cronTimings = "* 00 22 * * ?"
var startDate = new Date()
var endDate = new Date(startDate.getFullYear()+50,startDate.getMonth(),startDate.getDate())
var args = new Array(directory_postgres,directory_for_backup)

plugins.scheduler.addCronJob(jobname, cronTimings, globals.Backup_DB,startDate,endDate,args)

The method backup:

var directory_postgres = arguments[0]
var directory_for_backup= arguments[1]

//Returns the name of the operating system
var osname = application.getOSName();

if(osname.indexOf("Windows",0)>-1){

var file = plugins.file.convertToJSFile(directory_postgres +"/vacuumdb.exe")
if(file.exists())
application.executeProgram(directory_postgres +"/vacuumdb.exe","-h","localhost","-p","5432","-U","postgres","-d","sopavet")

var file = plugins.file.convertToJSFile(directory_postgres +"/reindexdb.exe")
if(file.exists())
application.executeProgram(directory_postgres +"/reindexdb.exe","-h","localhost","-p","5432","-U","postgres","-d","sopavet"

var file = plugins.file.convertToJSFile(directory_postgres +"/pg_dump.exe")
if(file.exists())
application.executeProgram(directory_postgres +"/pg_dump.exe","-i","-h","localhost","-p","5432","-U","postgres","-F","t","-f","\""directory_for_backup+"/database_save.backup\"","sopavet"

}

I have to add security rules with postgres's user and complete this method for Linux and Mac OS/X.

It's work fine on Windows XP with Postgres 8.1, but I didn't know that batch process use one client license .So I have to find another way to backup my database.

I have the same requirement however i need to pass "where condition"(e.g. usderid='xyz'). I believe I cannot use pgdump. =( I would need to do it the hard way. Can you advice if my steps in doing the backup_db method is correct?
1. acquire lock in the database during the process
2. select all the tables
3. for each table
loadrecords
for each record
create the insert statement
write in <tablename>.sql file
4. release the lock

thanks in advance.

[Jan Aleman]

Have you considered using pgAgent? Sounds like less work to me.

http://www.postgresonline.com/journal/a ... ckups.html

[rogel]

Have you considered using pgAgent? Sounds like less work to me.

http://www.postgresonline.com/journal/a ... ckups.html

Thank you for the suggestion but I am not allowed to use other interface of other software application.