Skip site navigation (1) Skip section navigation (2)

Re: pgsql 8.x libpq.dll Installation problems

From: rabt(at)dim(dot)uchile(dot)cl
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: pgsql 8.x libpq.dll Installation problems
Date: 2005-04-12 21:34:07
Message-ID: 1113341647.425c3ecfcb89f@webmail.dim.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Found solution!. Recently I've discovered that my account belongs to the power
users group, so I've managed to create a limited account named postgres which
runs initdb.exe with no problems. Thank you all guys for your support.

Here is a summary of the steps:

1. Download postgres-8.0.1 sources.
2. Download and install MinGW an MSYS
3. Open msys.exe and cd to postgresql source dir
3. Do configure --without-zlib
4. Do make install
5. Move created /usr/local/pgsql to final destination, i.e. D:\PostgreSQL
6. Included D:\PostgreSQL\lib and D:\PostgreSQL\bin to PATH variable
7. Added limited account "postgres" with corresponding password
8. Open cmd.exe under postgres, i.e. runas /user:DOMAIN\postgres cmd
9. Execute initdb -D D:\PostgreSQL\data -W -E LATIN1
10. Execute pg_ctl -D D:\PostgreSQL\data start....and there you go

Then fire up pgadmin, psql or whatever client you want.

Rodrigo Abt,
Chile.

Mensaje citado por rabt(at)dim(dot)uchile(dot)cl:

> Hi guys,
>
> I've been testing windows native port of postgresql 8.0.1 at home and now I
> want
> to try it at work. The problem is that my admins are a little concerned about
> users privileges, so they left us with read-only privs on System32 folder,
> which means that pginstaller can't copy libpq.dll file to it's default
> location, and of course installation can't proceed. I've tried msiexec docs
> with no luck and I've also tried setting SYSTEMROOT variable to a different
> location with no results.
>
> Is there anything I can do or should I go back to cygwin port of pgsql?
>
> Thanks in advance,
>
> Rodrigo Abt,
> Chile.
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.


----- Fin del mensaje reenviado -----




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

pgsql-hackers-win32 by date

Next:From: Magnus HaganderDate: 2005-04-14 11:27:46
Subject: Re: Can't install pltcl
Previous:From: Steve - DNDDate: 2005-04-12 18:58:11
Subject: Re: Can't install pltcl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group