Hello all,
I have a windows postgres 9.0.1 installation which doesn't start, and also
doesn't log any information. The only evidence that an attempt was made is
in the event log with the following pair of messages :
1. Waiting for server startup...
2. Timed out waiting for server startup
I've tri
Joe Carr wrote on 18.10.2010 23:11:
Hello all, I have a windows postgres 9.0.1 installation which doesn't
start, and also doesn't log any information. The only evidence that
an attempt was made is in the event log with the following pair of
messages :
1. Waiting for server startup... 2. Timed ou
I would go with the permissions issue. Not all postgres startup
problems are logged in pg_log. Go check the Application log: right
click on Computer -> Manage -> Events -> Application and look for any
errors with PG as a source. It may be connected to the fact that
somehow postgres user doesn't hav
Hi Thomas,
Thanks for your reply. pg_ctrl has given me some more information, but I'm
not quite there yet.
I have verified that the postgres user has "full control" access to the data
directory.
When I take the commandline from the service definition and execute it, I
get the following:
C:\Progr
I'm having the same problem - and have checked the application log and yes
the problem seems to be that postgres user doesn't have permission to write
postmaster.pid file. What is the solution to this?
Regards
Tracey
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make
"Tracey Osborne" writes:
> I'm having the same problem - and have checked the application log and yes
> the problem seems to be that postgres user doesn't have permission to write
> postmaster.pid file. What is the solution to this?
Did you run initdb as the postgres user? Seems like you migh
Joe,
I'm seeing the exact same thing when I do a fresh installation of Postgres
9.0 on either a 2008 installation or a 2003 installation. In both cases I
ensure the entire directory structure is owned by postgres and I've even
made postgres a member of the local Administrators group with the sam
Joe Carr wrote on 19.10.2010 00:55:
Hi Thomas, Thanks for your reply. pg_ctrl has given me some more
information, but I'm not quite there yet.
I have verified that the postgres user has "full control" access to
the data directory.
When I take the commandline from the service definition and exec
Not sure if this helps, but the Services dialogue I get now is:
"The postgresql-9.0 - PostGreSQL Server 9.0 service on Local Computer
started and then stopped. Some services stop automatically if they have no
work to do, for example, the Performance Logs and Alerts service."
In my case it start
100-eti <100-...@csc-scc.gc.ca> wrote:
> Not sure if this helps, but the Services dialogue I get now is:
>
> "The postgresql-9.0 - PostGreSQL Server 9.0 service on Local
> Computer started and then stopped. Some services stop
> automatically if they have no work to do, for example, the
> Perfor
That's the problem though... I've searched through all the PostgreSQL
directories, and there are no logs that indicate anything.
Next step is to try this on CentOS as it seems the Windows implementation is
broken or at least I can't seem to get it going (yet).
--
View this message in context:
h
admin@postgresql.org
Sent: Tuesday, November 30, 2010 11:29:17 AM
Subject: Re: [ADMIN] Postgres service won't start, doesn't log any errors
That's the problem though... I've searched through all the PostgreSQL
directories, and there are no logs that indicate anything.
Next
;100-...@csc-scc.gc.ca>
> To: pgsql-admin@postgresql.org
> Sent: Tuesday, November 30, 2010 11:29:17 AM
> Subject: Re: [ADMIN] Postgres service won't start, doesn't log any errors
>
>
> That's the problem though... I've searched through all the PostgreSQL
100-eti <100-...@csc-scc.gc.ca> wrote:
> I've searched through all the PostgreSQL directories, and there
> are no logs that indicate anything.
Have you checked the event viewer for application entries?
> Next step is to try this on CentOS as it seems the Windows
> implementation is broken or
There was no server log anywhere, there were no entries in the Event Viewer
(under Application, Security or System) and I ensured the entire directory
structure is set to Full Control for the user (and the user is in the local
Administrators group)... Nothing other than the service its trying to
Got the CentOS version up and running, but I am going to use the windows
version only for the admin client and connect across the network...
The last message I got in the Windows install is Error initializing Cluster
configuration... This might be a direct cause of the initial problem :-)
Roge
I had the same problem. in my case, I changed the user account to the user
who was logged on the local system at the time (which has administrator
privileges). I did this by accessing the service properties, Logon tab, as
shown:
http://postgresql.1045698.n5.nabble.com/file/n4814207/img.png
After
On Tue, Nov 30, 2010 at 10:37 AM, 100-eti <100-...@csc-scc.gc.ca> wrote:
>
> There was no server log anywhere, there were no entries in the Event Viewer
> (under Application, Security or System) and I ensured the entire directory
> structure is set to Full Control for the user (and the user is in t
18 matches
Mail list logo