Re: [PERFORM] Regarding pg_dump utility

2006-06-09 Thread Paul S
I think that having an API for backup functionality would definitely be useful. Just my 2 cents... Paul On 6/8/06, Christopher Kings-Lynne [EMAIL PROTECTED] wrote: Personally I think it would be neat.For example the admin-tool guys would be able to get a dump without invoking an external

[PERFORM] Regarding pg_dump utility

2006-06-08 Thread soni de
Hello, We have to take a backup of database and we know the pg_dump utility of postgresql. But may I know, is there any API for this pg_dump utility so that we can call it from the C program? Or only script support is possible for this. I think script support is bit risky because if anything

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Tom Lane
soni de [EMAIL PROTECTED] writes: We have to take a backup of database and we know the pg_dump utility of postgresql. But may I know, is there any API for this pg_dump utility so that we can call it from the C program? Or only script support is possible for this. There's always system(3)

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Jim C. Nasby
On Thu, Jun 08, 2006 at 11:39:48AM +0530, soni de wrote: We have to take a backup of database and we know the pg_dump utility of postgresql. But may I know, is there any API for this pg_dump utility so that we can call it from the C program? Or only script support is possible for this. It

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Geoffrey
Tom Lane wrote: soni de [EMAIL PROTECTED] writes: We have to take a backup of database and we know the pg_dump utility of postgresql. But may I know, is there any API for this pg_dump utility so that we can call it from the C program? Or only script support is possible for this. There's

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Alvaro Herrera
Jim C. Nasby wrote: On Thu, Jun 08, 2006 at 11:39:48AM +0530, soni de wrote: We have to take a backup of database and we know the pg_dump utility of postgresql. But may I know, is there any API for this pg_dump utility so that we can call it from the C program? Or only script support

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Andreas Pflug
Alvaro Herrera wrote: Personally I think it would be neat. For example the admin-tool guys would be able to get a dump without invoking an external program. Second it would really be independent of core releases (other than being tied to the output format.) pg_dump would be just a simple

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Jim C. Nasby
On Thu, Jun 08, 2006 at 06:33:28PM +0200, Andreas Pflug wrote: Alvaro Herrera wrote: Personally I think it would be neat. For example the admin-tool guys would be able to get a dump without invoking an external program. Second it would really be independent of core releases (other than

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Alvaro Herrera
Jim C. Nasby wrote: On Thu, Jun 08, 2006 at 06:33:28PM +0200, Andreas Pflug wrote: Alvaro Herrera wrote: Personally I think it would be neat. For example the admin-tool guys would be able to get a dump without invoking an external program. Second it would really be independent

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Christopher Kings-Lynne
It probably wouldn't be terribly difficult to put the guts of pg_dump into a library that you could interface with via C. I'm not sure if the community would accept such a patch; though, I seem to recall other people asking for this on occasion. I think script support is bit risky because if

Re: [PERFORM] Regarding pg_dump utility

2006-06-08 Thread Christopher Kings-Lynne
Personally I think it would be neat. For example the admin-tool guys would be able to get a dump without invoking an external program. Second it would really be independent of core releases (other than being tied to the output format.) pg_dump would be just a simple caller of such a library,