| Author |
Message |
![[Post New]](/templates/default/images/icon_minipost_new.gif) 10 Aug 2009 01:09:58
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline
|
What is the content of the batch file?
Where is your PostgreSQL installed (Absoute path where PostgreSQL is installed)?
I can see typo in your commands... (You've used '|' instead of '\' at one place).
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
 |
10 Aug 2009 15:25:13
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
THe Batch file:
@ECHO OFF
REM Start PostgreSQL manually
"C:\Program Files\PostgreSQL\8.4\bin\pg_ctl.exe" -D "C:\Program Files\PostgreSQL\8.4\data" -w start -l "c:\Program Files\PostgreSQL\8.4\data\pg_log\run.log"
ECHO Wait for some time and then...
pause
"C:\Program Files\PostgreSQL\8.4\bin\pg_ctl.exe" -D "C:\Program Files\PostgreSQL\8.4\data" -w stop -l "c:\Program Files\PostgreSQL\8.4\data\pg_log\run.log"
REM Wait to see the actual message from pg_ctl
pause
Postgres is on D: thata may be the problem with the batch. i thought that I had corrected that...
I do not see the other typo.
|
|
|
|
10 Aug 2009 16:55:12
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
I retried all of the actions again with the following results:
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>sc query postgresql-8.4
SERVICE_NAME: postgresql-8.4
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED
(NOT_STOPPABLE,NOT_PAUSABLE,IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 0 (0x0)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>sc start postgresql-8.4
[SC] StartService FAILED 5:
Access is denied.
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>sc stop postgres-8.4
[SC] OpenService FAILED 1060:
The specified service does not exist as an installed service.
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>cacls C:\ptest.bat /E /G MENTA
TASSASSIN\postgres:F
No mapping between account names and security IDs was done.
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>cacls C:\ptest.bat /E /G MENTA
TASSASSIN3\postgres:F
processed file: C:\ptest.bat
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>runas /env /user:MENTATASSASSI
N3\postgres C:\ptest.bat
Enter the password for MENTATASSASSIN3\postgres:
Attempting to start C:\ptest.bat as user "MENTATASSASSIN3\postgres" ...
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>
A command window opened for ptest.bat and at both pauses said "access denied".
This is the newest post along with the one directly above it.
This message was edited 1 time. Last update was at 11 Aug 2009 06:00:26
|
|
|
|
12 Aug 2009 11:27:59
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline
|
Hi,
Two more questions. 
Please send me output of the following two questions.
* net user
* cacls "D:\Program Files\PostgreSQL\8.4\data"
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
|
12 Aug 2009 12:53:33
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline
|
Looks like - something goes wrong while installation and postgres user was not given the proper permission to access it. 
Run this command on your PostgreSQL data directory.
cacls "D:\Program Files\PostgreSQL\8.4\data" /T /E /G MENTATASSASSIN3\postgres:F
Hope this works.
Please convey message, if this helps.
This message was edited 2 times. Last update was at 12 Aug 2009 15:13:30
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
|
12 Aug 2009 17:05:15
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>net user
User accounts for \\MENTATASSASSIN3
-------------------------------------------------------------------------------
Administrator ASPNET DCTIIIMD
Guest HelpAssistant Mentatd
postgres SUPPORT_388945a0
The command completed successfully.
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>cacls "D:\Program FIles\Postgr
eSQL\8.4\data"
D:\Program FIles\PostgreSQL\8.4\data MENTATASSASSIN3\Mentatd:F
NT AUTHORITY\SYSTEM:F
MENTATASSASSIN3\postgresOI)(CI)F
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>
the results of the second directive:
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2830
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2831
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2832
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2833
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2834
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2835
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2836
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2837
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2838
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2838_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2838_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2839
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2840
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2840_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2840_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\2841
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3501
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3502
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3503
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3600
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3600_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3600_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3601
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3601_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3601_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3602
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3602_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3602_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3603
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3603_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3603_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3604
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3605
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3606
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3607
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3608
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3609
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3712
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3764
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3764_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3764_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3766
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\3767
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\548
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\549
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11563\PG_VERSION
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\112
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\113
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11447
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11447_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11447_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11449
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11451
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11452
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11452_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11452_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11454
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11456
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11457
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11457_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11457_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11459
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11461
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11462
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11462_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11462_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11464
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11466
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11467
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11467_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11467_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11469
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11471
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11472
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11472_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11472_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11474
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11476
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11477
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11479
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\11481
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1247
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1247_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1247_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1249
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1249_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1249_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1255
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1255_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1255_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1259
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1259_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1259_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1417
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\1418
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\174
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\175
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2328
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2600
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2600_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2600_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2601
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2601_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2601_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2602
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2602_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2602_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2603
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2603_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2603_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2604
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2605
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2605_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2605_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2606
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2606_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2606_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2607
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2607_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2607_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2608
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2608_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2608_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2609
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2609_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2609_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2610
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2610_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2610_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2611
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2612
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2612_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2612_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2613
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2614
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2615
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2615_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2615_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2616
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2616_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2616_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2617
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2617_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2617_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2618
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2618_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2618_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2619
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2619_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2619_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2620
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2620_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2620_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2650
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2651
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2652
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2653
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2654
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2655
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2656
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2657
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2658
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2659
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2660
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2661
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2662
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2663
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2664
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2665
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2666
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2667
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2668
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2669
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2670
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2673
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2674
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2675
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2678
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2679
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2680
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2681
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2682
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2683
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2684
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2685
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2686
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2687
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2688
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2689
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2690
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2691
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2692
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2693
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2696
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2699
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2701
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2702
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2703
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2704
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2753
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2753_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2753_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2754
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2755
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2756
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2757
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2830
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2831
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2832
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2833
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2834
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2835
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2836
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2837
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2838
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2838_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2838_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2839
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2840
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2840_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2840_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\2841
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3501
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3502
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3503
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3600
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3600_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3600_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3601
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3601_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3601_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3602
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3602_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3602_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3603
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3603_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3603_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3604
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3605
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3606
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3607
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3608
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3609
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3712
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3764
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3764_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3764_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3766
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\3767
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\548
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\549
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\pg_internal.init
processed file: D:\Program Files\PostgreSQL\8.4\data\base\11564\PG_VERSION
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1136
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1136_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1136_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1137
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1213
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1213_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1213_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1214
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1214_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1214_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1232
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1233
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1260
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1260_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1260_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1261
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1262
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1262_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\1262_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2396
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2396_fsm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2396_vm
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2397
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2671
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2672
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2676
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2677
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2694
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2695
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2697
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2698
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2842
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2843
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2844
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2845
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2846
processed file: D:\Program Files\PostgreSQL\8.4\data\global\2847
processed file: D:\Program Files\PostgreSQL\8.4\data\global\config_exec_params.n
ew
processed file: D:\Program Files\PostgreSQL\8.4\data\global\pg_auth
processed file: D:\Program Files\PostgreSQL\8.4\data\global\pg_control
processed file: D:\Program Files\PostgreSQL\8.4\data\global\pg_database
processed file: D:\Program Files\PostgreSQL\8.4\data\pg_clog\0000
Access is denied.
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>
|
|
|
|
12 Aug 2009 17:10:36
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline
|
Now,
Can you try to run that batch file, that we created earlier? (as a 'postgres' user - using runas command)
Are you still getting the error "Access Denied"?
This message was edited 1 time. Last update was at 12 Aug 2009 17:16:01
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
|
12 Aug 2009 17:27:43
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
The ptest.bat box opens, but access is denied.
|
|
|
|
12 Aug 2009 17:48:59
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline
|
Let's init the database from the scratch and see what happens..
Can you create new batch file like this?
------------------------ start --------------------------------------------------------
@ECHO OFF
REM Initialize PostgreSQL database
"D:\Program Files\PostgreSQL\8.4\bin\initdb.exe" -D "D:\Program Files\PostgresQL\8.4\data1"
ECHO Wait for some time and then...
pause
------------------------ end --------------------------------------------------------
Now, run it as postgres user (using runas command)..
Then, modify your ptest.bat file - replace "D:\Program Files\PostgreSQL\8.4\data" to "D:\Program Files\PostgreSQL\8.4\data1"
And, run it as a postgres user.
This message was edited 1 time. Last update was at 12 Aug 2009 17:51:15
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
|
12 Aug 2009 19:25:03
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>c:\pinit.bat
The files belonging to this database system will be owned by user "Mentatd".
This user must also own the server process.
The database cluster will be initialized with locale English_United States.1252.
The default database encoding has accordingly been set to WIN1252.
The default text search configuration will be set to "english".
creating directory D:/Program Files/PostgresQL/8.4/data1 ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in D:/Program Files/PostgresQL/8.4/data1/base/1 ...
ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.
Success. You can now start the database server using:
"D:\Program Files\PostgreSQL\8.4\bin\postgres" -D "D:/Program Files/Postgres
QL/8.4/data1"
or
"D:\Program Files\PostgreSQL\8.4\bin\pg_ctl" -D "D:/Program Files/PostgresQL
/8.4/data1" -l logfile start
Wait for some time and then...
Press any key to continue . . .
Terminate batch job (Y/N)? n
Original ptest:
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>runas /env /user:MENTATASSASSI
N3\postgres c:\ptest.bat
Enter the password for MENTATASSASSIN3\postgres:
Attempting to start c:\ptest.bat as user "MENTATASSASSIN3\postgres" ...
Modified ptest:
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>runas /env /user:MENTATASSASSI
N3\postgres c:\ptest.bat
Enter the password for MENTATASSASSIN3\postgres:
Attempting to start c:\ptest.bat as user "MENTATASSASSIN3\postgres" ...
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>
both ptest runs gave access denied
|
|
|
|
12 Aug 2009 23:40:52
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline
|
little mistake made here
Please remove the new "data1" directory.
In fact, you should have run the pinit.bat as a postgres user.
i.e. runas /env /user:MENTATASSASSIN3\postgres c:\pinit.bat
And, then use ptest.bat as 'postgres' user.
i.e. runas /env /user:MENTATASSASSIN3\postgres c:\ptest.bat
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
|
13 Aug 2009 05:38:49
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>runas /env /user:MENTATASSASSI
N3\postgres c:\pinit.bat
Enter the password for MENTATASSASSIN3\postgres:
Attempting to start c:\pinit.bat as user "MENTATASSASSIN3\postgres" ...
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>runas /env /user:MENTATASSASSI
N3\postgres c:\ptest.bat
Enter the password for MENTATASSASSIN3\postgres:
Attempting to start c:\ptest.bat as user "MENTATASSASSIN3\postgres" ...
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>
 got access denied on both still...
|
|
|
|
13 Aug 2009 06:13:19
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
Is there a possibility that this is a password problem. if so, can we change it? also, why does the program say that the process belongs to mentatd?
|
|
|
|
13 Aug 2009 08:18:33
|
Ashesh_V
Senior member
Joined: 21 Dec 2008 00:54:03
Messages: 205
Offline
|
It seems - it is not password issue but the access control.
Because if it is password issue, it should have shout while running runas program and will not the program get started at all...
Can you please give the output of the following commands:
cacls "D:\Program Files\"
cacls "D:\Program Files\PostgreSQL\"
cacls "D:\Program Files\PostgreSQL\8.4"
This will help us to understand - how the access control is distributed over the hierarchy..
|
Thanks & Regards,
Ashesh Vashi
EnterpriseDB INDIA - The Enterprise Postgres Company |
|
|
|
13 Aug 2009 11:57:59
|
mentatd_attglobal_net
Member
Joined: 4 Aug 2009 21:25:52
Messages: 29
Offline
|
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>cacls "D:\Program Files\"
D:\Program Files MENTATASSASSIN3\Mentatd:F
NT AUTHORITY\SYSTEM:F
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>cacls "D:\Program Files\{ostgr
eSQL\"
The system cannot find the file specified.
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>cacls "D:\Program Files\Postgr
eSQL\"
D:\Program Files\PostgreSQL MENTATASSASSIN3\Mentatd:F
NT AUTHORITY\SYSTEM:F
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>cacls "D:\Program Files\Postgr
eSQL\8.4\"
D:\Program Files\PostgreSQL\8.4 MENTATASSASSIN3\Mentatd:F
NT AUTHORITY\SYSTEM:F
C:\Documents and Settings\Mentatd.MENTATASSASSIN3>
|
|
|
|
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 |
|
|
|
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
|
|
|
|
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 |
|
|
|
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...
|
|
|
|
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.
|
|
|
|
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
|
|
|
|
|
|
![[Search]](/templates/default/images/icon_mini_search.gif){kind=icon}
![[Recent Topics]](/templates/default/images/icon_mini_recentTopics.gif){kind=icon}
![[Members]](/templates/default/images/icon_mini_members.gif){kind=icon}
![[Groups]](/templates/default/images/icon_mini_groups.gif){kind=icon}
![[Up]](/templates/default/images/icon_up.gif){kind=icon}