Re: Postgre installation issue

Check if Secondary logon service is running. If it is not running, start it
and try again to start PostgreSQL. It should work now.

On Tue, Dec 28, 2010 at 8:33 AM, Ammar Fallaha
<ammar(dot)fallaha(at)automata4(dot)com>wrote:

> We are trying to switch from Oracle 10g to Postgre but I am having few
> technical issues which I am listing here and I hope someone can help.
>
>
>
> Server Status:
>
> - I am installing “postgresql-9.0.2-1-windows.exe” package on
> Windows Server 2003 SP2 with 2 LAN Cards
>
> - The server is part of a domain and I am installing using the
> Administrator login
>
> - Before installation we have removed completely the AV software
>
>
>
> Installation:
>
> - We have chose the following directories during installation:
> D:\PostgreSQL\9.0
>
> D:\PostgreSQL\9.0\data
>
> - The PG user was created in the domain users with a pw that was
> accepted
>
> - During installation, The locale is English, United States and
> not to [Default locale]
>
> - During installation, starting the database server, this error
> shows
>
> Warning: Problem running post-install step. Installation may not complete
> correctly
> Failed to start the database server.
>
> I clicked OK and continue
>
> - After installation completion, the service "postgresql-9.0 -
> PostgreSQL Server 9.0" will fail. It is setup to start Automatically
> Services: could not start the postgresql-9.0 service on Local Computer.
>
> Error 1069: The service did not start due to a login failure.
>
> - When checking the service login, I found out the user to be
> .\postgres so browse for it in the domain and changed it to
> DOMAIN_NAME\postgres, re-start the service it worked
>
>
>
> Configuration Problems:
>
> 1. In postgresql.conf file when I changed the listen address to one
> of my LAN card to channel all traffic through it by doing: listen_addresses
> = '192.168.1.212' instead of listen_addresses = '*', re-starting the service
> will not work, changing the entry back and re-starting the service will not
> work, changing the entry back and re-start the whole server will work and
> the service will start
>
>
>
> 2. In pg_hba.conf I have the following entries:
> host all all
> 127.0.0.1/32 md5
>
> host all all
> 192.168.1.211/32 md5
>
> host all all
> 192.168.1.212/32 md5
>
> host all all
> 192.168.1.4/32 md5
>
>
>
> using PGAdmin from the server itself, I created 2 New login Role “1” and
> “2” , 2 Tablespace “1” and “2” as this
> D:\tablespace\1
>
> D:\tablespace\2
>
> which is next to the PG directory D:\PostgreSQL
>
> and had to gave permission to the user: DOMAIN_NAME\postgres to
> D:\tablespace directory
>
> then created the database “1” and “2” with the prospective user as owner
> and the tablespace
>
>
>
> Logging from the remote machine with IP: 192.168.1.4 using the user 1, I
> can see both 1 and 2 dbs
>
> however when I changed the pg_hba.conf to
>
> host 1 all
> 192.168.1.4/32 md5
>
> restarting the service, I can’t login at all. This entry does not work
>
>
>
> however; these entries will work:
>
> host all all
> 192.168.1.4/32 md5
>
> host all 1
> 192.168.1.4/32 md5
>
> But still can see all the dbs
>
> I need to have each user sees its own DB, how can I do that
>
>
>
>
>
> ** More to follow
>