> I am newbie with PostgreSQL. I have separate table space for my
> databases, which is located in separate folder, which is different to
> default. I would like to carry out file system level backup. Do I need
> to backup only folder with my table space or all pg folders.
Do you know that a file system level backup is only useful if
a) the postgres instance is stopped
b) your are using WAL archiving and have an appropiate setup to tell PG
about backup starts and ends
You need to backup any file system structure belonging to your PG
"What we nourish flourishes." - "Was wir nähren erblüht."
In response to
pgsql-admin by date
|Next:||From: Suresh Borse||Date: 2008-12-10 10:40:11|
|Subject: Re: Heavy postgres process|
|Previous:||From: Michael Leshchenko||Date: 2008-12-10 07:26:56|
|Subject: File system level backup with more than one cluster folders|