sign in | join about | help | sitemap
Connecting Tech Pros Worldwide
zuhans@iname.com's Avatar

why no answer? [Fwd: backup and restore just with use ofjdbc?]


Question posted by: zuhans@iname.com (Guest) on November 23rd, 2005 01:10 AM


-------- Original-Nachricht --------
Betreff: [GENERAL] backup and restore just with use of jdbc?
Datum: Sun, 13 Jun 2004 10:23:53 +0200
Von: Join Bytes! <zuhans@iname.com>
An: Join Bytes!



hello,

is there a way to do backup and restore just with the use of jdbc?

greetings
hans

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org



12 Answers Posted
Kris Jurka's Avatar
Guest - n/a Posts
#2: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]


[color=blue]
> is there a way to do backup and restore just with the use of jdbc?
>[/color]

No.

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to Join Bytes!)

Kris Jurka's Avatar
Guest - n/a Posts
#3: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]


[color=blue]
> is there a way to do backup and restore just with the use of jdbc?
>[/color]

No.

Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to Join Bytes!)

Chris Browne's Avatar
Guest - n/a Posts
#4: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

Join Bytes! ("zuhans@iname.com") writes:[color=blue]
> is there a way to do backup and restore just with the use of jdbc?[/color]

You could presumably reimplement pg_dump in Java; that seems redundant
in view of the fact that pg_dump is already implemented in C.
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/spreadsheets.html
"Very funny, Scotty. Now beam down my clothes."
Chris Browne's Avatar
Guest - n/a Posts
#5: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

Join Bytes! ("zuhans@iname.com") writes:[color=blue]
> is there a way to do backup and restore just with the use of jdbc?[/color]

You could presumably reimplement pg_dump in Java; that seems redundant
in view of the fact that pg_dump is already implemented in C.
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/spreadsheets.html
"Very funny, Scotty. Now beam down my clothes."
zuhans@iname.com's Avatar
zuhans@iname.com November 23rd, 2005 01:11 AM
Guest - n/a Posts
#6: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

hello,

thank you for your short - but informative - answers!
i don't know why this very very important thing isn't implemented by the
jdbc (and other...) driver. it shouldn't only be managable by those
sitting in front of the machine but also via my program to handle some
critical situation in the way i want it to be done (and if i hoste my
webapp somewhere in another continent, i won't be able to sit in front
of the servers console-screen).

to recode pg_dump is far off my time and (maybe) skills. why isn't it
implemented for easier access?

greetings
hans



Chris Browne schrieb:
[color=blue]
>zuhans@iname.com ("zuhans@iname.com") writes:
>
>[color=green]
>>is there a way to do backup and restore just with the use of jdbc?
>>
>>[/color]
>
>You could presumably reimplement pg_dump in Java; that seems redundant
>in view of the fact that pg_dump is already implemented in C.
>
>[/color]

zuhans@iname.com's Avatar
zuhans@iname.com November 23rd, 2005 01:11 AM
Guest - n/a Posts
#7: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

hello,

thank you for your short - but informative - answers!
i don't know why this very very important thing isn't implemented by the
jdbc (and other...) driver. it shouldn't only be managable by those
sitting in front of the machine but also via my program to handle some
critical situation in the way i want it to be done (and if i hoste my
webapp somewhere in another continent, i won't be able to sit in front
of the servers console-screen).

to recode pg_dump is far off my time and (maybe) skills. why isn't it
implemented for easier access?

greetings
hans



Chris Browne schrieb:
[color=blue]
>zuhans@iname.com ("zuhans@iname.com") writes:
>
>[color=green]
>>is there a way to do backup and restore just with the use of jdbc?
>>
>>[/color]
>
>You could presumably reimplement pg_dump in Java; that seems redundant
>in view of the fact that pg_dump is already implemented in C.
>
>[/color]

Scott Marlowe's Avatar
Guest - n/a Posts
#8: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

On Wed, 2004-06-16 at 23:28, Join Bytes! wrote:[color=blue]
> hello,
>
> thank you for your short - but informative - answers!
> i don't know why this very very important thing isn't implemented by
> the jdbc (and other...) driver. it shouldn't only be managable by
> those sitting in front of the machine but also via my program to
> handle some critical situation in the way i want it to be done (and if
> i hoste my webapp somewhere in another continent, i won't be able to
> sit in front of the servers console-screen).
>
> to recode pg_dump is far off my time and (maybe) skills. why isn't it
> implemented for easier access?[/color]

Well, pg_dump doesn't have to be run on the server, it can be run on a
client halfway around the world from the server and work just fine.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Scott Marlowe's Avatar
Guest - n/a Posts
#9: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

