Обсуждение: database quotes

Поиск
Список
Период
Сортировка

database quotes

От
"Yuri A. Kabaenkov"
Дата:
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

От
Hernan Nuñez
Дата:
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

От
"Henshall, Stuart - WCP"
Дата:
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

От
Hernan Nuñez
Дата:
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
> > >
> >
> >
>