I don't understand why it's not possible to backup all the database files while the
db is down. I'm working for years with Oracle and doing a tape backup from all
necessary files is one way to restore the database.
Egon
Francisco Solari wrote:
> I had the same problem, but backing up the filesystem isn't the solution. I did
> it and when I tried to restore the database was impossible. If anyone knows how
> to solve this problem please let me know
>
> "Leong, Fushan" wrote:
>
> > Hi :
> >
> > I am very new in postgres and hope someone can give me some suggestions
> >
> > I am working on a shell script to backup my postgres database. Compared
> > with pg_dump and pg_dumpall, I would
> > like to backup the file system instead of dump the database because I can
> > shutdown the database server in
> > midnight for a few hours. I also can sure I will have a stable backup. ( No
> > user is doing anything at the same time )
> >
> > I search internet but did not find anyone mention this method. Did I miss
> > anything? I plan to backup all
> > files under data directory. Is that enough?
> >
> > thanks
> > Fushan
> > DBA
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html
>
> ------------------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster