Hello,
First background:
Redhat 5.7 (64bit), Postgres 8.4.7(64bit) (no postgis), SDE 10(64bit)
I realise that I'm not running the exact versions that ESRI supports but my I decided to check with the community anyway.
When I do analyze on the database it chrashes that database and that following error is displayed.
**********************
INFO: "t_2_dirtyareas": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: WARNING: terminating connection because of crash of another server process
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.
HINT: In a moment you should be able to reconnect to the database and repeat your command.
**********************
This does not happen if I remove the topology from the database then analyze completes without problems.
This seems to be true with most topologys (aka all the real ones we are actually using) but I have been able to create a simple, test topology that does not crash the db when running analyze.
Any sugguestions, or experiences with running slightly newer versions of redhat and postgres with sde.
Thank you