Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7

On Wed, Apr 20, 2011 at 8:39 PM, Mlondolozi Ncapayi <mlondza(at)gmail(dot)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 <raghuchennuru(at)gmail(dot)com>wrote:
>
>>
>>
>> On Wed, Apr 20, 2011 at 12:32 PM, Mlondolozi Ncapayi <mlondza(at)gmail(dot)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
>>>
>>>
>>>
>>
>>
>