Re: database quotes

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: 'Hernan Nuñez' <hnunez(at)vianetworks(dot)com(dot)ar>, "Yuri A(dot) Kabaenkov" <sec(at)artofit(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: database quotes
Date: 2002-03-19 14:00:44
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74834@MAIL_EXCHANGE
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

The name is the oid of the database.
The oid2name in contrib can help here.
However this doesn't solve the problem of new information going into the WAL
files before being written into the actual tables.
I am unsure what would happen if the database where unable to write to table
files information what was already committed in the WAL.
- Stuart

> -----Original Message-----
> From: Hernan Nuñez [mailto:hnunez(at)vianetworks(dot)com(dot)ar]
> Sent: 18 March 2002 11:37
> To: Yuri A. Kabaenkov; pgsql-admin(at)postgresql(dot)org
> Subject: Re: database quotes
>
>
>
> Hi,
>
> I'm running postgresql-7.2 on FreeBSD 4.5 and I resolve
> this using a
> quota on the FileSystem applied to the gid. My problem is
> that i could not
> determine the relation between DataBase Name and the
> Directory for that
> DataBase.
>
> This works fine ...
>
> Regards
>
> Hernan Nuñez | VIA NET.WORKS Argentina
> NICAR-P37184 |
> hnunez(at)vianetworks(dot)com(dot)ar | local touch global reach
> System Administrator |
> Tecnología y Operaciones | http://www.vianetworks.com.ar
> + ICQ: 36528552 | DDI +54 11 43233333
>
>
>
>
>
> ----- Original Message -----
> From: "Yuri A. Kabaenkov" <sec(at)artofit(dot)com>
> To: <pgsql-admin(at)postgresql(dot)org>
> Sent: Sunday, March 17, 2002 5:54 PM
> Subject: [ADMIN] database quotes
>
>
> > Hello,
> > Is there any way to setup quota per postgresql database?
> > I need to limit db space for users.
> >
> >
> >
> >
> > --
> > Best regards,
> > Yuri mailto:sec(at)artofit(dot)com
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo(at)postgresql(dot)org
> >
>
>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2002-03-19 14:04:01 Re: database quotes - oops I'm talking rubbish
Previous Message rama tulasi 2002-03-19 08:48:38 error during copying .txt file