Re: database quotes - Mailing list pgsql-admin

From Henshall, Stuart - WCP
Subject Re: database quotes
Date
Msg-id E2870D8CE1CCD311BAF50008C71EDE8E01F74834@MAIL_EXCHANGE
Whole thread Raw
In response to database quotes  ("Yuri A. Kabaenkov" <sec@artofit.com>)
List 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@vianetworks.com.ar]
> Sent: 18 March 2002 11:37
> To: Yuri A. Kabaenkov; pgsql-admin@postgresql.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@vianetworks.com.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@artofit.com>
> To: <pgsql-admin@postgresql.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@artofit.com
> >
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
> >
>
>

pgsql-admin by date:

Previous
From: Andy Ruhl
Date:
Subject: Re: scheduling tasks under cygwin
Next
From: "Henshall, Stuart - WCP"
Date:
Subject: Re: database quotes - oops I'm talking rubbish