Search Postgresql Archives

Re: Re-Install data folder failure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Apr 20, 1:29 pm, ray <Ray.Jos...@xxxxxxxxxxx> wrote:
> I have been having troubles getting 8.3 running on Windows XP.  My
> last couple of attempts have been to install 8.3 in a folder off the
> root rather than off of 'Program Files'.  Since I ‘uninstalled’ it, I
> have not been able to get a good installation.  I have tried many
> times.  I use Control Panels Add&Remove to remove 8.3 and then I go
> through the registry and remove any remaining entries tjat address
> 'postgres'.  When I start a new install, it always points to c:
> \program files\postg… which I change on the setup page to the new c:
> \pghome.  I have a leftover environmental variable pgdata which points
> to c:\pghome\8.3\data.  But this folder never gets built anymore.
> That is, there is not data folder.
>
> Any ideas on how I can get this built?
>

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


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux