From: | raghu ram <raghuchennuru(at)gmail(dot)com> |
---|---|
To: | Mlondolozi Ncapayi <mlondza(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] How to uninstall PostgreSQL 8.4 on both Windows XP and Windows 7 |
Date: | 2011-04-20 15:52:09 |
Message-ID: | BANLkTimuX8MyT_6ENg00jOZ_dbr85zU1=w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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
>>>
>>>
>>>
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2011-04-20 15:57:35 | Re: database system identifier differs between the primary and standby |
Previous Message | Kevin Grittner | 2011-04-20 14:49:05 | Re: Orphan Temp Table After PITR |
From | Date | Subject | |
---|---|---|---|
Next Message | raghu ram | 2011-04-20 15:57:18 | Re: How to realize ROW_NUMBER() in 8.3? |
Previous Message | Jorge Arévalo | 2011-04-20 15:51:46 | Re: Join query including two generate_series calls causes big memory growth and crash |