Re: BUG #4771: Postgres wont start

When I looked at the Windows Event Log I found this:
%t FATAL:  bogus data in lock file
"postmaster.pid": ""
So what do I do now? I have already re installed and that didn't
help.
Christine
At 02:45 AM 4/23/2009, you wrote:
Christine,
when PostgreSQL does not start on Windows, the first place to look for
errors is the Microsoft Windows EventLog. That is the standard place to
report errors.
You can dig there via Control Panel; exact click path depending on your
Windows Version (XP / Vista / W2003 / W2008 / W7); or start a commandline
and type eventvwr (works on all)
There you go to the errors of "Application"; and track down the
information of the PostgreSQL service.
In my experience (~ 200 different Windows Computers in ~15 Administrative
Environments)  the most common errors are:
- "something" is taking away the
"run-as-service"-privilege of the postgres-Windows-User. Likely
culprits for "something" are GroupPolicies within
ActiveDirectory. To be more challenging, it does not happen immediately,
but after x days of normal working
- "something" is taking away access rights to the PostgreSQL
Data Directory / the PostgreSQL Configuration files
- Switching distributions between versions (from pginstaller to one click
installer or vice versa)
- Difference within PostgreSQL packagings ("pg_debugger" was
default acitvated in 8.3.0-8.3.4; and is no more default activated by
default in 8.3.7; a line with "preload pg_debugger " in
postgresql.conf may lead to non starting PostgreSQL service)
- Some (anti)viral products block the access off ports; or files, or
starting of processes by Postgresql.
Most of these errors are best detected by checking the error log. (just
with AntiVir Products you're in the wild, most of the time. Check their
logfiles!)
Harald



On Thu, Apr 23, 2009 at 5:08 AM, Christine Penner
<christinep@telus.net>
wrote:

I get no error. The only way I know its not connected is by trying to
log in to pgAdmin. It tells me the server doesn't listen. Then I told it
to start. Last time that worked. Now it won't start at all but it never
gives any error.

When I tried to open it with pg_ctl it tells me can not open PID file
(Postmaster.pid). Permission denied. That's odd because I am an
administrative user on Vista and it was working at one point.

Should Postgres not be in the Program Files directory for Vista?
In any case how to I fix it. I want to at least get the data out so I
can re load it. I have a backup but its not as recent as I would
like.

Christine


At 10:46 PM 4/21/2009, you wrote:


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Christine Penner wrote:
> The following bug has been logged online:
>
> Bug reference:      4771
> Logged by:         
Christine Penner
> Email address:     
christinep@telus.net
> PostgreSQL version: 8.3.7
> Operating system:   Vista
> Description:        Postgres
wont start
> Details:
>
> I have had Postgres running and working on the computer for
about a month. A
> week ago I started and realized that the Postgres service was
not started. I
> started it and it worked fine. Today I started up and again
Postgres has not
> started. I have tried again and again to start it but it won't
start. I have
> restarted my computer 3 times, shut down programs running that
may interfere
> but still nothing.
>
> I can't find a log file that will give me more info on why it
won't start.
>

what is the Error you are getting ?

go to bin folder of postgres and try to start using pg_ctl

like :- pg_ctl -D  c:/postgres/8.3/...path upto data
folder  START








            &nb=
sp;            =
            &nb=
sp;      
--

            &nb=
sp;            =
            &nb=
sp;
regards,tushar

            &nb=
sp;            =
            &nb=
sp;
http://webeatoracle.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFJ7q9LfQNodY2PIRoRArjqAKCIfLk/392qYIn+cQY7iy23IPXNxQCgtetG
8Q7KHYTH/gcd3+WSQnCd/Zw=3D
=3D7r7H
-----END PGP SIGNATURE-----

__________ Information from ESET NOD32 Antivirus, version of virus
signature database 4029 (20090422) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




--=20
Sent via pgsql-bugs mailing list
(pgsql-bugs@postgresql.org
)
To make changes to your subscription:

http://www.postgresql.org/mailpref/pgsql-bugs


--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Stra=DFe 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?