Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 03F5A9FB8A7 for ; Tue, 24 Jul 2007 21:55:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 33480-04 for ; Tue, 24 Jul 2007 21:54:45 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by postgresql.org (Postfix) with ESMTP id A95B09FB822 for ; Tue, 24 Jul 2007 21:55:01 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id k40so36300wah for ; Tue, 24 Jul 2007 17:54:59 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=m43LfjIWulvLAq68AnrUFNjECJlHKa+2iG4cx9wq7pfiDuM5S+coOYRpPeYuCQykpjEoT3mSoofQDCsnvcqgzUaaA1XiiyH3Gz3i6UN1HPVu+xhExLKi1RgSHgKdWkr130yDWcm/RHSDloLO8Hxy/xyCujP40Wt/Ce/iUU7rBI4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=oUcKfw9yrFgggB/OMAcP4U8eSgugK0fIVVp2jqT7Y8zWX1UqE3pOhhIgBinePopbH2BNO0I57QqiSDYx8DzCpoXONywa/RCX43g8TZzQ5+Ju6Mgbq3U8lW0VhLP/vAT7kKjw5BQH5Jcge4IpIp2vhXJmNVUxrTgELbEOYPPosG8= Received: by 10.114.60.19 with SMTP id i19mr71010waa.1185324899663; Tue, 24 Jul 2007 17:54:59 -0700 (PDT) Received: by 10.115.55.4 with HTTP; Tue, 24 Jul 2007 17:54:54 -0700 (PDT) Message-ID: <8398dc6d0707241754p72959329k3e2f8ef7a86e5450@mail.gmail.com> Date: Tue, 24 Jul 2007 21:54:54 -0300 From: "Alejandro D. Burne" To: pgsql-admin@postgresql.org Subject: Re: Set up a database without backup In-Reply-To: <14086.83.35.111.4.1185277735.squirrel@webmail.g-sistemas.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <14086.83.35.111.4.1185277735.squirrel@webmail.g-sistemas.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/265 X-Sequence-Number: 26246 2007/7/24, tech@g-sistemas.com : > Hello everybody. > > I'm using PostgreSQL on Windows XP. > > I had to format de harddisc, and I'm lost databases and tablespaces > configuration (1 database and 1 tablespace), I have a copy of directory > where was the tablespaces ( but I haven't a backup made by pgAdmin ). > > What do I for set up my database and tablespace ? > > It could be: creating a new database and tablespace, and after copy files > of older tablespace to newer tablespace? > > Thanks In Advance > > With Regards > > Juan. > If u have the dirs where the db where initialized you can reinstall the "same" version of postgres on your windows machine and then replace the data dir with your files backup. Alejandro