X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3FAB6D1B4EC for ; Fri, 19 Sep 2003 05:33:35 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 56904-07 for ; Fri, 19 Sep 2003 02:33:05 -0300 (ADT) Received: from smtp100.mail.sc5.yahoo.com (smtp100.mail.sc5.yahoo.com [216.136.174.138]) by svr1.postgresql.org (Postfix) with SMTP id 62AFFD1B506 for ; Fri, 19 Sep 2003 02:33:03 -0300 (ADT) Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 19 Sep 2003 05:33:02 -0000 Message-ID: <028101c37e70$3896a6e0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: Datafiles for Databases Date: Fri, 19 Sep 2003 11:08:09 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_027E_01C37E9E.4F138E00" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50 X-Spam-Level: X-Archive-Number: 200309/180 X-Sequence-Number: 15158 This is a multi-part message in MIME format. ------=_NextPart_000_027E_01C37E9E.4F138E00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, I was looking for a structure like oracle or ms Sql server in Postgres. Wha= t I have expected is individual datafiles for individual databases. But i c= ant fine such items in the /usr/local/pgsql/data directory. Will the postgres create individual data file for databases? How to get the datafile path of a database? Please shed light. Regards Kumar ------=_NextPart_000_027E_01C37E9E.4F138E00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Friends,
 
I was looking for a structure like oracle or ms=20 Sql server in Postgres. What I have expected is individual datafiles f= or=20 individual databases. But i cant fine such items in the /usr/local/pgsql/da= ta=20 directory.
 
Will the postgres create individual data file for=20 databases?
 
How to get the datafile path of a database?
 
Please shed light.
 
Regards
Kumar

------=_NextPart_000_027E_01C37E9E.4F138E00--