[Dspace-tech] Postgres won't work after violent shutdown
Hi all I've been on this problem for two days! Would seriously appreciate some suggestions. My server went down unexpectedly, and since restarting, the Postgres db won't come back on. I'm running PostgreSQL8.1 on Windows Server 2003 with DSpace 1.4.2 I'm getting various error messages: Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D/10061) Is the server running on host 127.0.0.1 and accepting TCP/IP connections on port 5432? This is when trying to open the db in pgAdminIII. I don't think its a TCP/IP problem though, because I get the problem when working on the server (that's a guess). Is postmaster running? pg_ctl: PID file C:\Program Files\PostgreSQL\8.1\data\postmaster.pid does not exist. Is postmaster running? I get this when trying pg_ctl command. So naturally I check to see if the postmaster is running. It is not, I cant get it on either because it tells me (when starting it as a restricted user): Error 5: Access denied I have totally no clue where the problem lies. Firewall is off, Postgres exceptions is on on the right port anyway... Out of ideas. Out of steam. PPLLEEAASSEE apply your genius/knowledge/experience to my problem, because I have none. Many thanks Juuventud -- View this message in context: http://www.nabble.com/Postgres-won%27t-work-after-violent-shutdown-tp20703296p20703296.html Sent from the DSpace - Tech mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Postgres won't work after violent shutdown
juuventud wrote: Hi all I've been on this problem for two days! Would seriously appreciate some suggestions. My server went down unexpectedly, and since restarting, the Postgres db won't come back on. I'm running PostgreSQL8.1 on Windows Server 2003 with DSpace 1.4.2 I'm getting various error messages: Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Connection refused (0x274D/10061) Is the server running on host 127.0.0.1 and accepting TCP/IP connections on port 5432? This is when trying to open the db in pgAdminIII. I don't think its a TCP/IP problem though, because I get the problem when working on the server (that's a guess). Is postmaster running? pg_ctl: PID file C:\Program Files\PostgreSQL\8.1\data\postmaster.pid does not exist. Is postmaster running? I get this when trying pg_ctl command. So naturally I check to see if the postmaster is running. It is not, I cant get it on either because it tells me (when starting it as a restricted user): Error 5: Access denied I have totally no clue where the problem lies. Firewall is off, Postgres exceptions is on on the right port anyway... Out of ideas. Out of steam. PPLLEEAASSEE apply your genius/knowledge/experience to my problem, because I have none. Many thanks Juuventud I haven't used windows in a while but I can try a couple of suggestions to kick things off. When you look in the Services list (you get to it via control panel-administration i think) is postgres showing as running? Also, in the task manager, is postgres.exe there? Are there any more details in the logs (Event Viewer?)? You may also want to check the config files in case your machine's ip address has changed since the reboot and postgres is still listening on the old ip. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Postgres won't work after violent shutdown
Thanks Mr Havercamp I've been trying to switch the service on by all the methods I can think of, but in Services it just goes on and then off again immediately. Postgres.exe is not in the Task Manager's list of Processes. My Server IP has not changed and the postgresql.conf is set to listen on all addresses. Can you suggest anything I should do about the Service not running? Thanks a lot. Mr Havercamp wrote: juuventud wrote: Hi all I've been on this problem for two days! Would seriously appreciate some suggestions. My server went down unexpectedly, and since restarting, the Postgres db won't come back on. . . . Many thanks Juuventud I haven't used windows in a while but I can try a couple of suggestions to kick things off. When you look in the Services list (you get to it via control panel-administration i think) is postgres showing as running? Also, in the task manager, is postgres.exe there? Are there any more details in the logs (Event Viewer?)? You may also want to check the config files in case your machine's ip address has changed since the reboot and postgres is still listening on the old ip. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- View this message in context: http://www.nabble.com/Postgres-won%27t-work-after-violent-shutdown-tp20703296p20714608.html Sent from the DSpace - Tech mailing list archive at Nabble.com. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
Re: [Dspace-tech] Postgres won't work after violent shutdown
Hi, I also have bad experience of using postgresql under windows. It is less stable than running in unix/linux. I would suggest: 1. Look into your event log to discover why postgres could not start. Then fix it accordingly. 2. If you cannot fix it, back up the data directory and then uninstall postgres. Reinstall the SAME version of postgres again. When it starts happily, copy the data directory back to replace the default one. Regards, Allen Lam. HKU Hub Administrator, http://hub.hku.hk juuventud wrote: Thanks Mr Havercamp I've been trying to switch the service on by all the methods I can think of, but in Services it just goes on and then off again immediately. Postgres.exe is not in the Task Manager's list of Processes. My Server IP has not changed and the postgresql.conf is set to listen on all addresses. Can you suggest anything I should do about the Service not running? Thanks a lot. Mr Havercamp wrote: juuventud wrote: Hi all I've been on this problem for two days! Would seriously appreciate some suggestions. My server went down unexpectedly, and since restarting, the Postgres db won't come back on. . . . Many thanks Juuventud I haven't used windows in a while but I can try a couple of suggestions to kick things off. When you look in the Services list (you get to it via control panel-administration i think) is postgres showing as running? Also, in the task manager, is postgres.exe there? Are there any more details in the logs (Event Viewer?)? You may also want to check the config files in case your machine's ip address has changed since the reboot and postgres is still listening on the old ip. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech -- Regards, Allen Lam. HKU Hub Administrator, http://hub.hku.hk - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech