Postgres Windows Error 1063
Contents |
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project postgresql service started then stopped lists Inactive lists IRC Local User Groups Featured Users International postgresql service not starting windows Sites Propaganda Resources Weekly News Re: Error code 1063 From: "Magnus Hagander"
Pg_ctl Start Access Is Denied
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the error code 1063 java company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Timed Out Waiting For Server Startup
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million
Postgres Service Not Starting
programmers, just like you, helping each other. Join them; it only takes a minute: Sign up PostgreSQL fails to start on Windows XP [closed] up vote 0 down vote favorite I am attempting to set up https://www.postgresql.org/message-id/6BCB9D8A16AC4241919521715F4D8BCEA0FAEC@algol.sollentuna.se a Windows XP Test Agent running Ruby on Rails against a PostgreSQL Database. I've installed PostgreSQL 9.2 for Windows, with default settings. However, when I attempt to start the service from the Service Control Panel, the following error message appears(irrelevantly of which User I attempt to set it to): The postgres-9.2 -PostgreSQL Server 9.2 service on Local Computer started and then stopped. Some services stop automatically if they have work to do, for http://stackoverflow.com/questions/13116511/postgresql-fails-to-start-on-windows-xp example, the Performance Logs and Alerts service. If I attempt to launch it from the command line (whether cmd.exe or git bash doesn't matter with): E:\PostgreSQL\9.2\bin\pg_ctl.exe start -D E:\PostgreSQL\9.2\data It will claim: server starting However it will fail to start (rake db:migrate will report the server as not running, the postgresql process is missing from Task Manager, the Service is listed as down in the Service List, and E:\PostgreSQL\9.2\bin\pg_ctl.exe stop -D E:\PostgreSQL\9.2\data Will report pg_ctl: PID file "E:/PostgreSQL/9.2/data/postmaster.pid" does not exist Is server running? While attempting to start it as a server through pg_ctl: E:\PostgreSQL\9.2\bin\pg_ctl.exe runservice -D E:\PostgreSQL\9.2\data Fails with: pg_ctl: could not start service PostgreSQL: error code 1063 EDIT: the contents of pg_hba: # TYPE DATABASE USER ADDRESS METHOD local all all all trust # IPv4 local connections: host all all all trust host all all 127.0.0.1/32 trust # IPv6 local connections: #host all all ::1/128 trust # Allow replication connections from localhost, by a user with the # replication privilege. #host replication all all trust #host replication postgres 127.0.0.1/32 trust #host replication postgres ::1/128 trust Checking in pg_log as per comments below: 2012-10-28 22:47:44 PDT LOG: local connections are not supported by this build 2012-10-28 22:47:44 PDT CONTEXT: line 78 of configuration file "E:/PostgreSQL/9.2/data/pg_hba.conf" 2012-10-28 22:47:44 PDT FATAL: could not load pg_hba.conf Line 78 is loc
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with http://dba.stackexchange.com/questions/30927/computer-restarted-and-postgres-9-2-service-cannot-be-started us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Computer restarted and Postgres 9.2 service cannot be started? up vote 2 down vote not start favorite My firewall is down and when I tried to start the Postgres service it gave me an error that said: the service started and then stopped. Some services stop automatically if they are not in use by other services or programs. I need to start postgres for pgadmin and when I tried to connect to pgadmin it gave me an error that I've seen before but none of those conditions of the error is true because it worked right before my computer was automatically service not starting restarted. I honestly didn't want to change my conf file and simply do it from the pgadmin postgres.conf gui. The console also gave me an error about a line that had debug assertions =, which I put a hash mark to the left of which got rid of the error. When I try to run postgres from the command prompt it gives me that postgresql.conf contains errors? But what errors would they be? I also tried running from the console a couple of different ways and one of the errors I got was pg_ctl: could not start service "postgresql-9.2": error code 1063 postgresql server share|improve this question asked Dec 21 '12 at 14:29 Carl Carlson 11114 migrated from gis.stackexchange.com Dec 21 '12 at 19:33 This question came from our site for cartographers, geographers and GIS professionals. 3 Can you post the text of the errors? I take it you're on Windows? –R.K. Dec 21 '12 at 15:06 yes, well the problem is that I can't copy and paste the errors as they are in separate windows –Carl Carlson Dec 21 '12 at 15:23 Have you modified postgresql.conf? If so, what about using the backup you made before modifying? –Jay Laura Dec 21 '12 at 16:51 I didn't make a backup. I basically just placed a hashmark to the left of debug assertions. –Carl Carlson Dec 21 '12 at 17:07 what's on line 574? And I'm pretty sure you shouldn't use both double