Re: Part way there, how do I complete it

From: ray <Ray(dot)Joseph(at)CDICorp(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Part way there, how do I complete it
Date: 2009-04-15 22:50:33
Message-ID: dc1f1667-6978-4d0a-ad20-7198d2f2c6fa@g37g2000yqn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Apr 15, 4:17 pm, ray <Ray(dot)Jos(dot)(dot)(dot)(at)CDICorp(dot)com> wrote:
> On Apr 15, 3:15 pm, ray <Ray(dot)Jos(dot)(dot)(dot)(at)CDICorp(dot)com> wrote:
>
> > I have just installed pgsql on a Windows XP from my administrator
> <snip>

I closed down everything and tried to start back up and failed. From
pgAdmin, there is a red 'x' in the icon for my new server. When I try
to connect to the server I get an error message entitled "Server
doesn't listen". In a command window, I have this interaction:

C:\Program Files\PostgreSQL\8.3\bin>"pg_ctl" -D "Files/PostgreSQL/8.3/
data" -l logfile start
server starting

C:\Program Files\PostgreSQL\8.3\bin>pg_ctl stop -m fast
pg_ctl: PID file "C:/Program Files/PostgreSQL/8.3/data/postmaster.pid"
does not exist
Is server running?

The Properties tab shows:
Connected? No

So it looks like neither method works now. The log file contains:
postgres cannot access the server configuration file "C:/Program Files/
PostgreSQL/8.3/bin/Files/PostgreSQL/8.3/ data/postgresql.conf": No
such file or directory

It looks like there are two problems here:
1) The part of the string /8.3/ data/ has a space in it before
'data'. The actual path does not. I don't know how to get it pointed
to the right location.
2) There seems to be redundant locations. I also have that same conf
file in: C:\Program Files\PostgreSQL\8.3\data
I think this later location is correct. Should I try to point it in
the right direction (how?) or should I attempt to reinstall the whole
thing?

I would appreciate any comments.

Thanks,
Ray

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2009-04-15 22:53:06 Re: PITR - warm standby switchover question
Previous Message Michal Politowski 2009-04-15 22:27:36 Re: (P)SQL for a sum with constraints