Thread: Backup of large objects

Backup of large objects

From
"Srinivasa Rao Chava"
Date:
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

From
Peter Eisentraut
Date:
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