Actually, I discovered that the problem (postgresql server cannot shut down and cannot restart) is only a problem with a non-default data location.
The postgresql.conf file has a data_directory value, and if you set that to a non-default location, some but not all of the data goes to that location. There is also a pgdata soft link in the same directory as the conf file, and some of the data follows that soft link, no matter the value of data_directory in postgresql.conf. I would call the feature of using a non-default data location as "broken", unless there is documentation somewhere that I have overlooked. I have given up on trying to use /srv/postgresql for the data directory, and instead I am going with the default, /var/lib/postgresql, as use of a non-default location is not currently supported as far as I know. Thanks, --- Rick Graves <[EMAIL PROTECTED]> wrote: > Public bug reported: > > Binary package hint: postgresql > > If you shut down the computer, you see a message > "error PID file is > invalid, please manually kill the stale server > process" (maybe not an > exact quote), along with Fail in red. You get > exactly the same message > if you try shutting down the database server or > restarting the database > server. I have this problem both in ubuntu 6.06 LTS > and 7.10. > > ** Affects: postgresql (Ubuntu) > Importance: Undecided > Status: New > > -- > postgresql server cannot shut down and cannot > restart > https://bugs.launchpad.net/bugs/172840 > You received this bug notification because you are a > direct subscriber > of the bug. > -- postgresql server cannot shut down and cannot restart https://bugs.launchpad.net/bugs/172840 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
