I have a 450gb production database, and was trying to create a development database using a bkp.
I was following the instructions on postgres documentation, and came across the paragraph that says...
" If you are using tablespaces that do not reside underneath this (data) directory, be careful to include them as well (and be sure that your backup dump archives symbolic links as links, otherwise the restore will mess up your tablespaces)."
I have a seperate pg_tablespaces folder under E:\ drive since there wasn't enough space in my C:\ drive to put them.
My db is 8.2 and is running on windows 2003.
Can anyone tell me how to backup my database (including the symbolic links as links).
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
pgsql-admin by date
|Next:||From: Adam Talaat||Date: 2008-01-25 20:05:38|
|Subject: Data file compatibility between 32-bit and 64-bit|
|Previous:||From: Tino Schwarze||Date: 2008-01-25 19:23:42|
|Subject: Re: Recovering a database in danger of transaction wrap-around|