Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 743712E0045 for ; Fri, 25 Jan 2008 22:23:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 89850-10 for ; Fri, 25 Jan 2008 22:22:51 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 802752E0040 for ; Fri, 25 Jan 2008 22:22:59 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so1529963waf.5 for ; Fri, 25 Jan 2008 18:22:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=CWldxrMK7up4ae9UeXu2J4DZ78WNVw2g+hD2be9svoo=; b=PxrHtUOrxGZwAZxwYST1qsv/2xdqZJy/ELr72WpsnvnjOFzSPEmE0GpJMWDPlrY/lsD+Oi1G8F75OLkyuYaIC7YrxZ3esL2K65njtrAavn3OmyNaGW9A9OB6e/DlfNs6s8rtCgLGEjPEEscphfyVXH+B9Ezmv44Q4+aDfBA+fSE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Q+7IacH6BpS9o5di7lMBm0qf1G4wGsjXGijG9vkW8CN+nIl6h+03Qtk7oL7yqgFXiBJOFy+bRb+szckWw4RG8kP3iHavE2Of7/w5nv+bhhneAgjySKmDlshU4TBCLteya3dd+Q2+NvvjDqAMXAsuk99Qdc51hDSZHKjUUd4YoVQ= Received: by 10.114.209.1 with SMTP id h1mr1106630wag.115.1201314178085; Fri, 25 Jan 2008 18:22:58 -0800 (PST) Received: by 10.114.133.5 with HTTP; Fri, 25 Jan 2008 18:22:58 -0800 (PST) Message-ID: Date: Fri, 25 Jan 2008 20:22:58 -0600 From: "Scott Marlowe" To: "NUWAN LIYANAGE" Subject: Re: backup including symbolic links? Cc: pgsql-admin@postgresql.org In-Reply-To: <256355.4964.qm@web56411.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <256355.4964.qm@web56411.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/256 X-Sequence-Number: 28030 On Jan 25, 2008 1:55 PM, NUWAN LIYANAGE wrote: > 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). A standard pg_dumpall --globals will dump the create tablespace statement, which you can edit as needed for your new machine. A plain pg_dump of the database will dump out the tables with tablespace statements. A pg_dumpall of the whole database cluster can also be used to do this.