On Wed, Apr 20, 2011 at 8:39 PM, Mlondolozi Ncapayi <mlondza@xxxxxxxxx> wrote:
1)Convert shp to sql
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 workshp2pgsql cities.shp public.cities cities.sql followed by psql -d template_postgis14 -f cities.sql -U postgres
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@xxxxxxxxx> wrote:
Please go to the postgresql server installation directory and here you will find one uninstall-postgresql file.On Wed, Apr 20, 2011 at 12:32 PM, Mlondolozi Ncapayi <mlondza@xxxxxxxxx> wrote:
Hi thereI 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.
-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 RamMlo
