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.fallaha@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