From sgnerd@yahoo.com.sg Fri Sep  19 05:33:35 2003
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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	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 <pgsql-sql@postgresql.org>; 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" <sgnerd@yahoo.com.sg>
From: "Kumar" <sgnerd@yahoo.com.sg>
To: "psql" <pgsql-sql@postgresql.org>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #0000ff; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<DIV><FONT size=3D2>Dear Friends,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I was looking for a structure like oracle or ms=20
Sql&nbsp;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.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Will the postgres create individual data file for=20
databases?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>How to get the datafile path of a database?</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Please shed light.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Kumar</FONT></DIV>
<P></P></BODY></HTML>

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




From bhuvan@symonds.net Fri Sep  19 07:46:19 2003
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 A8EFDD1B50E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Sep 2003 07:46:19 +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 79943-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Sep 2003 04:45:50 -0300 (ADT)
Received: from Gateway.bksys.co.in (unknown [61.3.64.17])
	by svr1.postgresql.org (Postfix) with ESMTP id E8A5FD1B507
	for <pgsql-sql@postgresql.org>; Fri, 19 Sep 2003 04:45:25 -0300 (ADT)
Received: from bksys.co.in (mail.bksys.co.in [192.168.1.1])
	by Gateway.bksys.co.in (8.11.6/8.11.6) with ESMTP id h8J7j9D01428;
	Fri, 19 Sep 2003 13:15:14 +0530
Received: from Bhuvan.bksys.co.in (Bhuvan.bksys.co.in [192.168.1.71])
	by bksys.co.in (8.11.6/8.8.5) with ESMTP id h8J7j8B14089;
	Fri, 19 Sep 2003 13:15:08 +0530
Date: Fri, 19 Sep 2003 13:23:39 +0530 (IST)
From: "A.Bhuvaneswaran" <bhuvan@symonds.net>
X-X-Sender: bhuvan@Bhuvan.bksys.co.in
To: Kumar <sgnerd@yahoo.com.sg>
Cc: psql <pgsql-sql@postgresql.org>
Subject: Re: Datafiles for Databases
In-Reply-To: <028101c37e70$3896a6e0$7502a8c0@hdsc.com>
Message-ID: <Pine.LNX.4.44.0309191317380.2565-100000@Bhuvan.bksys.co.in>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/185
X-Sequence-Number: 15163

> Will the postgres create individual data file for databases?

Yes.

> How to get the datafile path of a database?

/var/lib/pgsql/data/base/, database directory name = pg_database.oid. You
can also use oid2name contrib module for finer detail.

regards,
bhuvaneswaran




From cbbrowne@acm.org Fri Sep  19 11:40:02 2003
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 1EE23D1B51D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Sep 2003 11:40:02 +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 22583-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Sep 2003 08:39:53 -0300 (ADT)
Received: from news.hub.org (unknown [64.117.224.194])
	by svr1.postgresql.org (Postfix) with ESMTP id F1B28D1B50B
	for <pgsql-sql@postgresql.org>; Fri, 19 Sep 2003 08:39:50 -0300 (ADT)
Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194]
	(may be forged))
	by news.hub.org (8.12.9/8.12.9) with ESMTP id h8JBdosp051829
	for <pgsql-sql@postgresql.org>; Fri, 19 Sep 2003 11:39:50 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id h8JBCR92048425
	for pgsql-sql@postgresql.org; Fri, 19 Sep 2003 11:12:27 GMT
From: Christopher Browne <cbbrowne@acm.org>
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: Datafiles for Databases
Date: Fri, 19 Sep 2003 06:48:29 -0400
Organization: cbbrowne Computing Inc
Lines: 23
Message-ID: <m34qz9oxz6.fsf@wolfe.cbbrowne.com>
References: <028101c37e70$3896a6e0$7502a8c0@hdsc.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@news.hub.org
X-message-flag: Outlook is rather hackable, isn't it?
X-Home-Page: http://www.cbbrowne.com/info/
X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne
User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Rational FORTRAN, linux)
Cancel-Lock: sha1:0mNPAfkWjpKwBM2Pu4/t79dInd4=
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/191
X-Sequence-Number: 15169

In the last exciting episode, sgnerd@yahoo.com.sg ("Kumar") wrote:
> I was looking for a structure like oracle or ms Sql server in Postgres. What I have expected is individual
> datafiles for individual databases. But i cant fine such items in the /usr/local/pgsql/data directory.
>
> Will the postgres create individual data file for databases?

No.  Just as with Oracle, PostgreSQL creates multiple files for each
database.

> How to get the datafile path of a database?

select oid, datname from pg_database;

The path for database 'datname' will be:
   $PGDATA/base/oid/
-- 
"aa454","@","freenet.carleton.ca"
http://cbbrowne.com/info/x.html
People can be set wondering by loading obscure personal patchable
systems, and sending bug reports.  Who would not stop and wonder upon
seeing "Experimental TD80-TAPE 1.17, MegaDeath 2.5..."?  The same for
provocatively-named functions and variables in stack traces.
-- from the Symbolics Guidelines for Sending Mail



From pgman@candle.pha.pa.us Wed Sep  24 16:13:10 2003
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 6AF71D1B513
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 24 Sep 2003 16:13:10 +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 68057-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 24 Sep 2003 13:12:39 -0300 (ADT)
Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251])
	by svr1.postgresql.org (Postfix) with ESMTP id 47185D1B533
	for <pgsql-sql@postgresql.org>; Wed, 24 Sep 2003 13:12:37 -0300 (ADT)
Received: (from pgman@localhost)
	by candle.pha.pa.us (8.11.6/8.11.6) id h8OGCQG11706;
	Wed, 24 Sep 2003 12:12:26 -0400 (EDT)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200309241612.h8OGCQG11706@candle.pha.pa.us>
Subject: Re: Datafiles for Databases
In-Reply-To: <m34qz9oxz6.fsf@wolfe.cbbrowne.com>
To: Christopher Browne <cbbrowne@acm.org>
Date: Wed, 24 Sep 2003 12:12:26 -0400 (EDT)
Cc: pgsql-sql@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL106 (25)]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/282
X-Sequence-Number: 15260

Christopher Browne wrote:
> In the last exciting episode, sgnerd@yahoo.com.sg ("Kumar") wrote:
> > I was looking for a structure like oracle or ms Sql?server in Postgres. What I have expected is individual
> > datafiles for individual databases. But i cant fine such items in the /usr/local/pgsql/data directory.
> >
> > Will the postgres create individual data file for databases?
> 
> No.  Just as with Oracle, PostgreSQL creates multiple files for each
> database.
> 
> > How to get the datafile path of a database?
> 
> select oid, datname from pg_database;
> 
> The path for database 'datname' will be:
>    $PGDATA/base/oid/

See the "Monitoring Disk Space" section in our manuals.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073