1. Forum
  2. Usenet
  3. LINUX.DEBIAN.BUGS.DIST

  • Bug#265576: postgresql: upgrade from woody fails: /tmp/pg..: Permission

    From Peter Palfrader@1:229/2 to All on Fri Aug 13 22:00:17 2004
    From: [email protected]

    Package: postgresql
    Version: 7.4.3-3
    Severity: normal

    Upgrading from stable I get:

    Attempting PostgreSQL database upgrade; the time taken will depend on the size of your database(s).
    /tmp/pg.J1WMqk: line 4: /pg.cXYIYb: Permission denied
    Sorry; the automatic database upgrade failed.

    tmp is mounted nosuid on this box, but the same happened on another box
    today, where /tmp is on /



    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)
  • From Oliver Elphick@1:229/2 to Peter Palfrader on Fri Aug 13 22:30:11 2004
    From: [email protected]

    On Fri, 2004-08-13 at 20:34, Peter Palfrader wrote:
    Package: postgresql
    Version: 7.4.3-3
    Severity: normal

    Upgrading from stable I get:

    Attempting PostgreSQL database upgrade; the time taken will depend on the size of your database(s).
    /tmp/pg.J1WMqk: line 4: /pg.cXYIYb: Permission denied
    Sorry; the automatic database upgrade failed.

    tmp is mounted nosuid on this box, but the same happened on another box today, where /tmp is on /

    The first box explains itself. Is the file still available on the
    second? If so, does it have execute permission?

    --
    Oliver Elphick [email protected]
    Isle of Wight http://www.lfix.co.uk/oliver
    GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
    ========================================
    "Watch ye therefore, and pray always, that ye may be
    accounted worthy to escape all these things that shall
    come to pass, and to stand before the Son of man."
    Luke 21:36



    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)
  • From Peter Palfrader@1:229/2 to Oliver Elphick on Fri Aug 13 22:40:09 2004
    From: [email protected]

    On Fri, 13 Aug 2004, Oliver Elphick wrote:

    On Fri, 2004-08-13 at 20:34, Peter Palfrader wrote:
    Package: postgresql
    Version: 7.4.3-3
    Severity: normal

    Upgrading from stable I get:

    Attempting PostgreSQL database upgrade; the time taken will depend on the size of your database(s).
    /tmp/pg.J1WMqk: line 4: /pg.cXYIYb: Permission denied
    Sorry; the automatic database upgrade failed.

    tmp is mounted nosuid on this box, but the same happened on another box today, where /tmp is on /

    The first box explains itself. Is the file still available on the
    second? If so, does it have execute permission?

    It's not available on the second host. I didn't reboot it and I'm
    pretty sure I didn't delete it manually.

    --
    Peter


    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)
  • From Matthew Woodcraft@1:229/2 to All on Mon Aug 16 14:30:13 2004
    From: [email protected]

    I see this as well.

    It seems to me that the error is coming from this line in the
    SCRIPTFILE written by the postinst:

    postgresql-dump -inldvp $savedir -Ft "${DUMPLOC}/db.out" > $TMPFILE 2>&1

    This is executed by user postgres, but TMPFILE was created by root and
    isn't world-writeable.

    -M-


    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)
  • From Oliver Elphick@1:229/2 to Matthew Woodcraft on Mon Aug 16 15:30:13 2004
    From: [email protected]

    On Mon, 2004-08-16 at 13:05, Matthew Woodcraft wrote:
    I see this as well.

    It seems to me that the error is coming from this line in the
    SCRIPTFILE written by the postinst:

    postgresql-dump -inldvp $savedir -Ft "${DUMPLOC}/db.out" > $TMPFILE 2>&1

    This is executed by user postgres, but TMPFILE was created by root and
    isn't world-writeable.

    Thanks for the info; that makes things a lot more understandable!

    --
    Oliver Elphick [email protected]
    Isle of Wight http://www.lfix.co.uk/oliver
    GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
    ========================================
    "And whatsoever ye shall ask in my name, that will I
    do, that the Father may be glorified in the Son."
    John 14:13



    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)