1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

psadump complains about pg_ctl

Discussion in 'Plesk for Linux - 8.x and Older' started by jdstevens, Jan 28, 2005.

  1. jdstevens

    jdstevens Guest

    I submit

    /usr/local/psa/bin/psadump --nostop -f /tmp/

    as the root user. An early message in the log file is:

    Checking packages installation ... done
    Check postgres database existing ... found postgres database(s).
    Check Postgres server running ... pg_ctl: cannot be run as root
    Please log in (using, e.g., "su") as the (unprivileged) user that will
    own the server process.
    is not running

    The psadump proceeds, but doesn't appear to properly handle anything related to postgresql.

  2. rsal

    rsal Guest

    You wouldn't be happening to be running Red Hat Enterprise Linux would you? If so, I'm having the same problem, but trying to run psarestore on a new server.

    This is a known issue and I was told by Plesk support that it will be fixed in 7.5.2. That should be coming out this week or the next.

    Hope that helps
  3. jdstevens

    jdstevens Guest

    I'm using Fedora Core 2. I created a way to work around the problem. I don't think this creates a security risk, but I can't guarantee that.

    mv /usr/bin/pg_ctl /usr/bin/pg_ctl.orig

    Create a new /usr/bin/pg_ctl that looks like this:

    #!/bin/sh -x
    su - postgres -c "/usr/bin/pg_ctl.orig $*"

    I put in -x to echo progress of the command. Ownership and permissions of the new pg_ctl should be root:root 755, the same as pg_ctl.orig. If the command is run by root, su succeeds. If it is run by another user, the script will prompt for a password. On my system, postgres has no password so the command will always fail unless invoked by root.
  4. bartje3

    bartje3 Guest


    I had the same problem earlier, here is wat SWSoft support did:

    Comment # strings from line 114 to 121 in /usr/bin/pg_ctl.

    Now all works fine !