Re: auch, postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux