Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010
    Posts
    2

    Red face Unanswered: PostGreSQL + Veritas File System

    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

  2. #2
    Join Date
    Nov 2006
    Posts
    82
    Why do you use pg_ctl command on root account?
    Code:
    root{5} pg_ctl -D /usr/local/postgres/data/ start
    Don't you have postgres user for managing database server?
    If you have, does these errors occur when you execute command as postgres user?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •