Re: backup file system

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