here is)?
Thanks,
Tauren
> -Original Message-
> From: Tauren Mills [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 14, 2001 8:23 AM
> To: [EMAIL PROTECTED]
> Subject: Problem with database: FATAL 1: cannot find attribute 24 of
> relation
>
>
> Help!
>
&
Help!
One of my customers is having a problem with their database causing all of
their sites to be down right now. The problem seems to effect only their
database, not any other databases on the server. Here is the output when
connecting to it:
[root@s1 data]# psql -U postgres dans_pgsql
Passw
I need to find a way to determine how many concurrent connections are being
made to the database server at any given time. I'm coming from
administering a MySQL database and am familiar with the following command:
mysqladmin -uroot -p processlist
This lists something like this:
+-+--+-
Sorry for the previous message. I was totally missing the shared_buffers
setting. Its working now with this:
tcpip_socket = true
max_connections = 128
log_connections = on
shared_buffers = 256 # max_connections*2
Tauren
---(end of broadcast)-
I'm running PostgreSQL 7.1 (not 7.1.2) as installed from the RPM on a Red
Hat 6.2 machine. It automatically installs a startup script into
/etc/rc.d/init.d. By default, the server does not listen to tcp/ip
connections. Since I'll be using JDBC, I need it to do this. I also need
more than 32 co
I'm not sure how this message got posted again. I think it is because I
posted it to the newsgroup first but it was rejected since I was not a
member of the list. Now that I'm a member, I'm assuming it went through.
However, I'd already sent it directly to the list as an email after joining.
So
Stephan and Tim,
Thanks for your response. Not exactly what I was hoping for, but at least I
don't need to keep searching any longer.
Tauren
> -Original Message-
> From: Stephan Szabo [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 05, 2001 3:15 PM
> To: Tauren M
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 their own user area. For instance, the
/home/user1/.pgsql would contain all of user1's databases.
It looks like this could b
I don't mean to be a pest, but I haven't heard anything back on this subject
and have been unable to locate any information about it in the manuals. I'm
not the only one interested in this since I've received mail from other
people asking if I have an answer yet.
Does anyone know if this is poss
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
Thanks for the feedback!
> >> However, this page indicates that there are security risks in
> doing this.
> >> What are those risks? If I prevent users other than the superuser
> >> "postgres" from being able to create and drop databases, are there any
> >> security risks?
>
> > No. The risks a
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
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
13 matches
Mail list logo
