Re: database quotes

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(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: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'Hernan Nuñez'" <hnunez(at)vianetworks(dot)com(dot)ar>; "Yuri A. Kabaenkov"
<sec(at)artofit(dot)com>; <pgsql-admin(at)postgresql(dot)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(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
> > >
> >
> >
>