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 ; 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 ; 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 ; 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 ; 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 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: 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