Re: [pgadmin-support] Emergency - postgre is not working

Anika,

Sorry, I dont know what time zone you are in - I usually go to bed 4am and
> am up 8am in my timezone... I do not know programming AT ALL - just
> html.... I also dont know how to put the mail back on the list...sorry.
>

I am in CEST (central europe summer time) ... just giving that info, so you
do not panic if it takes time with the answer.

You can copy the mail to the list by hitting "reply all", or putting
additionally pgsql-general(at)postgresql(dot)org into the "to" field-

When I run the services(local) - there is a line for
> postgre SQL database - automatic(startup typle)automatic -(log on as)
> .\userpostgres90.
>

When I check the property of the line--this is what is on path to
executable:
>
> "C:\Program Files\PostgreSQL\8.0\bin\pg_ctl.exe" runservice -N "pgsql-8.0"
> -D "C:\Program Files\PostgreSQL\8.0\data\"
>

Okay, fine. You have a standard install on PostgreSQL 8.0

> When I try and start postgre from the services.msc page - I get the
> error1069 - could not start logon error.
>

Propblem gets clearer. I had similiar symptoms before; so my rough guess is:
your postgres user did loose a privilege.

Technical background:
the postgres-account is a low privileged user, which logs on automatically
when the service starts up. So he needs the privilege "log on as service"

And I think that your postgres account loosed that privilege.

So I recommend to try the following steps:

a) startup the Editor of user accounts (within control panel)
b) change the password of the postgres user account to something you know
c) restart services.msc, and open the Properties of the Postgres Services
d) go to the logon page, and enter the new password you just gave to this
account (step b)
e) try to start the service again from the service control panel

With entering the logon information again to the "logon-tab" of the service
properties dialog, you are re-giving that privilege.

Be aware that group policies within Windows Domains / Active Directory can
"take away" that privilige if not configured correctly! I do not know if you
are within Active Directory, if you are, speak to your ActiveDirectory
Adminstrator!

I use postgre to run Sam Broadcaster ..which runs 24/7 - but initally all I
> had to do was click on my sam icon and pow it starts - now even when I click
> on sam the new screen that pops up is run as..... with the choice of owner
> or other????
>

That seems totally unrelated to your postgresql error!

IS IT POSSIBLE TO UNINSTALL AND REINSTALL PostgreSQL WITHOUT DAMAGING THE
> INFORMATION ON SAMBC??? WOULD THIS FIX THE PROBLEM - SINCE IT IS A PROBLEM
> THAT I HAVE NEVER ENCOUNTERED BEFORE???
>

You can uninstall and reinstall postgresql. As long as you keep your data
directory, which is standard behaviour, the information is being kept. But I
DO NOT recommend to do that! And I am quite sure it would NOT fix this
problem; which is "outside" of PostgreSQL. It would be a different matter if
the service failed with something like "pg_ctl.exe not found"; but your
PostgreSQL installation seems fine.

Tried to help you online, but you were unavailable... no idea of your time
zone, though.

Good luck with the repair, and please keep us posted,

best wishes,

Harald

