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

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.

Mlo

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
>
>
>

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
>>>
>>>
>>>
>>
>>
>

Mlondolozi Ncapayi <mlondza(at)gmail(dot)com> wrote:

> 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.

That's going to depend entirely on how you installed it, which is
something you didn't tell us. Did you build from source, use a
one-click installer, or something else? Details like exact version
number, the URL from which you got the software, etc., would help.

-Kevin