auch, postgresql

Leonid Flaks flaks at bnl.gov
Tue Apr 11 22:36:48 UTC 2006


> On Tue, 2006-04-11 at 22:41 +0200, Marcel Janssen wrote:
>   
>> On Tuesday 11 April 2006 22:07, Craig White wrote:
>>     
>>> you do
>>> backup postgresql files using pg_dump right?
>>>       
>> You're absolutely right that I should have, but in this case I just started to 
>> use postgresql last week as a testcase (not production yet). I haven't set up 
>> backups for this yet.
>> It's not a big disaster when I loose the data, but would be nice if I could 
>> save it.
>>     
> ----
> I did much the same thing - I think it was upgrade from FC-2 to FC-4 and
> Postgres 7.4.x to 8.0.x and I chalked it up to a learning curve but I
> did have a pg_dump to go back to, it did teach me a lesson though.
>
> I have a cron job that regularly dumps my postgresql db's now.
>
> Craig
>   
I read somewhere in documentation, that pg_dump and pg_dumpall both 
understand old format (to a certain point). That should give us an 
option of making a backup after upgrade. I did not try it myself - just 
a thought. In my case I only had to recreate user account manually - 
everything else went smoothly per notes.

Leon

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/fedora-list/attachments/20060411/dc04101b/attachment-0001.htm>


More information about the fedora-list mailing list