On Thu, 2004-07-15 at 12:07, Casey T. Deccio wrote: > However, I still have a problem. The files I copies were the database > cluster (because I hadn't been able to dump the db before it quit > working). I copied the cluster to a new directory and tried to start > postmaster manually, specifying -D to point it to that directory. When > I do this, I get an error saying that it couldn't allocate the resources > needed to start it. Nothing has changed since the last time it ran > successfully, but I edited postgresql.conf anyway to allocate the > minimum of everything and still get the same error. When I try to run > it as a service, I get the (very helpful) error from Windows: "The > postmaster service could not be started. A system error has occurred. > System error 1067 has occurred. The process terminated unexpectedly." > > I also have tried copying the cluster to a linux box to try to start the > database on that machine, with that data directory, but it wouldn't go. > I may try doing the same thing on a Windows box with a clean cygwin > install. > > any other suggestions? > > Casey
Problem solved. The "Bad system call" error I received several times due to the fact that I wasn't running the cygserver service, which postgres needs in order to operate (for shared memory). I quickly learned how to start that service. Also, services that use the cygserver service must have the environment variable CYGWIN=server. I incorporated that into the postmaster service, and it worked. The other system errors (one of them in my previous text above) were due to the previous problem that I had created: deleting the postgres user, with files still owned by postgres. An example was the /var/log/postmaster.log file. Because the new postgres user couldn't read it, the service wouldn't start, and I would receive some error that is of little help. Casey
signature.asc
Description: This is a digitally signed message part
____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
