Oops, I gave wrong answer. Sorry :-) On Tue, Dec 28, 2010 at 12:54 PM, Dusan Misic <promi...@gmail.com> wrote:
> 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.fall...@automata4.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 >> > >
