Robert, Chris, and onlookers:
On 7 January 2013 12:08, Hedley Finger <hedley.fin...@gmail.com> wrote:
> The PostgreSQL installer advised that there were non-fatal errors during
> installation. The install-postgresql.log file (see Dropbox URI) contained
> a number of warnings:
>
> *Many registry entry errors of this form reported --*
> Could not find registry key
> HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Data
> Directory. Setting variable iDataDirectory to empty value
>
> **
>
> ...
*Correct method of starting PostgreSQL --*
> "C:\Program Files\PostgreSQL\9.2\bin\postgres" -D "C:/Program
> Files/PostgreSQL/9.2/data"
> or
> "C:\Program Files\PostgreSQL\9.2\bin\pg_ctl" -D "C:/Program
> Files/PostgreSQL/9.2/data" -l logfile start
>
> ...
*Script error --*
> Failed to install the 'adminpack' module in the 'postgres' database
> loadmodules.vbs ran to completion
> Script stderr:
> Program ended with an error exit code
> Error running cscript //NoLogo "C:\Program
> Files\PostgreSQL\9.2\installer\server\loadmodules.vbs" "postgres" "****"
> "C:\Program Files\PostgreSQL\9.2" "C:\Program Files\PostgreSQL\9.2\data"
> 5432 : Program ended with an error exit code
>
>
> P.S. See also <https://dl.dropbox.com/u/20183670/install-postgresql.log>.
>
I assumed incorrectly that the installer would create the postgres
superuser and handle everything, since I was logged on as an administrator.
You actually have to create the postgres user with a password before
running the installer:
C:\Users\Buster> *net user "postgres" "password" /add*
Then I tested this by logging on as postgres to Windows. No log file was
created when I did this.
Question: is postgres only a superuser in respect of PostgreSQL or has also
to be a superuser in respect of Windows? I figured I could get by with
granting permissions on the C:\Program_Files\PostgreSQL\9.2\* folder tree
to postgres.
Regards,
Hedley
--
Hedley Finger
28 Regent Street Camberwell VIC 3124 Australia
Tel: +61 3 9809 1229 Mobile (cell): +61 412 461 558
Email. "Hedley Finger" <hedley.fin...@gmail.com>
------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
