Re: backup file system

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