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