Hi

Do this config work well?
PostGreSQL 8.4 + Veritas File System + RHEL 6.0 ?

This combination is giving problems for me.
Can anyone comment on this?
Following is the procedure i followed and errors etc...
Expert advice is greatly appreciated.
===============================================
#Started the PostGreSQL, started successfully
root{5} pg_ctl -D /usr/local/postgres/data/ start
could not change directory to "/root"
server starting

#Output of ps command
root{6} !ps
ps -ef | grep post
postgres 18203 1 0 19:09 ? 00:00:00 postgres: logger process
postgres 18205 1 99 19:09 ? 01:39:26 postgres: writer process
postgres 19381 1 0 19:11 ? 00:00:00 postgres: logger process
postgres 19383 1 0 19:11 ? 00:00:00 postgres: writer process
root 21392 21352 0 20:47 pts/2 00:00:00 su postgres
postgres 21393 21392 0 20:47 pts/2 00:00:00 bash
postgres 21781 1 18 20:49 pts/2 00:00:00 /usr/bin/postgres -D /usr/local/postgres/data
postgres 21782 21781 0 20:49 ? 00:00:00 postgres: logger process
postgres 21784 21781 0 20:49 ? 00:00:00 postgres: writer process
postgres 21785 21781 0 20:49 ? 00:00:00 postgres: wal writer process
postgres 21786 21781 0 20:49 ? 00:00:00 postgres: autovacuum launcher process
postgres 21787 21781 0 20:49 ? 00:00:00 postgres: stats collector process
postgres 21788 21393 4 20:49 pts/2 00:00:00 ps -ef
postgres 21789 21393 0 20:49 pts/2 00:00:00 grep post

#Checking status of PostGreSQL
root{23} pg_ctl status -D /usr/local/postgres/data/
could not change directory to "/root"
pg_ctl: server is running (PID: 21781)
/usr/bin/postgres "-D" "/usr/local/postgres/data"

#Stopping PostGreSQL, it didnt go through
root{24} pg_ctl stop -D /usr/local/postgres/data/
could not change directory to "/root"
waiting for server to shut down.............................................. ................. failed
pg_ctl: server does not shut down

#Checking status of PostGreSQL, Status shows it as running
root{25} pg_ctl status -D /usr/local/postgres/data/
could not change directory to "/root"
pg_ctl: server is running (PID: 21781)
/usr/bin/postgres "-D" "/usr/local/postgres/data"

# Killed the process 21781, output of ps -ef
root{57} ps -ef | grep postgres
postgres 18205 1 99 19:09 ? 01:46:29 postgres: writer process
postgres 19383 1 0 19:11 ? 00:00:00 postgres: writer process
root 21392 21352 0 20:47 pts/2 00:00:00 su postgres
postgres 21393 21392 0 20:47 pts/2 00:00:00 bash
postgres 21784 1 0 20:49 ? 00:00:00 postgres: writer process
postgres 24398 21393 0 20:56 pts/2 00:00:00 ps -ef
postgres 24399 21393 0 20:56 pts/2 00:00:00 grep postgres

#output of ipcs, open ipcs.
root{58} ipcs | grep postgres
0x00000000 1507334 postgres 600 29278208 1 dest
0x00000000 1540104 postgres 600 29278208 1 dest
0x0052e2c1 1572873 postgres 600 29278208 1
0x0052e2c1 9535490 postgres 600 17
0x0052e2c2 9568259 postgres 600 17
0x0052e2c3 9601028 postgres 600 17
0x0052e2c4 9633797 postgres 600 17
0x0052e2c5 9666566 postgres 600 17
0x0052e2c6 9699335 postgres 600 17
0x0052e2c7 9732104 postgres 600 17
================

Consequences of this :
1)Because of unclosed writers i'm unable to umount filesystem
root 23674 23636 0 20:54 ? 00:00:00 /opt/VRTS/bin/vxumount -o force /usr/local/postgres/data [veritas file system umount is stuck]
2) These writer processes cant be killed, even with kill -9
3) File system is hung.
4) I had to reboot machine

One more doubt.
Does pg_ctl commands internally fire postgres commands only or it does anything new/special?

Can anyone comment on these things?
Expert advice is greatly appreciated.

Thanks
Manoranjan

Why do you use pg_ctl command on root account?
Don't you have postgres user for managing database server?
If you have, does these errors occur when you execute command as postgres user?