Enzo Daddario <[EMAIL PROTECTED]> writes:
> I have just installed postgres 8.1.2 (upgrading from 7.4.2) and upon
> commencement of populating DBs with data dumped using pg_dumpall(7.4.2)
> I receive the following error:
> DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database
> WH
Hi All,
I have just installed postgres 8.1.2 (upgrading from 7.4.2) and upon
commencement of populating DBs with data dumped using pg_dumpall(7.4.2)
I receive the following error:
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database
WHERE datname = 'template0');
ERROR: cannot
Greetings,
I was trying to build source build postgres 8.1.x with MIT Kerberos 5 1.4.x
implementation.
The whole thing bombs out. After some digging, I had to hack the autoconf
script (configure.in)
to properly account for the way the libraries are built for 1.4.x. I don't
know whether an earlier
I am trying to install PostgreSQL 8.1 on Windows2003 Standard
Edition and installation failed.
Attached is the log that I
corresponded to it from Installer dialog. I can find the reason of ‘Access
is denied’
message that I see in this file. Or may be this isn’t
a reason of the problem.
Christopher Browne <[EMAIL PROTECTED]> writes:
>> does autovacuum locks tables while vacuuming?
> Of course it does; any request to access a relation will issue one or
> more locks on the relation.
This is correct in general ...
> VACUUM issues an AccessShareLock request against each relation th
> i have PostgreSQL 8.1.2
>
> i want to enable autovacuum at my PostgreSQL 8.1.2 from postgresql.conf
> i've got 50-60 insert and/or update queries in a second in that case
> tables shouldn't be locked
> does autovacuum locks tables while vacuuming?
Of course it does; any request to access a rela
i have PostgreSQL 8.1.2
i want to enable autovacuum at my PostgreSQL 8.1.2 from postgresql.conf
i've got 50-60 insert and/or update queries in a second in that case tables
shouldn't be locked
does autovacuum locks tables while vacuuming?
and also i wonder what should be the configuration?
