[GENERAL] Limiting simultaneous connections

2001-06-04 Thread Tauren Mills
Is there a way to limit the number of simultaneous connections that any given username can make to the database? For instance, I'd like user1 to be able to have no more than 5 simultaneous connections to the database server, but user2 can have 15 simultaneous connections. Also, can these connect

[GENERAL] Alternate database locations

2001-06-04 Thread Tauren Mills
I've sent this to both pgsql-general and pgsql-admin. Please advise which is the proper list for this type of question. I'm new to PostgreSQL and am trying to implement it in a shared web application hosting environment. Ideally, I'd like each customer to have their databases stored within thei

RE: [GENERAL] Finding number of current connections

2001-08-01 Thread Tauren Mills
ginal Message- > From: Nils O. SelÄsdal [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, August 01, 2001 8:01 PM > To: Tauren Mills; [EMAIL PROTECTED] > Subject: RE: [GENERAL] Finding number of current connections > > > On Wednesday 01 August 2001 07:53 am, Tauren Mills wrote: > >

[GENERAL] Problem with database: FATAL 1: cannot find attribute 24 of relation

2001-09-14 Thread Tauren Mills
Sorry for cross-posting this to both admin and general. I first posted to admin, but as I'm desperate here and there is more activity in the general list, I'm now posting it here as well. --- Help! One of my customers is having a problem with their database causing all of their sites to be dow

[GENERAL] Specifying psql password on command line

2001-06-05 Thread Tauren Mills
I've read the documentation for the psql commands as well as the createdb and dropdb commands. It looks like there is no way to specify the password on the command line. The password is always provided in the form of a stdin prompt. This makes it very difficult to use the commands from a shell

RE: [GENERAL] Specifying psql password on command line

2001-06-05 Thread Tauren Mills
> > I've read the documentation for the psql commands as well as > the createdb > > and dropdb commands. It looks like there is no way to specify > the password > > on the command line. The password is always provided in the > form of a stdin > > prompt. > > Quite deliberately ... if passwords w

[GENERAL] RE: [ADMIN] Alternate database locations

2001-06-05 Thread Tauren Mills
> Fear not, we're used to this. It beats having the lists inundated by > spam, which is what would happen if Marc weren't filtering nonmember > postings :-( Thanks, I figured it was something like that! T. ---(end of broadcast)--- TIP 3: if post