473,320 Members | 1,982 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Pgsql 8.4 on Vista starts and stops automatically.

2
I am having the same problem as experienced in http://www.thescripts.com/forum/thread422776.html


Here's a short excerpt of that discussion:
========
> But after a few days, when I tried to continue with my tests.
> I cannot start the postgresql service. I always get this
> message windown when I try to start the service:
>
> "The postgresql service on the local computer started and
> stopped. some services stop automatically if they have no
> work to do, for example the performance logs and alerts services"
>
> The service starts and stops automatically and I cannot to
> work with pgsql.
>
> PS: I have translated (get from internet) the text message
> window because I have my system in spanish language.[/color]

This looks a lot like the postmaster.pid issue. Look in your DATA
directory, and remove that file if it exists.

If not, then it's a different issue. In this case, edit the
postgresql.conf file and set log_destination to include eventlog, then
look at eventlog output. (This is an issue with the installer that will
be fixed in the next beta release)
===========

This user was successful in solving the problem by deleteing the postmaster.pid file. I did a search on my Vista PC, and that file does not exist.

I'm guessing that this is an issue with Vista and PGsql wanting to write to the Program Files filder.

Any ideas?

Thanks,
Rocky
Jul 10 '07 #1
3 5976
rockyp
2
Of course, that's 8.2.4... :-)
Jul 10 '07 #2
michaelb
534 Expert 512MB
Did you see any relevant messages in the postgresql log or windows event log?
Jul 14 '07 #3
Windows Postgres service starts and stops.

I was getting a similar error on a Windows 2003 Server and solved it (I think!) at least I was able to get the service to start. What is the user that the service logon is connecting as? mine was set to postgres (I used the defaults) but I know that my postgres logon doesn't have full admin rights, so I changed it to Local System account and it let me start the service.

I will check and see if everything else seems to be in order.
Jun 26 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Rajesh Kumar Mallah | last post by:
Hi, We need to implement following logic efficiently. SELECT * from some_table where .... IF rows_matched = 1 THEN use the single row that matched.
0
by: Eugene | last post by:
I have two window services that I created in C# and VB.net, one each, and set them to manual startup type. However, sometimes (not everytime) when I starts the service, an error message pops-up to...
5
by: Daniel Baughman | last post by:
My pgsql service keeps dieing and has a bunch of errors like this in the server log, eventually it stops giving these Warning: terminatin connection because of crash of another server process...
0
by: Terry Yapt | last post by:
Hello all, I am testing PostgreSQL 8.0 beta on a windows xp professional. In the time when I did the install I have been working with pgadmin and so on... But after a few days, when I tried...
11
by: Don | last post by:
QUESTIONS: 1. Has anyone figured out how to successfully install the Office 97 Pro Service Release 2 patch in Vista? 2. Has anyone successfully installed an Office 97 Pro CD (SR2 version) in...
0
by: =?Utf-8?B?YnZkYWhs?= | last post by:
Hello, I wasn't sure where to pose this question, so please forgive me if this is not the right place to do so. Has anyone come across the following problem? We are making a client/server...
5
Atli
by: Atli | last post by:
Hi. I'm currently using Vista Ultimate on my Acer laptop just to test it, and now the 30 day activation period is almost up and I'm trying to switch back to XP. Not that I dont like Vista. I seem...
4
by: =?Utf-8?B?Q2FybGFKYWRl?= | last post by:
Can anyone help me? I need to use picture it 2000 every day and use to use it on Windows XP and had NO problems at all. If I would open up windows explorer i could be in my folder that has all of...
7
by: TheDude5B | last post by:
Hi, I have just installed Visual Studio 2005 on my windows Vista machine, and everything seems to work well after installing the service pack and then the vista upgrades. However, when I try...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.