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:[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 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
