Skip site navigation (1) Skip section navigation (2)

Re: Database backup and restore

From: dima <_pppp(at)mail(dot)ru>
To: Colin Stearman <cstearman(at)infofind(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database backup and restore
Date: 2002-11-22 16:07:04
Message-ID: 3DDE5628.50403@mail.ru (view raw or flat)
Thread:
Lists: pgsql-admin
> Am I missing something?   There seems to be no way to dump all databases 
> and then restore them (as you'd have to do on a version change) if the 
> databases contain blobs.
>  
> pg_dump supports dumping of blobs with the -b -Ft switch, but using 
> pg_dumpall with those switches doesn't seem to work.  And in any case, 
> pg_restore seems to be missing its equivalent pg_restoreall.  Other than 
> (painfully) manually pg_dumping and pg_restoring each database, how else 
> could it be done?
>  
> I would search the mailing lists but the site's search engine is down.
i wrote a script in perl which dumps all the DBs but template*
i can mail it to you if you wish


In response to

Responses

pgsql-admin by date

Next:From: Timothy D McKernanDate: 2002-11-22 18:25:35
Subject: ram drive
Previous:From: Colin StearmanDate: 2002-11-22 15:58:45
Subject: Database backup and restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group