X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id A53E7D1C517 for ; Fri, 6 Feb 2004 09:08:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 05011-01 for ; Fri, 6 Feb 2004 05:07:47 -0400 (AST) Received: from web21325.mail.yahoo.com (web21325.mail.yahoo.com [216.136.175.211]) by svr1.postgresql.org (Postfix) with SMTP id 0C723D1D36C for ; Fri, 6 Feb 2004 05:07:45 -0400 (AST) Message-ID: <20040206090742.95268.qmail@web21325.mail.yahoo.com> Received: from [203.129.234.141] by web21325.mail.yahoo.com via HTTP; Fri, 06 Feb 2004 01:07:42 PST Date: Fri, 6 Feb 2004 01:07:42 -0800 (PST) From: neelesh vijaivargia Subject: Data location in PostgreSQL To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/91 X-Sequence-Number: 12265 Hi, I am using PostgreSQL7.3 in linux and i have installed it in db/ folder into my account and also specified cluster area as db/data at the time of calling initdb. i want to take backup on another machine whenever database changes on primary server, then it should reflect on backup server also.but on the both machine (primary and backup) directory structure under /db/data/base is different. I want to know that how PostgrqSQL stores data into file system because both server had only one database which named is nydb please let me know that where data should be stored when i defined cluster ara as db/data and why different directory structure exist on primary and backup server even though they both have contains same no. of tables and same database and same contains of tables. Thanks and regards, Neelesh Vijaivargia. __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html