Hallo an all,
habe eine Webseite in Php programmiert und alles umgeschrieben von MySQL zu PostgreSQL…
Jetzt gibt es folgendes Problem:
The situation with PostgreSQL on Mac OS X Snow Leopard installed with Macports:
I have two databeses with different kind of tables.
I have 4 Login roles(Users) created with pgAdmin3 and 4 Login groups
All have not the Superuser or admin rights.
Each table have Privilegs from the Group and to each Group I add a user with login function.
Groups can not login - only users.
And each user got the privileges from the Groups to select, delete or … the table.
The postgresql have following content:
hba_file = '/opt/local/share/postgresql90/pg_hba.conf
- Connection Settings -
listen_addresses = ‘localhost’
port = 5432 # (change requires restart)
max_connections = 64 # (change requires restart)
I tried 1000 max_connection - but still not help.
I have following error always coming - from the postgres.log:
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
FATAL: remaining connection slots are reserved for non-replication superuser connections
FATAL: remaining connection slots are reserved for non-replication superuser connections
FATAL: remaining connection slots are reserved for non-replication superuser connections
Koenne Sie bitte helfen? Ich finde Irgendwie keine Loesung.
Always a lot of connection problems with one user. What I will do if I have coming cupple thousend user per day or per hour to my website?
Please help.