EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Trouble with the Windows installer  XML

Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Author Message
Ashesh_V

Senior member

Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline

I think - you should to reinstall the PostgreSQL again.

Can you please follow these steps:
* Uninstall Currently installed PostgreSQL.
NOTE:
- Delete the data directory.
rd /s /q "D:\Program Files\PostgreSQL\8.4\data"
- But, do not delete the 'postgres' user
* Create folder D:\PostgreSQL
mkdir D:\PostgreSQL
* Create folder D:\PostgreSQL\8.4
mkdir D:\PostgreSQL\8.4
* Give full permission for D:\PostgreSQL\8.4 to postgres user
cacls D:\PostgreSQL /E /T /G MENTATASSASSIN\postgres:F
* Install the PostgreSQL @ D:\PostgreSQL\8.4 (instead of D:\Program Files\PostgreSQL\8.4)

This should resolve all the problem.

This message was edited 1 time. Last update was at 14 Aug 2009 04:01:53


Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company
mentatd_attglobal_net

Member

Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline

I accidentally deleted the postgres user before the installation, but did the rest the way that was suggested. I got the error as before, but immediately ran the permissions that you had given me and mapped the postgres user, then started the service and it started. now the servie is running, but the PGAdmin III cannoot connect tothe database because it says that it cannot resolve the loca host name... We seem to be making porgress! I have to be off to a meeting for about 30 minutes, but will be back, if you are willing to look back on me.

This message was edited 1 time. Last update was at 14 Aug 2009 06:50:41

Ashesh_V

Senior member

Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline

It happens sometimes. Windows do not able to find the ip address for the 'localhost'.
You may need to change 'localhost' to '127.0.0.1'.

It should work.

This message was edited 1 time. Last update was at 14 Aug 2009 06:55:52


Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company
mentatd_attglobal_net

Member

Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline

That worked! It seems that you got me up and running...
Keith_Mashinter

New member

Joined: 20 Oct 2009 12:03:05
Messages: 1
Offline

I had a similar problem with the clusterdb failing to be created, and thus the service failing to install.

My workaround was to:
1. Use the existing or manually create the "postgres" user and add it to the local computer Administrator group.
2. Start/Run: runas /user:postgres cmd.exe
3. Enter the password for the postgres user.
4. CD /D "to the directory with the EXE installer"
5. Run the EXE installer from the cmd.exe window as postgres.

You can also try just using RunAs... from right-clicking on the EXE if that's available.

It installed properly, and then I removed "postgres" from the Administrators group and added to the Power Users group.
vujucyop

Member

Joined: 4 Jun 2011 05:41:26
Messages: 12
Offline

The window system download often unsteady. I'm tired with it and decided to get a genuine.




work hard play hard
louis vuitton handbags on sale

This message was edited 1 time. Last update was at 7 Jun 2011 02:25:05

 
Forum Index » PostgreSQL Installers for Windows, Linux and OS X
Go to:   
Powered by JForum 2.1.8 © JForum Team