Re: limit the database size

From: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: limit the database size
Date: 2003-10-10 07:13:43
Message-ID: 3F865C27.5000803@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Also in the pg_database table you can update the datdba field to change
the owner of the database.
An example where this is very cool is if the user logs into their
database via a web interface like
phpPgAdmin they can log into just their database and not anyone else's.
Pretty much ideal for a hosting situation.

Does anyone have the C compile flags handy ?

Cheers
Best regards
Rudi.

Oliver Elphick wrote:

>On Fri, 2003-10-10 at 07:13, Laszlo Hornyak wrote:
>
>
>>Hi!
>>
>>I believe you don`t need to recompile, just
>>export PGDATA=/home/me/pgdata
>>pg_initdb
>>pg_ctl start
>>and ready to go.
>>
>>
>
>If you do this, each separate instance needs a different port. That can
>be set in $PGDATA/postgresql.conf.
>
>When you connect to the server (with psql or another frontend) you
>specify the correct port for the server you want.
>
> psql -p 5433 -d mydatabase
>
>or
>
> export PGPORT=5433
> psql -d mydatabase
>
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laszlo Hornyak 2003-10-10 08:49:16 Re: limit the database size
Previous Message Oliver Elphick 2003-10-10 06:32:50 Re: limit the database size