Re: backup file system

Francisco :

Would you tell me what problem did you face when you try to restore the
database from backup filesystem?

Fushan

-----Original Message-----
From: Francisco Solari [mailto:fsolari(at)prosalud(dot)com(dot)ar]
Sent: Wednesday, October 31, 2001 5:41 AM
To: Leong, Fushan
Cc: 'pgsql-admin(at)postgresql(dot)org'
Subject: Re: [ADMIN] 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