Re: limit the database size

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: limit the database size
Date: 2003-10-10 10:28:12
Message-ID: 1065781691.2418.103.camel@linda.lfix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 2003-10-10 at 08:13, Rudi Starcevic wrote:
> Hi,
>
> If you compile/re-compile all databases are accesssible from one port.
> The system table pg_database stores the path to the 'base' dir which can
> be in the user's dir.

We were talking about separate database structures (as created by
initdb), not separate databases within one structure. Each separate
structure requires a postmaster.

You cannot run different postmaster instances simultaneously unless you
differentiate them by using different ports. The point of the original
enquiry was for people to have their own separate database structures,
which could be subject to disk quotas; they will not want to queue up to
use them, will they?

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"He that covereth his sins shall not prosper; but whoso
confesseth and forsaketh them shall have mercy."
Proverbs 28:13

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff 2003-10-10 12:08:37 Re: backup/restore - another area.
Previous Message Laszlo Hornyak 2003-10-10 08:49:16 Re: limit the database size