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
