Обсуждение: Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7

Поиск
Список
Период
Сортировка

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

От
raghu ram
Дата:


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

 
 
Mlo
 
 

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

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


 
 
On Wed, Apr 20, 2011 at 4:31 PM, raghu ram <raghuchennuru@gmail.com> wrote:


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

 
 
Mlo