[ADMIN] forcing SSL

In order to ensure all user are making SSL connection to the database, in the file pg_hba.conf, I change all the first columns into "hostssl" such that there is neither "host" nor "local" left. However, when I try to use a program written in Tcl to access the database, even without the option "req

Re: [ADMIN] getting postgresql-7.4.1 statistics

hi, Victor Sudakov wrote: I still cannot find the average number of queries per second. Could you please be more specific. there is no such. You have to write it for your own if you want. Or you can log statements to a log file, and then parse that file. C. ---(end of br

[ADMIN] Urgent!!!! Setting permissions on Views

Hello,       I have a small problem setting the permissions for my data. Actually my application allows specific users to manipulate selected tuples stored in the same tables. Therefore, I revoked all privileged on the tables and encapsulated them through views based on the “user”

[ADMIN] master-master replication

Hi, I have following queries related to postgresql 1. Does version 7.4.1 supports master-master replication? If not, does it support master-slave replication where slave can become the master once master is down? When the master comes up again, can it can be configured to slave mode? 2. If th

[ADMIN] Server-side killing of database connection (7.3.4)

I need to kill a connected database user. I'm able to find the pid associated with the troublesome user. However, if I try killing the process with any of INT, TERM or QUIT, all connected database users get the message: WARNING: Message from PostgreSQL backend: The Postmaster has

Re: [ADMIN] getting postgresql-7.4.1 statistics

Naomi Walker wrote: > >> >How do I get the postgresql statistics? I would like to know queries >> >per second etc. >> > >> >The stats_start_collector variable is on, and I can see the >> >stats collector process running. But how do I query it? >> > >> >Thanks a lot for any input. >> >>Check out ww

[ADMIN] SSH connection timing out

I know this isn't strictly a postgresql question, but I'm sure it applies to others out there using psql. If I am working in psql from SSH and switch to another window, it seems that there is a very short window of time before the window freezes and doesn't allow any more input. Does anyone know

Re: [ADMIN] forcing SSL

[EMAIL PROTECTED] (Eric) writes: > In order to ensure all user are making SSL connection to the database, > in the file pg_hba.conf, I change all the first columns into "hostssl" > such that there is neither "host" nor "local" left. > However, when I try to use a program written in Tcl to access t

Re: [ADMIN] Server-side killing of database connection (7.3.4)

Rune Froysa <[EMAIL PROTECTED]> writes: > I need to kill a connected database user. I'm able to find the pid > associated with the troublesome user. However, if I try killing the > process with any of INT, TERM or QUIT, all connected database users > get the message: >WARNING: Message from

Re: [ADMIN] Urgent!!!! Setting permissions on Views

"Dani Mezher" <[EMAIL PROTECTED]> writes: > I have a small problem setting the permissions for my data. What PG version is this? There's a known bug in some recent versions about checking view permissions ... regards, tom lane ---(end

[ADMIN] unsubscribe pgsql-admin

unsubscribe pgsql-admin ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]