I've seen in previous posts that recommended practice for database backup is
to run the dump utility twice. Once for schema only and a second time for
data only (I think). Up to know, I've only ever dumped both, and have never
had a problem restoring into older/newer versions of postgres, nor with
restoring into other commercial versions of postgres. This is a testament
of the robustness of pg_dump! Of course, there are always a series of error
messages at the start of each restore when duplicate/unknown template DB
functions are recreated, but these have never prevented the core data from
being properly copied into the database.
Am I setting myself up for disaster with only a single dump as a backup?
pgsql-general by date
|Next:||From: pwbyrne||Date: 2004-09-24 17:23:50|
|Subject: porting a full Ms Sql Server to postgres|
|Previous:||From: Jerry LeVan||Date: 2004-09-24 16:50:16|
|Subject: BiggerSQL-1.3.7 released|