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

Re: Backup / Restore

From: "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in>
To: "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup / Restore
Date: 2004-06-23 13:27:57
Message-ID: 40D9855D.60804@sancharnet.in (view raw or whole thread)
Thread:
Lists: pgsql-admin
Dear Eduardo ,

>What is the most recommended way to backup a
>PostgreSQL database?
>
>  
>
pg_dump --disable-triggers -U <user_name> -a -d -b -D -Fc -Z 9 -f 
<filername.tar.gz> <dbname>
+
A file system backup could be done but for this you will have to 
shutdown PostgreSQL server
before filesystem backup is done

>And to restore it? 
>  
>
pg_restore --disable-triggers -U <user_name> -d <dbname> 
<backupfilename.tar.gz>
IN case of Filesystem backup just stop PostgreSQL and replace the Dumped 
or Tared file of the
filesystem

Links
http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=x17860%2ehtm
And ofcource the PostgreSQL documentation itself

-- 
Best Regards,
Vishal Kashyap
Director / Lead Software Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com [Soon http://www.saihertz.com]
Yahoo  IM: coeb_college[ a t ]yahoo.com


In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2004-06-23 14:59:43
Subject: Re: Problems with the connection to a Remote Database.
Previous:From: juanmimeDate: 2004-06-23 11:43:25
Subject: Asunto: Re: Problems restoring a DB with oids

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