SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:57 AM
| ||||
| ||||
 pg_dump and pg_restore Hello folks, I'm a bit of a novice with Postgres coming from an Oracle background. I'd like to know if there any way to take a pg_dump of one schema and to restore it to another. For example, i've done the following: pg_dump --file=ods_20060330.dmp -s --format=t --schema=avail --verbose Can i take this dump and restore it to another schema (but same owner)? Also, i see the docs say the following: "If you wish to use large objects in your dumped file, it is necessary that you use either the tar (t) or gzip-compressed (c) format, since the plain-text format cannot include large objects. Otherwise, normal plain-text formatted dumps are suitable for most users." What do they mean by large objects? LOBs or objects greater than X megs? Thanks, Shakir      |
 |
« can't get connection during pg_dump
|
Re: Postgresql server does not start!:( -Re: PostgreSQl newbie! »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 10:49 PM.
