I cannot see your task manager, may be you can send it as .bmp attached with this mail.
As there is only one postgres process, it seems your postgres server itself is not started. >>For the second I have little experience with computers, you could help me write the correct command. a. Go to your postgres installation directory in command prompt b. Run command : Postgres.exe -D <your data directory path> c. For your data directory path, check the path where you have created the initial database with initdb From: Tatiana Ortiz [mailto:tatyp...@gmail.com] Sent: Tuesday, April 10, 2012 9:37 AM To: Amit Kapila Subject: Re: [BUGS] BUG #6522: PostgreSQL does not start Thanks, for your help and sorry for the delay, in Puerto Rico, we had some days off. I did the first recommendation you asked. In task manager I see one process: For the second I have little experience with computers, you could help me write the correct command. Tatiana On Thu, Apr 5, 2012 at 9:24 PM, Amit Kapila <amit.kap...@huawei.com> wrote: According to what I can see from this defect that it is not confirmed whether the Postgre server is started or not properly. You can try on confirming about the following 2 points: 1. How many postgres processes you are able to see in your task manager. This can give hint whether appropriate postgres services are started 2. try to start the postgres from command promt with command Postgres.exe -D <your data directory path> Please tell what it prints on command promt. -----Original Message----- From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of Kevin Grittner Sent: Monday, April 02, 2012 11:43 PM To: Tatiana Ortiz Cc: pgsql-b...@postgresql.org Subject: Re: [BUGS] BUG #6522: PostgreSQL does not start [Please keep the list copied. I won't respond to any more emails directly to me without a copy to the list.] Tatiana Ortiz <tatyp...@gmail.com> wrote: > Kevin Grittner <kevin.gritt...@wicourts.gov wrote: >>> Test if you have network connectivity from your client to the >>> server host using ping or equivalent tools. >> >> Do you get a response when you ping 127.0.0.1? > > I have not tried that. Well, nobody here can, so how will we know if that is working? >>> Is your network / VPN/SSH tunnel / firewall configured >>> correctly? >> >> What did you do to check that? > > It*s configured correctly; I have verified it in the control > panel. What, exactly, did you verify was true about the configuration? >>> If you double-checked your configuration but still get this >>> error message, it`s still unlikely that you encounter a fatal >>> PostgreSQL misbehavior. You probably have some low level network >>> connectivity problems (e.g. firewall configuration). Please >>> check this thoroughly before reporting a bug to the PostgreSQL >>> community. >> >> What did you do to check this? > > The Firewall configuration is correct. Something isn't. If you have a firewall running, I sure wouldn't rule it out without pretty good evidence pointing to something else. Do you have an anti-virus product installed? (Note, I didn't ask whether it was enabled -- even when supposedly disabled, many AV products can cause problems like this.) >> Your previous email mentioned deleting the postmaster.pid file. >> Do you have any more detail on what you did? > > When I deleted the postmaster.pid, and then went to the Services > to give a restart to the Postgre service, the file reappeared. That's an interesting data point, although not enough to pin it down without other facts not in evidence. >>> If you know of something I could do to gain access to the >>> database let me know. >> >> Start Task Manager and look in the Processes tab. Are there any >> Postgres processes active? > > [suggestion apparently ignored] If you won't provide information, nobody can help you. >> From a command line, run: >> >> netstat -p TCP -a >> >> and see if anything is listening on port 5432. > > I tried this, and it gave me this result: > > [image: nothing listening on port 5432] So, either the PostgreSQL service isn't running, or it is not offering IP services on the default port. Is anything appearing in any of the Windows event logs around the time you attempt to start the service? Can you find a PostgreSQL log file anywhere? Without knowing what installer was used, it would be hard to suggest where to look, but sometimes the log files are in a subdirectory named pg_log, and sometimes there is a file named "logfile" in the PostgreSQL data directory. Assistance on this list is provided by volunteers. If you don't care enough about what you've got wrong in your environment to perform the requested diagnostic steps, those contributing their time are likely to lose interest and stop responding. I have 200 databases running just fine on 100 servers scattered across the state. What are you doing that isn't working? It's not my responsibility to sort that out, but I'm willing to help if you're willing to take responsibility for your end. -Kevin -- Sent via pgsql-bugs mailing list (pgsql-b...@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
