Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id ACBAB2E350F for ; Fri, 25 Jan 2008 15:55:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 66766-01-2 for ; Fri, 25 Jan 2008 15:55:37 -0400 (AST) Received: from web56411.mail.re3.yahoo.com (web56411.mail.re3.yahoo.com [216.252.111.90]) by postgresql.org (Postfix) with SMTP id 169762E022D for ; Fri, 25 Jan 2008 15:55:36 -0400 (AST) Received: (qmail 10820 invoked by uid 60001); 25 Jan 2008 19:55:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=0bWheE9ifYSiE0aryo9PBDX6pCO40taa/UqVyyBfZgE2QS5GlCmkYAMmYF5Ktrv/eVu5o1s6hOb9WdHGnxuuuORitj9vys0iJKCgttFkaG68Ql5TdSQmgKCJFAy0kHBbBzL32vPqovQtUOt6vckJoUEphiSs2zv+4wdmoCnd8H4=; X-YMail-OSG: EsMbDx0VM1nA_gxfN_auD657Hvz5ZD_.VZsJl6OPw.GN79NhzSeJJH7g1DPeSukaDY.9l_0euGPDdfOHqPd0MEweCoMNV0qCVaRJiRoijTEvNZDg9koCpuIFpw2iFKDMph1L1lpp9GtVu8fIKJNQkG7mVw-- Received: from [128.8.215.134] by web56411.mail.re3.yahoo.com via HTTP; Fri, 25 Jan 2008 11:55:35 PST Date: Fri, 25 Jan 2008 11:55:35 -0800 (PST) From: NUWAN LIYANAGE Subject: backup including symbolic links? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1902456281-1201290935=:4964" Content-Transfer-Encoding: 8bit Message-ID: <256355.4964.qm@web56411.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/249 X-Sequence-Number: 28023 --0-1902456281-1201290935=:4964 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, 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). Thank you Nuwan --------------------------------- Looking for last minute shopping deals? Find them fast with Yahoo! Search. --0-1902456281-1201290935=:4964 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello,

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).
Thank you
Nuwan


Looking for last minute shopping deals? Find them fast with Yahoo! Search. --0-1902456281-1201290935=:4964--