X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6CABF9FA5FB for ; Tue, 30 May 2006 12:11:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 27159-02 for ; Tue, 30 May 2006 12:11:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id F04BE9FA5E2 for ; Tue, 30 May 2006 12:11:34 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so550261ugf for ; Tue, 30 May 2006 08:11:33 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:mime-version:content-type:x-google-sender-auth; b=brhUKkg9HpToG2ex55ONdqdZ+7skcT007Np5g7R1vedqJpDC4vZc+2coFhmndSL2fnZj8cl3aT/2B4xBH0JOMCiEjI/t0CR//Dovaswj9/ANQcE1C20H9QvO4xMb9XTWcoLSMFbmV6b18LDt8F20+76sVs4GfxXxf3+2yJ8Pyks= Received: by 10.67.89.5 with SMTP id r5mr2870021ugl; Tue, 30 May 2006 08:11:03 -0700 (PDT) Received: by 10.67.20.12 with HTTP; Tue, 30 May 2006 08:11:03 -0700 (PDT) Message-ID: Date: Tue, 30 May 2006 10:11:03 -0500 From: "Aaron Bono" To: pgsql-admin@postgresql.org Subject: Separating Databases on Different Partitions MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_13275_30415099.1149001863406" X-Google-Sender-Auth: 728da25a8992b678 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/413 X-Sequence-Number: 21945 ------=_Part_13275_30415099.1149001863406 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Is there a way to get Postgres to store each database in a separate directory? I first hoped I could just use symbolic links under the data directory but I have no idea which files are assigned to which database. The reason I am wanting to do this is that I have a database set up for each user on my server. I need to put their database under their home directory somewhere so I know how much disk space each user account is taking. I also need to put the database under the /home partition as it has a lot more space than the partition containing the data directory. Thanks, Aaron ------=_Part_13275_30415099.1149001863406 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Is there a way to get Postgres to store each database in a separate directory?  I first hoped I could just use symbolic links under the data directory but I have no idea which files are assigned to which database.

The reason I am wanting to do this is that I have a database set up for each user on my server.  I need to put their database under their home directory somewhere so I know how much disk space each user account is taking.  I also need to put the database under the /home partition as it has a lot more space than the partition containing the data directory.

Thanks,
Aaron

------=_Part_13275_30415099.1149001863406--