How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7

On Wed, Apr 20, 2011 at 12:32 PM, Mlondolozi Ncapayi <mlondza@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

On Wed, Apr 20, 2011 at 8:39 PM, Mlondolozi Ncapayi <mlondza@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

Mlondolozi Ncapayi <mlondza@gmail.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