posgresql plugin

Classic Servoy
1

Hi!

Is there a posgresql plugin wherein we can interface with commands like pg_dump, etc?

2

Have a look at this:

3

rogel,

You can execute programs with application.executeProgram(), but note that these are executed where the client lives, so for the smart client this is the user machine.

Rob

4

rgansevles:
rogel,

You can execute programs with application.executeProgram(), but note that these are executed where the client lives, so for the smart client this is the user machine.

Rob

This means if I call application.executeProgram(c:\program files\postgresql\bin\pg_dump), the pg_dump that it will execute should be existing in the user machine or else it will fail? How can I call the pg_dump that is in the server?

5

You can execute the application.executeProgram(c:\program files\postgresql\bin\pg_dump) call in an Headless Client, have a look at the Headless Client plugin.

6

ngervasi:
You can execute the application.executeProgram(c:\program files\postgresql\bin\pg_dump) call in an Headless Client, have a look at the Headless Client plugin.

I am at a lost about how to do the headless client.

7

rogel:
I am at a lost about how to do the headless client.

You need to start a headless client using the headless client plugin and with that you can run a method on the server. See this wiki page for sample code.

8

You could also have a look at our UserManager plugin. It allows you to call executeProgram() on the server and capture the results from any client.

9

Joas:

rogel:
I am at a lost about how to do the headless client.

You need to start a headless client using the headless client plugin and with that you can run a method on the server. See this wiki page for sample code.

I was able to get the headless_client_demo solution. Thanks!

10

patrick:
You could also have a look at our UserManager plugin. It allows you to call executeProgram() on the server and capture the results from any client.

Is the licensing different from it2be components?

11

Not sure what you mean. The licensing is explained in our shop (I hope). If you have specific questions, please send a message to sales@servoy-plugins.de

12

patrick:
Not sure what you mean. The licensing is explained in our shop (I hope). If you have specific questions, please send a message to sales@servoy-plugins.de

Thanks!