Backup of large objects
Backup of large objects
От:
"Srinivasa Rao Chava" <chava45@hotmail.com>
Дата:
Hi, I am novice to postgresql and I have some doubts about it . 1) How to backup Large objects, because pg_dump will not backup the large objects. Can anybody help with some examples. 2)How big is the database that postgresql can support? 3)How to change the size and datatype of a column in a table. 4) Up to which point can the data be restored? Is it upto the point of backup taken or upto the point of system crash? Thanks, chava _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com
Re: Backup of large objects
От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
Srinivasa Rao Chava writes: > 1) How to backup Large objects, because pg_dump will not backup the large > objects. Can anybody help with some examples. Use pg_dump 7.1 or later, it can back up large objects. Look at the man page for the option, it escapes me at the moment. > 2)How big is the database that postgresql can support? unlimited > 3)How to change the size and datatype of a column in a table. You can't do that directly. You need to save your data (with pg_dump, maybe), recreate the changed table, and restore your data. There are numerous examples in the archives. > 4) Up to which point can the data be restored? Is it upto the point of > backup taken or upto the point of system crash? Not sure what you mean here. Certainly you can keep storing data after having made a backup. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter