Sorry to reply to myself Ignore me sorry I'm talking rubbish. I was forgetting all processes would be owned by the postgres user and not the database user. (The oid2name stuff is still correct) - Stuart
> -----Original Message----- > From: Hernan Nuñez [mailto:[EMAIL PROTECTED]] > Sent: 18 March 2002 11:37 > To: Yuri A. Kabaenkov; [EMAIL PROTECTED] > 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 | > [EMAIL PROTECTED] | 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED] > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > > > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
