"John Lister" writes:
On another bizarre note, A database wide vacuum has just finished, but
I'm
still getting the warnings:
GMT WARNING: database "backend" must be vacuumed within 10205310
transactions
Did you do that vacuum as a superuser?
yes
John
--
Sent via pgsql-admin mailing
"John Lister" writes:
> On another bizarre note, A database wide vacuum has just finished, but I'm
> still getting the warnings:
> GMT WARNING: database "backend" must be vacuumed within 10205310
> transactions
Did you do that vacuum as a superuser?
regards, tom lane
Hi, I'm running 8.3.9 on ubuntu with autovacuum enabled and seemingly
working properly., however I've started getting messages saying that I'm
near the transaction limit and I need to do a database wide vacuum, which
I've started.
From reading the docs, though I thought that autovacuum would do
"John Lister" writes:
> Hi, I'm running 8.3.9 on ubuntu with autovacuum enabled and seemingly
> working properly., however I've started getting messages saying that I'm near
> the transaction limit and I need to do a database wide vacuum, which I've
> started.
> From reading the docs, though I
Hi, I'm running 8.3.9 on ubuntu with autovacuum enabled and seemingly working
properly., however I've started getting messages saying that I'm near the
transaction limit and I need to do a database wide vacuum, which I've started.
>From reading the docs, though I thought that autovacuum would d
"Kevin Grittner" writes:
> Dennis Hoffman wrote:
>> What can I do?
> I'd be tempted to write a script which was owned by root which
> calculated the size as desired, and grant sudo rights to merlin to
> execute that particular script as the user with rights.
Seems like a postgres-owned script
Dennis Hoffman wrote:
> If I do nothing other than remove the file permissions ( change
> back to 700 from 750 ), the Postmaster starts just as it should.
> Why does the Postmaster not start with the group permissions
> changed?
That's intentional, as a security measure.
> Is this a bug?
Hello:
I am running Postgres version 7.4.13 on a Linux CentOS box with kernel
version 2.6.9-67.0.7
I have a process running under a user ( "merlin" ) that needs access to the
data base ( to calculate the DB size ). I have added the "merlin" user as a
member of the postgres group, and changed
Hi,
I have have a question that annoys me incredibly.
I have a "Login Roles" that include special chars like "ÆØÅ" (same in
password) that accesses a view. however this is not possible, as the
connector does not recognize the user.
---
FATAL: no pg_hba.conf entry
