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
>
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
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'
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
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
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.
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
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
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
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
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
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
12 matches
Mail list logo