Skip site navigation (1) Skip section navigation (2)

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-21 14:26:13
Message-ID: 89edc787-623a-4d15-8589-b10991a18537@q14g2000vbn.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
On Apr 16, 1:35 pm, ray <Ray(dot)Jos(dot)(dot)(dot)(at)CDICorp(dot)com> wrote:
> On Apr 15, 5:50 pm, ray <Ray(dot)Jos(dot)(dot)(dot)(at)CDICorp(dot)com> wrote:> On Apr 15, 4:17 pm, ray <Ray(dot)Jos(dot)(dot)(dot)(at)CDICorp(dot)com> wrote:
>
> I am trying to re-installed PostgreSQL.  I have chosen a different
> process.  I am installing it as a service.  After much time at the
> 'Starting Services' window, it says that I have insufficient
> previleges to start services.  I am an administrator on the machine
> and I start and stop services.
>
> Any ideas what may be going wrong and what I might do to get them
> working?
>
> Ray


The method I used to resolve this was to:
1)  Use Control Panel to Remove the previous installation.  It left
behind the 'data' folder.
2)  Install with the msi file choosing not to install as a service.
3)  After installation was complete, the log stated:
 MSI (c) (38:10) [07:57:45:317]: Product: PostgreSQL 8.3 --
Installation completed successfully.
4)  I set the environment variable 'LD_LIBRARY_PATH' to 'C:\pgHome
\8.3\lib'.
5)  Set the environment variable PGDATA to 'C:\pgHome\8.3\data'.
6)  Renamed the old 'data' folder to 'data_old'.
7)  From the command prompt, I executed 'initdb' with no parameters
allowing PGDATA to drive the location, which responded with:
  Success. You can now start the database server using: . . .
8)  Executed:  'pg_ctl -l firstlogfile.txt start' which produced a
logfile in the bin folder (from where the command was issued).
9)  Executed 'createdb' to produce a new database under my logon name.
10)  From pgAdmin3, the new server was visible.
11)  From pgAdmin3, I set 3 more connections which established 3
servers.
12)  From pgAdmin3, I dropped the original server setup from the
command line.
13)  Each server has 2 databases: postgres and myname.

Now, if I can just find out if these are persistant and useful . . .

Ray

In response to

pgsql-general by date

Next:From: Alvaro HerreraDate: 2009-04-21 14:29:29
Subject: Re: This is my first template
Previous:From: rayDate: 2009-04-21 14:25:11
Subject: Re: Re-Install data folder failure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group