Re: [pgadmin-support] Emergency - postgre is not working - Mailing list pgsql-general
| From | Harald Armin Massa |
|---|---|
| Subject | Re: [pgadmin-support] Emergency - postgre is not working |
| Date | |
| Msg-id | 7be3f35d0607110814j5ac4ec1cl37cd05ca2e3ebd0e@mail.gmail.com Whole thread Raw |
| In response to | Re: [pgadmin-support] Emergency - postgre is not working ("Harald Armin Massa" <haraldarminmassa@gmail.com>) |
| Responses |
Re: [pgadmin-support] Emergency - postgre is not working
("Merlin Moncure" <mmoncure@gmail.com>)
|
| List | pgsql-general |
Anika,
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@postgresql.org into the "to" field-
When I check the property of the line--this is what is on path to executable:
Okay, fine. You have a standard install on PostgreSQL 8.0
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!
That seems totally unrelated to your postgresql error!
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
--
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.
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@postgresql.org into the "to" field-
When I run the services(local) - there is a line forpostgre SQL database - automatic(startup typle)automatic -(log on as) .\userpostgres90.
"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@gmail.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,
HaraldOn 7/11/06, anika evans <hianika@gmail.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@gmail.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.... HELPThank youAnika EvansOn 7/10/06, Harald Armin Massa <haraldarminmassa@gmail.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.
pgsql-general by date: