Dear List,
Today morning at 01:00 AM in our PostgreSQL 9.0.3 server a routine
maintenance script has started (vacuumdb --all --full --analyze), and
stopped with this error:
sqlstate=23505ERROR: duplicate key value violates unique constraint
"pg_index_indexrelid_index"
sqlstate=23505DETAIL: Key
Hi,
Check the postgresql.conf file, and the maximum connection settings... Or
check the postgresql.log for other errors, but it seems to me the maximum
connection will be the problem...
Regards,
Cvc
On 2011.04.12. 11:07, "AI Rumman" wrote:
I am connecting to Postgresql 9 from my php application
Ok Vick, thanks, and sorry for the off-list message.
regards,
Carl
2011/4/8 Vick Khera
>
> On Fri, Apr 8, 2011 at 9:53 AM, Gipsz Jakab wrote:
>
>> Thanks Vick, I'll try it tonight. I will give 1024 shared_buffers and
>> maintenance_work_mem, and 102 MB of work_mem.
tup a shorter
time period for the idle time or less lock time?
regards,
Carl
2011/4/8 Merlin Moncure
> On Fri, Apr 8, 2011 at 3:00 AM, Gipsz Jakab
> wrote:
> > After the settings in the postgresql.conf our system is much faster, and
> no
> > more error messages in the postgres
: 1036MB?
DROP/ADD TABLE stuck: I realized, that the locks number is so high, what
about these settings:
deadlock_timeout = 1s
max_locks_per_transaction = 64
is it ok? or is it too high?
Thanks,
Carl
2011/4/8 Vick Khera
>
> On Fri, Apr 8, 2011 at 4:00 AM, Gipsz Jakab wrote:
>
>>
Hi,
I've got an IBM x3200 server, with 1,8 Ghz dual core processor, and with 4
GB RAM. I've installed a FreeBSD 8.2, PostgreSQL 9.0.3, Apache22, with
php5.3.5 and extensions for postgre, session,pdf and others.
After the install, I recieved lot of "too many user" in the postgresql.log,
and after
