Hi,
I loaded pg8.3 beta 4 on a win2k3 64bit box (8GB ram). I was able to
restore a database into it (about 30GB,5schemas and about 2000 tables)
but whenever I try to open the tables in pgadmin3, the database crashes
(i've tried with both the default postgresql.conf file and with some
more tuned ones (based on 8.2.5 running on the same box before holding
the same db):
2007-12-03 16:38:01 GMT LOG: database system is ready to accept
connections
2007-12-03 16:38:01 GMT LOG: autovacuum launcher startedThis application has requested the Runtime to terminate it in
an
unusual way.
Please contact the application's support team for more information.
2007-12-03 16:38:22 GMT LOG: server process (PID 3716) exited with exit
code 3
2007-12-03 16:38:22 GMT LOG: terminating any other active server
processes
2007-12-03 16:38:22 GMT WARNING: terminating connection because of
crash of another server process
2007-12-03 16:38:22 GMT DETAIL: The postmaster has commanded this
server process to roll back the current transaction and exit, because
another server process exited abnormally and possibly corrupted shared
memory.
2007-12-03 16:38:22 GMT HINT: In a moment you should be able to
reconnect to the database and repeat your command.
2007-12-03 16:38:22 GMT LOG: all server processes terminated;
reinitializing
2007-12-03 16:38:23 GMT FATAL: pre-existing shared memory block is
still in use
2007-12-03 16:38:23 GMT HINT: Check if there are any old server
processes still running, and terminate them.
~ filip