On Wed, Apr 20, 2011 at 8:39 PM, Mlondolozi Ncapayi <mlon...@gmail.com>wrote:
> Thank Sir, I have managed to uninstall it. > Now I installed PostgreSQL 8.4.4 and PostGIS 1.4.2. > > Can you please send me command prompts to load shapefiles using Windows 7. > > I want to load cities.shp into template_postgis14 [dbname] > > This command does not work > > shp2pgsql cities.shp public.cities cities.sql followed by psql -d > template_postgis14 -f cities.sql -U postgres > > > 1)Convert shp to sql user> shp2pgsql -s 4326 test_AK.shp mp_census_block > mp_census_block.sql 2)Insert into the database user> psql -U test -d DatabaseName -f mp_census_block.sql --Raghu Ram > > On Wed, Apr 20, 2011 at 4:31 PM, raghu ram <raghuchenn...@gmail.com>wrote: > >> >> >> On Wed, Apr 20, 2011 at 12:32 PM, Mlondolozi Ncapayi <mlon...@gmail.com >> > wrote: >> >>> Hi there >>> >>> I installed PostgreSql 8.4 and now I want to delete/ uninstall it >>> completely to start a new fresh installation. >>> Can you please give me clear instructions on how to do that or maybe a >>> script that I can run. >>> I am doing assignment using postgres your help would be highly >>> appreciated. >>> >> >> >> Please go to the postgresql server installation directory and here you >> will find one uninstall-postgresql file. >> >> -double click on Uninstall-postgresql file to run the un-installer- it >> will un-install postgresql. >> >> >> II)Also you can un-install it manually.Below are the steps to un-install >> postgresql 8.4 manually- >> >> >> >> i) Remove the postgresql server installation directory. (rd /s /q >> "C:\Program Files\PostgreSQL\8.4") Assuming default location. >> >> ii) Delete the user 'postgres' (net user postgres /delete) >> >> iii) Remove the Registry entries. (HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL >> \Installations\postgresql-8.4) and (HKEY_LOCAL_MACHINE\SOFTWARE\ >> PostgreSQL\Services\postgresql-8.4) >> >> iv) Remove the postgresql-8.4 service. (sc delete postgresql-8.4) >> >> >> >> This will completely remove your PostgreSQL 8.4 installation including >> user and installation directories. >> >> --Raghu Ram >> >> >> >>> >>> Mlo >>> >>> >>> >> >> >
