Re: Backup of large objects

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