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
> >
>
>
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 |