On Wed, 2004-06-16 at 23:28, Join Bytes! wrote:[color=blue]
> hello,
>
> thank you for your short - but informative - answers!
> i don't know why this very very important thing isn't implemented by
> the jdbc (and other...) driver. it shouldn't only be managable by
> those sitting in front of the machine but also via my program to
> handle some critical situation in the way i want it to be done (and if
> i hoste my webapp somewhere in another continent, i won't be able to
> sit in front of the servers console-screen).
>
> to recode pg_dump is far off my time and (maybe) skills. why isn't it
> implemented for easier access?[/color]

Well, pg_dump doesn't have to be run on the server, it can be run on a
client halfway around the world from the server and work just fine.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

zuhans@iname.com's Avatar
zuhans@iname.com November 23rd, 2005 01:11 AM
Guest - n/a Posts
#10: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

hello scott,

this is good news (for me ;-) )!
what kind of client should be available (if i search for a good hoster
in near future)?

greetings
hans



Scott Marlowe schrieb:
[color=blue]
>On Wed, 2004-06-16 at 23:28, Join Bytes! wrote:
>
>[color=green]
>>hello,
>>
>>thank you for your short - but informative - answers!
>>i don't know why this very very important thing isn't implemented by
>>the jdbc (and other...) driver. it shouldn't only be managable by
>>those sitting in front of the machine but also via my program to
>>handle some critical situation in the way i want it to be done (and if
>>i hoste my webapp somewhere in another continent, i won't be able to
>>sit in front of the servers console-screen).
>>
>>to recode pg_dump is far off my time and (maybe) skills. why isn't it
>>implemented for easier access?
>>
>>[/color]
>
>Well, pg_dump doesn't have to be run on the server, it can be run on a
>client halfway around the world from the server and work just fine.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>
>[/color]

zuhans@iname.com's Avatar
zuhans@iname.com November 23rd, 2005 01:11 AM
Guest - n/a Posts
#11: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

hello scott,

this is good news (for me ;-) )!
what kind of client should be available (if i search for a good hoster
in near future)?

greetings
hans



Scott Marlowe schrieb:
[color=blue]
>On Wed, 2004-06-16 at 23:28, Join Bytes! wrote:
>
>[color=green]
>>hello,
>>
>>thank you for your short - but informative - answers!
>>i don't know why this very very important thing isn't implemented by
>>the jdbc (and other...) driver. it shouldn't only be managable by
>>those sitting in front of the machine but also via my program to
>>handle some critical situation in the way i want it to be done (and if
>>i hoste my webapp somewhere in another continent, i won't be able to
>>sit in front of the servers console-screen).
>>
>>to recode pg_dump is far off my time and (maybe) skills. why isn't it
>>implemented for easier access?
>>
>>[/color]
>
>Well, pg_dump doesn't have to be run on the server, it can be run on a
>client halfway around the world from the server and work just fine.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
>
>[/color]

Mark Harrison's Avatar
Guest - n/a Posts
#12: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

Join Bytes! wrote:[color=blue]
> hello scott,
>
> this is good news (for me ;-) )!
> what kind of client should be available (if i search for a good hoster
> in near future)?
>
> greetings
> hans[/color]

Here are the programs installed by postgres. If psql is installed
by your hoster, the others are probably available as well.

~/pg/bin$ ls
clusterdb dropdb initdb pg_controldata pg_encoding postgres
createdb droplang initlocation pg_ctl pg_id postmaster
createlang dropuser ipcclean pg_dump pg_resetxlog psql
createuser ecpg pg_config pg_dumpall pg_restore vacuumdb

HTH!
Mark

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Mark Harrison's Avatar
Guest - n/a Posts
#13: Re: why no answer? [Fwd: backup and restore just with use ofjdbc?]

Join Bytes! wrote:[color=blue]
> hello scott,
>
> this is good news (for me ;-) )!
> what kind of client should be available (if i search for a good hoster
> in near future)?
>
> greetings
> hans[/color]

Here are the programs installed by postgres. If psql is installed
by your hoster, the others are probably available as well.

~/pg/bin$ ls
clusterdb dropdb initdb pg_controldata pg_encoding postgres
createdb droplang initlocation pg_ctl pg_id postmaster
createlang dropuser ipcclean pg_dump pg_resetxlog psql
createuser ecpg pg_config pg_dumpall pg_restore vacuumdb

HTH!
Mark

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

 
Not the answer you were looking for? Post your question . . .
196,942 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 196,942 network members.
Post your question now . . .
It's fast and it's free

Popular Articles

Top Community Contributors