Postgres Pro
Downloads
Home   >   mailing lists

Thread: database quotes

database quotes

From
"Yuri A. Kabaenkov"
Date:
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

Re: database quotes

From
Hernan Nuñez
Date:
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
>

Re: database quotes

From
"Henshall, Stuart - WCP"
Date:
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
> >
>
>

Re: database quotes

From
Hernan Nuñez
Date:
Thanks..

I could resolve this using the following wuery 'select oid,datname from
pg_database;'

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: "Henshall, Stuart - WCP" <SHenshall@westcountrypublications.co.uk>
To: "'Hernan Nuñez'" <hnunez@vianetworks.com.ar>; "Yuri A. Kabaenkov"
<sec@artofit.com>; <pgsql-admin@postgresql.org>
Sent: Tuesday, March 19, 2002 11:00 AM
Subject: RE: database quotes


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