| Author |
Message |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 14 Aug 2009 01:27:20
|
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 |
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 14 Aug 2009 06:47:51
|
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
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 14 Aug 2009 06:54:42
|
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 |
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 14 Aug 2009 07:51:29
|
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...
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 20 Oct 2009 12:07:40
|
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.
|
|
|
 |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 7 Jun 2011 02:24:16
|
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
|
|
|
 |
|
|