Re: [HACKERS] Backup and restore through JDBC

2006-09-30 Thread Markus Schaber
Hi, Tom, Tom Dunstan wrote: >> On a unix box, when you're really crazy, and want to ignore all security >> restrictions, you could even install pg_dump via inetd, and then >> everyone connecting via TCP on the appropriate port gets a dump of the >> database. :-) > > Oh, man, my head just explode

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Andreas Pflug
Tom Lane wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: > >> Then after you recover from your head exploding you start devising some >> sort of sane API ... >> > > That's the hard part. There is no percentage in having a library if > it doesn't do anything significantly different fro

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Then after you recover from your head exploding you start devising some > sort of sane API ... That's the hard part. There is no percentage in having a library if it doesn't do anything significantly different from what you could accomplish via

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Tom Dunstan
Markus Schaber wrote: Marlon Petry wrote: But I would need to have installed pg_dump and pg_restore in machine client? Without having installed pg_dump and pg_restore,how I could make pg_dump and pg_restore should be runnable (possible with a small shell / bash wrapper script) without any "ins

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Marlon Petry
Marlon Petry wrote:>>> > You can't. pg_dump in particular embodies an enormous amount of > > knowledge that simply does not exist elsewhere. There is no> > dump/restore API, and there is nothing you can hook up to using JNI,> > AFAIK.> Recently, there was the proposal to extract

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Andrew Dunstan
Marlon Petry wrote:> > You can't. pg_dump in particular embodies an enormous amount of > knowledge that simply does not exist elsewhere. There is no > dump/restore API, and there is nothing you can hook up to using JNI, > AFAIK. Recently, there was the proposal to extract tha

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Marlon Petry
> Marlon Petry wrote: >> pg_dump and pg_restore do not need to run on the server machine.>> Why not>> just run them where you want the dump stored?>> But I would need to have installed pg_dump and pg_restore in machine >> client?>> Without having installed pg_dump and pg_res

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Markus Schaber
Hi, Marlon, Marlon Petry wrote: > But I would need to have installed pg_dump and pg_restore in machine > client? > Without having installed pg_dump and pg_restore,how I could make pg_dump and pg_restore should be runnable (possible with a small shell / bash wrapper script) without any "installat

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Andreas Pflug
Andrew Dunstan wrote: > Marlon Petry wrote: >> >> >> pg_dump and pg_restore do not need to run on the server machine. >> Why not >> just run them where you want the dump stored? >> >> >> >> >> But I would need to have installed pg_dump and pg_restore in machine >> client? >> Without hav

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Andrew Dunstan
Marlon Petry wrote: pg_dump and pg_restore do not need to run on the server machine. Why not just run them where you want the dump stored? But I would need to have installed pg_dump and pg_restore in machine client? Without having installed pg_dump and pg_restore,how I could m

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Marlon Petry
>> The idea is to make one pg_dump of the server and to keep in the > machine of client.> And to restore this pg_dump when it will be necessary through the> machine of the client.> Perhaps I will have that to use some store procedure in the server, I> do not know >>pg_dump and pg_restore do not nee

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Andrew Dunstan
Marlon Petry wrote: The idea is to make one pg_dump of the server and to keep in the machine of client. And to restore this pg_dump when it will be necessary through the machine of the client. Perhaps I will have that to use some store procedure in the server, I do not know pg_dump and p

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Marlon Petry
The idea is to make one pg_dump of the server and to keep in the machine of client.And to restore this pg_dump when it will be necessary through the machine of the client.Perhaps I will have that to use some store procedure in the server, I do not know regardsMarlon2006/9/29, Albe Laurenz < [EMAI

Re: [HACKERS] Backup and restore through JDBC

2006-09-29 Thread Albe Laurenz
Marlon Petry wrote: > I am trying to develop, a API to carry through backup and > restore through JDBC. > I think that the best form is to use JNI. > Some Suggestion? Do you mean 'backup' or 'export/dump'? If you mean 'export', do you need anything besides SQL? If you mean 'backup', how do you

Re: [HACKERS] backup and restore

2000-10-14 Thread Vadim Mikheev
>> No, 2nd. WAL reflects layout of tuples in data files, so I don't see >> how pg_dump output could be used. >> I'll really appreciate if someone will help with this issue ... after >> alpha testing will start next week. > > Where is this code? How can we get it? Code is in CVS. Philip Warner al

RE: [HACKERS] backup and restore

2000-10-13 Thread Martin A. Marques
On Thu, 12 Oct 2000, Mikheev, Vadim wrote: > > > Could this be added? I am willing to help with the coding. > > > > This is what Version 7.1 WAL is all about. > > There might be some help wanted in one of the possible backup methods: > > 1. a pg_dumpall restore, and a subsequent restore of

RE: [HACKERS] backup and restore

2000-10-12 Thread Mikheev, Vadim
> > Could this be added? I am willing to help with the coding. > > This is what Version 7.1 WAL is all about. > There might be some help wanted in one of the possible backup methods: > 1. a pg_dumpall restore, and a subsequent restore of logs > 2. a restore of a "physical backup of d

Re: [HACKERS] backup and restore

2000-10-09 Thread Lamar Owen
Bruce Momjian wrote: > Lamar Owen Wrote: > > And we thought 7.0 had alot of new features relative to 6.5. > I think the true feature-killer release was 6.5. Well, this is true. I skipped the whole 6.4 series for a reason :-). I just _knew_ 6.5 was going to be _it_... (in actuality, it's b

Re: [HACKERS] backup and restore

2000-10-09 Thread Bruce Momjian
> On Sun, 08 Oct 2000, Bruce Momjian wrote: > > This will be in 7.1 as WAL (write-ahead log). > > What does this exactly mean? Will this WAL be an equivalent of the logical > log of Informix? Where will they be kept? In the database, as a file, or as > either? > Looks pretty good. All that is n

Re: [HACKERS] backup and restore

2000-10-09 Thread Bruce Momjian
> "Martin A. Marques" wrote: > > > > On Sun, 08 Oct 2000, Bruce Momjian wrote: > > > This will be in 7.1 as WAL (write-ahead log). > > > > What does this exactly mean? Will this WAL be an equivalent of the logical > > log of Informix? Where will they be kept? In the database, as a file, or as >

Re: [HACKERS] backup and restore

2000-10-09 Thread Lamar Owen
"Martin A. Marques" wrote: > > On Sun, 08 Oct 2000, Bruce Momjian wrote: > > This will be in 7.1 as WAL (write-ahead log). > > What does this exactly mean? Will this WAL be an equivalent of the logical > log of Informix? Where will they be kept? In the database, as a file, or as > either? > Look

Re: [HACKERS] backup and restore

2000-10-09 Thread Martin A. Marques
On Sun, 08 Oct 2000, Bruce Momjian wrote: > This will be in 7.1 as WAL (write-ahead log). What does this exactly mean? Will this WAL be an equivalent of the logical log of Informix? Where will they be kept? In the database, as a file, or as either? Looks pretty good. All that is needed after th

Re: [HACKERS] backup and restore

2000-10-07 Thread Bruce Momjian
This will be in 7.1 as WAL (write-ahead log). > On Mon, 02 Oct 2000, Hannu Krosing wrote: > > "Martin A. Marques" wrote: > > > Hi, > > > > > > I would like to know if postgres comes with some kind of backup > > > application? I mean something that would do database backup and restore, > > > somet

Re: [HACKERS] backup and restore

2000-10-03 Thread Martin A. Marques
On Mon, 02 Oct 2000, Hannu Krosing wrote: > "Martin A. Marques" wrote: > > Hi, > > > > I would like to know if postgres comes with some kind of backup > > application? I mean something that would do database backup and restore, > > something like informix's ontape and logical logs. >> > Take a loo

Re: [HACKERS] backup and restore

2000-10-02 Thread Hannu Krosing
"Martin A. Marques" wrote: > > Hi, > > I would like to know if postgres comes with some kind of backup application? > I mean something that would do database backup and restore, something like > informix's ontape and logical logs. Take a look at pg_dump and pg_dumpall - Hannu