Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 2B69B9FA42F for ; Wed, 13 Dec 2006 13:20:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 58597-09-2 for ; Wed, 13 Dec 2006 13:20:22 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 77CDC9FA178 for ; Wed, 13 Dec 2006 13:20:28 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so228864ugf for ; Wed, 13 Dec 2006 09:20:27 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=luf6moMCCMold79GcE1/ktTJVwsRC+G8S0z3ZCL3+x5SrPlJ2zGtlb+W5vfKzbh7DlgBsrwSfNsRHk/mFKMYvSM+ZYJgWoWV0ws5mDhqSx2ymk8AgzZHYigO6Oju5ryk6N2u+ACF162N2RtaUpO1jiex2axNjOQLFeynbqVe1rA= Received: by 10.66.243.2 with SMTP id q2mr1530451ugh.1166030427373; Wed, 13 Dec 2006 09:20:27 -0800 (PST) Received: by 10.66.216.15 with HTTP; Wed, 13 Dec 2006 09:20:27 -0800 (PST) Message-ID: Date: Wed, 13 Dec 2006 22:50:27 +0530 From: "Rajesh Kumar Mallah" To: "Antonios Katsikadamos" Subject: Re: storage Cc: pgsql-admin@postgresql.org In-Reply-To: <20061213171033.38055.qmail@web59202.mail.re1.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20061213171033.38055.qmail@web59202.mail.re1.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/189 X-Sequence-Number: 23981 On 12/13/06, Antonios Katsikadamos wrote: > Hi all, > > Sorry to bother. I would like to know where postgres stores the created > database and the tables.Can anyone help, which OS or distribution is it? look into the startup script that starts postgresql service. The path is configurable depends on the package mantainer. in redhat it used to be /var/lib/data. if you can connect to the database as superuser you can give the command psql# SHOW data_directory; in recent versions of postgresql. > > > thnx for any help, > > Antonios > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com >