On 7/11/06, Harald Armin Massa <haraldarminmassa(at)gmail(dot)com> wrote:
> >
> > Hello Anika,
> >
> > please see that we are in different timezones, and I usually try to
> > sleep at night. Please also try to keep your mail on the list, so others can
> > try to help you as well.
> >
> > Now, dig deeper in the analyzis:
> >
> > 1st) Logon as Admin, checkout services.msc
> >
> > is there a postgres service running? If not, why not? Any messages
> > there? Try to start the service from service control panel. Check out system
> > event log, application event log.
> >
> > 2nd) where is your PostgreSQL data directory? in a standard installation
> > it is in <program files>\postgres\8.1\data
> >
> > there should be a log directory within, chechout what is in the youngest
> > logfiles. Maybe post it to the list.
> >
> > 3rd) Try to connect to postgres using psql; that is the command line
> > utilitie
> >
> > 4th) what is Postgresql used for on your computer? "sambc/core.xml" is
> > no application I know connected to "pgadmin". I forwarded your mail to the
> > postgres support list, because propably the problem is NOT connected to the
> > pg-admin
> >
> > Additional information: the password within the .xml file is most
> > propably the passwort for the user within the database. NOT the postgres
> > Service Account password. The password of the postgres account should be
> > irrelevant for you, since it is only used for the service to connec.t
> >
> > Best wishes,
> >
> >
> > Harald
> >
> >
> >
> >
> > On 7/11/06, anika evans <hianika(at)gmail(dot)com> wrote:
> > >
> > > HELLO!!
> > >
> > > I STILL NEED HELP -
> > > I removed norton internet security and norton goback - postgre sql
> > > still doesn't work!!!!!
> > >
> > > I need to get this thing running - asap - before my ass is fired!!
> > >
> > >
> > >
> > >
> > > On 7/10/06, anika evans <hianika(at)gmail(dot)com> wrote:
> > > >
> > > > Unfortunatly rolling back the update did not work - and adding port
> > > > 5432 did not work either.
> > > >
> > > > If I cant remove postgre - then what do I do??
> > > >
> > > > also, When I turn on the computer I have 2 accounts on windows ex -
> > > > the Owner (administrator) account and a postgre account - the postgre
> > > > acccount requires a password - unfortunatly when I get the password from
> > > > sambc/core.xml file - the password does not work.... HELP
> > > >
> > > > Thank you
> > > > Anika Evans
> > > > On 7/10/06, Harald Armin Massa <haraldarminmassa(at)gmail(dot)com > wrote:
> > > > >
> > > > > Anika,
> > > > >
> > > > > thanks for the complete error description, I bet the culprit is in
> > > > > here:
> > > > >
> > > > > >
> > > > > > I recently updated my norton anti-virus and norton goback - and
> > > > > > up until then - everything for my sambc was working fine now when I try and
> > > > > > open sambc and I received the error message:
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > X 2006-07-09 22:09:19 [CORE] Connection to database failed (could
> > > > > > not connect to server: Connection refused (0x0000274D/10061)
> > > > > > Is the server running on host "localhost" and accepting
> > > > > > TCP/IP connections on port 5432?
> > > > > >
> > > > >
> > > > > We had many times trouble with antivirus and similiar products
> > > > > interfering with the connections between pgadmin / psql and the Postrges
> > > > > Server.
> > > > >
> > > > > I recommend to NOT remove the postgres account!!
> > > > >
> > > > > Please try to configure Norton whatever to allow connections on
> > > > > Port 5432. Or roll back that update.
> > > > >
> > > > >
> > > > > Best wishes,
> > > > >
> > > > > Harald
> > > > >
> > > > >
> > > > > --
> > > > > GHUM Harald Massa
> > > > > persuadere et programmare
> > > > >
> > > > > Harald Armin Massa
> > > > > Reinsburgstraße 202b
> > > > > 70197 Stuttgart
> > > > > 0173/9409607
> > > > > -
> > > > > on different matter:
> > > > > EuroPython 2006 is over. It was a GREAT conference. If you missed
> > > > > it, now you can prepare budget for visiting EuroPython 2007.
> > > > >
> > > >
> > > >
> > >
> >
> >
> > --
> > GHUM Harald Massa
> > persuadere et programmare
> > Harald Armin Massa
> > Reinsburgstraße 202b
> > 70197 Stuttgart
> > 0173/9409607
> > -
> > on different matter:
> > EuroPython 2006 is over. It was a GREAT conference. If you missed it,
> > now you can prepare budget for visiting EuroPython 2007.
> >
>
>

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
on different matter:
EuroPython 2006 is over. It was a GREAT conference. If you missed it, now
you can prepare budget for visiting EuroPython 2007.