Postgresql 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 postgresql service started then stopped Associations User groups Project lists Inactive lists IRC Local
Postgresql Service Not Starting Windows
User Groups Featured Users International Sites Propaganda Resources Weekly News pg_ctl: could not pg_ctl could not start service error code 1063 start service "pgsql-8.2": error code 1063 From: Stefano T
Error Code 1063 Java
command and try execute: C:\Programs\PostgreSQL\8.2\bin\pg_ctl.exe runservice -N "pgsql-8.2" -D "C:\Programs\PostgreSQL\8.2\data\" the output is: pg_ctl: could not start service "pgsql-8.2": error code 1063 and if i try to execute this: C:\WINDOWS\system32\net.exe start pgsql-8.2 the output is: The PostgreSQL Database Server 8.2 service is starting. The PostgreSQL Database Server 8.2 service could not be started. The service did not report an error. and the execution of this: C:\Programs\PostgreSQL\8.2\bin>psql.exe psql: could not connect to server: Connection refused (0x0000274D/ 10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? some one can help me? how can i fix this problem? Responses Re: pg_ctl: could not start service "pgsql-8.2": error code 1063 at 2007-05-07 17:14:50 from Magnus Hagander pgsql-general by date Next:From: Michael NolanDate: 2007-05-05 21:50:49 Subject: Refreshing a warm spare with
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 pg_ctl start access is denied site About Us Learn more about Stack Overflow the company Business Learn more timed out waiting for server startup about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Postgres Service Not Starting
Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Unable to run https://www.postgresql.org/message-id/1178383510.463603.250330@h2g2000hsg.googlegroups.com PostgreSQL as Windows service up vote 11 down vote favorite 4 I had this in my Windows services: C:/Program Files/PostgreSQL/8.4/bin/pg_ctl.exe runservice -N "postgresql-8.4" -D "D:/PostgreSQL/8.4/data" -w It never finishes executing. But if I did this on the dos shell: C:/Program Files/PostgreSQL/8.4/bin/pg_ctl.exe start -N "postgresql-8.4" -D "D:/PostgreSQL/8.4/data" -w Notice that I only changed the "runservice" to "start" and it works just fine. Any idea? postgresql http://stackoverflow.com/questions/1251233/unable-to-run-postgresql-as-windows-service service share|improve this question edited Jan 14 '12 at 6:50 Erwin Brandstetter 220k29357468 asked Aug 9 '09 at 11:48 David 1,20283047 add a comment| 7 Answers 7 active oldest votes up vote 14 down vote The command runservice can only be executed by the service manager in order to fix my localhost windows 7 to start postgres as a service i used the following command to start the data pg_ctl -D "C:\Program Files\PostgreSQL\9.1\data" start Then checked the status for errors pg_ctl -D "C:\Program Files\PostgreSQL\9.1\data" status if you get error 1063 , its more than likely permissions, i executed the following command cacls "C:\Program Files\PostgreSQL\9.1\data" /E /T /C /G postgres:F then reran the start/status, it showed everything fine, but still service manager would not start the service So, in Services->postgresql->options->logon i set the log on as the Local system account instead of the postgres user, and voila it worked share|improve this answer answered Jul 13 '12 at 16:27 Jay Rizzi 2,04011939 worked for me. thanks –arjuncc Aug 26 '13 at 11:29 This worked for me too. postgresql 9.5.2. In short: in services select the service and view its propert
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 http://dba.stackexchange.com/questions/30927/computer-restarted-and-postgres-9-2-service-cannot-be-started Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with 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 not start 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 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 service not starting 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 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