If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > PostgreSQL > backup and restore data from database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-06-11, 06:54
shilpa24 shilpa24 is offline
Registered User
 
Join Date: Apr 2011
Posts: 14
backup and restore data from database

hi,
i want to take backup of database(which include large object) created in postgres8.4 and restore it
i m using backup and restore method of pgsqldumb class
but to restore large file (some what 46 mb) i got error
"Exception of type 'System.OutOfMemoryException' was thrown."

how do i restore large object stored in my database
please help
Attached Thumbnails
backup and restore data from database-error.png  
Reply With Quote
  #2 (permalink)  
Old 06-06-11, 07:08
shammat shammat is offline
Registered User
 
Join Date: Nov 2003
Posts: 2,408
I have no idea what "pgsqldumb" class is, it sure isn't a tool provided by Postgres.
'System.OutOfMemoryException' seems to be some exception from your programming langauge (whatever that is), so it's a problem with your class and your program.

I recommend you use the standard backup and restore procedures described in the manual:
PostgreSQL: Documentation: Manuals: PostgreSQL 8.4: Backup and Restore
Reply With Quote
  #3 (permalink)  
Old 06-07-11, 09:12
donose.mihai donose.mihai is offline
Registered User
 
Join Date: Apr 2011
Posts: 19
Quote:
Originally Posted by shilpa24 View Post
hi,
i want to take backup of database(which include large object) created in postgres8.4 and restore it
i m using backup and restore method of pgsqldumb class
but to restore large file (some what 46 mb) i got error
"Exception of type 'System.OutOfMemoryException' was thrown."

how do i restore large object stored in my database
please help

You can use a GUI Tool to backup the database, i'm using DbSchema, you can backup your database, work on it also OFFLINE and after that synchronize it with your database.
See the screenshots for details, hope it helps.
Attached Thumbnails
backup and restore data from database-2011-06-07_160748.png   backup and restore data from database-2011-06-07_161016.png   backup and restore data from database-2011-06-07_161146.png  
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On