[ADMIN] child process problem

2001-04-07 Thread Jeremy Ashcraft
I'm running PG7.0.2 on Solaris8 and am experiencing a problem with child procs hanging around long after their queries have finished. We're using PG in conjuction with Enhydra application server. I'm wondering if this is a known bug of some sort with Solaris or PG, or will I need to dig into the

[ADMIN] Postmaster hangs until Ctrl-C

2001-04-07 Thread Tom Brown
When I run postmaster, the system hangs until I Ctrl-C.   I have a VA Linux box. Postgresql 6.4 was installed at the factory with root ownership and permissions. I read the FAQ and Admin manual re installation. There was no postgres user although VA did create a postgres group. I created a p

[ADMIN] ERROR: cannot read block 1452 from data (HELP!!!! I'MDESPERATE!)

2001-04-07 Thread dazo
Hi ya'll! I hope some of you can help me with this emergency! One of my data tables has crashed and I'm not able to dump the table or vacuum it ... it just gives me the same story each time: Cannot read block 1452 from data I've done filesystems check, everything ok (both e2fsck and badblock

[ADMIN] Problem starting postmaster

2001-04-07 Thread Homayoun Yousefi'zadeh
Hello there, I am migrating from MySQL to PostgreSQL. I have built pgsql 7.0.3 on Redhat 7.0. All of the nevironmental variables have been set properly. When I try to start the database server using the following bash-2.04$ /usr/local/pgsql/bin/postmaster I get IpcMemoryCreate: shmget failed

[ADMIN] Sort no Postgres

2001-04-07 Thread Mauricio de Castro
Olá lista, estamos com um problema no SAGU, mas especificamente no Postgres (usamos a versão 6.5.3) com a ordenação de nomes. Ele separa letras maiusculas e minusculas e letras com e sem acentos. Depois de uma pesquisa, encontramos que deviamos acertar as seguintes variáveis: LC_CTYPE=