Re: [ADMIN] How are ppl monitoring PostgreSQL ... ? What is being monitored ... ?

Interesting, Hubert. Where/how do you get the data for: - number of transactions per second - duration of longest query ? Thanks, Otis - Original Message From: hubert depesz lubaczewski To: Marc G. Fournier Cc: pgsql-admin@postgresql.org Sent: Sunday, June 11, 2006 11:10:2

Re: [ADMIN] Roles and Superusers

Keith <[EMAIL PROTECTED]> writes: > It seems that the 'superuser' part of my 'leads' group > role is not functioning (code below). It appears that > the security settings are at least partially > transitive as I have one group role nested within the > other and I am able to access the appropriate >

Fwd: Re: [ADMIN] pg_dump error

Hi, Already doing Vacuum analize procedure on daily basis. But the pg_dump fails on ONLY one table. That table works normal for other operations. But we are feeling uncomfortable to keep using that table as unable to backup. Can anyone give a hint how to fix the pg_dump issue Thanks Manjula

[ADMIN] Roles and Superusers

Greetings: First, I apologize if this is not the correct list to send to. I am having a problem with group roles, logon roles, and inheritance. I am not sure if it is a database problem or a pgIII problem. I am using postgreSQL 8.1.4 and the bundled pgIII on WinXP Home SP2. It seems that the 'sup

[ADMIN] Just checking...

Hi All, This morning our DB server (running postgres 8.1.4) went down unexpectedly during a pg_dump(definitely not saying that this was the cause) and the server required a hard reboot (unfortunately I was left with no other choice)... When I restarted, everything seemed to be OK, however I noti

[ADMIN] PGAdmin "Jobs"

Please assist me in implementing this for the first time? I have installed Postgres 8.1.4 on my laptop, including Admin, then accessed the database "postgres" from PGAdmin 1.4.2 and run the "pgagent.sql" script tp populate the database with the following result:-   NOTICE:  CREATE TABLE / PRIMARY

[ADMIN] Need Help with Logfile Entry

Hello List,I've installed postgres 8.1 and using a cluster which holds a database db_mail. It suppose to work with postfix and sasl-auth, but for some reason it doesn't work.I think Sasl-auth is trying to connect to the db, the logfile shows the following entry after a postfix-sasl-auth connection

Re: [ADMIN] pgpool

After a long battle with technology, [EMAIL PROTECTED] (adey), an earthling, wrote: > Please could someone give me an idea of what pgpool is, and where I can > research it? > > I have run a search on postgresql.org and found many references, but > they don't explain what it is, and it doesn't app

Re: [ADMIN] pg_dump error

Hi, If you are trying to take a table dump try using this pd_dump databasename -t tablename if you are taking in the same server done mention as localhost just switch user as postgress and give the above command mentioned. manjula hettiarachchi wrote: Hello List I am using postgresql 7.4.

[ADMIN] pg_dump error

Hello List I am using postgresql 7.4.7 in a voip production setup. I have been using pg_dump -Fc for regular backing up. Since yesterday i am getting the following error for the command: root# pg_dump -h 'localhost' voipdb -t voipcall -Fc -f voipcall.bak The error is : pg_dump: ERROR: invalid

Re: [ADMIN] pgpool

http://pgpool.projects.postgresql.org/ from the site: "What is pgpool? pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can connect to pgpool as if it were a standard PostgreSQL server..." G.- O

Re: [ADMIN] %psql help

Check out the GRANT nd REVOKE commands: http://www.postgresql.org/docs/8.1/static/sql-grant.html http://www.postgresql.org/docs/8.1/static/sql-revoke.html You may want to do some revoking of PUBLIC rights followed by some granting of rights to specific users on specific databases. But, I don'