Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A87381336FA7 for ; Tue, 28 Dec 2010 11:46:23 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 12906-01 for ; Tue, 28 Dec 2010 15:46:16 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qmta10.westchester.pa.mail.comcast.net (qmta10.westchester.pa.mail.comcast.net [76.96.62.17]) by mail.postgresql.org (Postfix) with ESMTP id 97DD81336B42 for ; Tue, 28 Dec 2010 11:46:15 -0400 (AST) Received: from omta15.westchester.pa.mail.comcast.net ([76.96.62.87]) by qmta10.westchester.pa.mail.comcast.net with comcast id odmd1f0051swQuc5AfmHze; Tue, 28 Dec 2010 15:46:17 +0000 Received: from sz0093.wc.mail.comcast.net ([76.96.58.151]) by omta15.westchester.pa.mail.comcast.net with comcast id ofhH1f00D3FmDic3bfhHrg; Tue, 28 Dec 2010 15:41:17 +0000 Date: Tue, 28 Dec 2010 15:41:17 +0000 (UTC) From: Lou Picciano To: pgsql-admin@postgresql.org Message-ID: <1278458895.416432.1293550877580.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> In-Reply-To: <794756526.416397.1293550828138.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> Subject: Re: Postgre installation issue MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_416431_952625040.1293550877580" X-Originating-IP: [68.39.28.87] X-Mailer: Zimbra 6.0.5_GA_2431.RHEL5_64 (ZimbraWebClient - SAF3 (Mac)/6.0.5_GA_2427.RHEL4) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.896 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201012/194 X-Sequence-Number: 36423 ------=_Part_416431_952625040.1293550877580 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable But Dusan,=20 I don't think you can have a user see _only_ his own databases, can you? I = think all can see all databases, if I'm not mistaken, even if they cannot c= onnect to all. (Someone here will correct me, I'm sure!) Lou=20 ----- Original Message -----=20 From: "Dusan Misic" =20 To: "ammar fallaha" =20 Cc: pgsql-admin@postgresql.org=20 Sent: Tuesday, December 28, 2010 6:59:02 AM=20 Subject: Re: [ADMIN] Postgre installation issue=20 Oops, I gave wrong answer. Sorry :-)=20 On Tue, Dec 28, 2010 at 12:54 PM, Dusan Misic < promisic@gmail.com > wrote:= =20 Check if Secondary logon service is running. If it is not running, start it= and try again to start PostgreSQL. It should work now.=20 On Tue, Dec 28, 2010 at 8:33 AM, Ammar Fallaha < ammar.fallaha@automata4.co= m > wrote:=20 We are trying to switch from Oracle 10g to Postgre but I am having few tech= nical issues which I am listing here and I hope someone can help.=20 Server Status:=20 - I am installing =E2=80=9Cpostgresql-9.0.2-1-windows.exe=E2=80=9D package = on Windows Server 2003 SP2 with 2 LAN Cards=20 - The server is part of a domain and I am installing using the Administrato= r login=20 - Before installation we have removed completely the AV software=20 Installation:=20 - We have chose the following directories during installation:=20 D:\PostgreSQL\9.0=20 D:\PostgreSQL\9.0\data=20 - The PG user was created in the domain users with a pw that was accepted= =20 - During installation, The locale is English, United States and not to [Def= ault locale]=20 - During installation, starting the database server, this error shows=20 Warning: Problem running post-install step. Installation may not complete c= orrectly=20 Failed to start the database server.=20 I clicked OK and continue=20 - After installation completion, the service "postgresql-9.0 - PostgreSQL S= erver 9.0" will fail. It is setup to start Automatically=20 Services: could not start the postgresql-9.0 service on Local Computer.=20 Error 1069: The service did not start due to a login failure.=20 - 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-sta= rt the service it worked=20 Configuration Problems:=20 1. In postgresql.conf file when I changed the listen address to one of my L= AN card to channel all traffic through it by doing: listen_addresses =3D '1= 92.168.1.212' instead of listen_addresses =3D '*', 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=20 2. In pg_hba.conf I have the following entries:=20 host all all 127.0.0.1/32 md5=20 host all all 192.168.1.211/32 md5=20 host all all 192.168.1.212/32 md5=20 host all all 192.168.1.4/32 md5=20 using PGAdmin from the server itself, I created 2 New login Role =E2=80=9C1= =E2=80=9D and =E2=80=9C2=E2=80=9D , 2 Tablespace =E2=80=9C1=E2=80=9D and = =E2=80=9C2=E2=80=9D as this=20 D:\tablespace\1=20 D:\tablespace\2=20 which is next to the PG directory D:\PostgreSQL=20 and had to gave permission to the user: DOMAIN_NAME\postgres to D:\tablespa= ce directory=20 then created the database =E2=80=9C1=E2=80=9D and =E2=80=9C2=E2=80=9D with = the prospective user as owner and the tablespace=20 Logging from the remote machine with IP: 192.168.1.4 using the user 1, I ca= n see both 1 and 2 dbs=20 however when I changed the pg_hba.conf to=20 host 1 all 192.168.1.4/32 md5=20 restarting the service, I can=E2=80=99t login at all. This entry does not w= ork=20 however; these entries will work:=20 host all all 192.168.1.4/32 md5=20 host all 1 192.168.1.4/32 md5=20 But still can see all the dbs=20 I need to have each user sees its own DB, how can I do that=20 ** More to follow=20 ------=_Part_416431_952625040.1293550877580 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable <= div style=3D'font-family: Verdana; font-size: 12pt; color: #000000'>
But Dusan,
I don't think you can have a user see _only_ his own datab= ases, can you? I think all can see all databases, if I'm not mistaken, even= if they cannot connect to all. (Someone here will correct me, I'm sure!) &= nbsp;Lou

----- Original Message -----
From: "Dusan Misic" = <promisic@gmail.com>
To: "ammar fallaha" <ammar.fallaha@automat= a4.com>
Cc: pgsql-admin@postgresql.org
Sent: Tuesday, December 28,= 2010 6:59:02 AM
Subject: Re: [ADMIN] Postgre installation issue

= Oops, I gave wrong answer. Sorry :-)

On T= ue, Dec 28, 2010 at 12:54 PM, Dusan Misic <promisic@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.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:

<= p>-  = ;        I am installing =E2=80=9Cpostgresql-9.0.2-1-windows.exe=E2=80=9D pa= ckage on Windows Server 2003 SP2 with 2 LAN Cards

- &nbs= p;        The server is part of a domain and I am installing using the Admin= istrator login

-          Before installation we have removed completely t= he AV software

 

Installation:

-  =         = We have chose the following directories during installation:
D:\PostgreSQL\9.0

D:\P= ostgreSQL\9.0\data

-          <= /span>The PG user was created in the domain users = with a pw that was accepted

- &nbs= p;        During installation, The locale is English, United States and not = to [Default locale]

-          = During installation,  starting the dat= abase 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

- &nbs= p;        After installation completion, the service "postgresql-9.0 - Postg= reSQL 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 d= id not start due to a login failure.

-       &nb= sp;  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.    &nbs= p;  In postgresql.conf file whe= n I changed the listen address to one of my LAN card to channel all traffic= through it by doing: listen_addresses =3D '192.168.1.212' instead of liste= n_addresses =3D '*', re-starting the service will not work, changing the en= try 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         &nbs= p;             =      all        = ;             &= nbsp;      127.0.0.1/32        = ;             &= nbsp;           &nbs= p;     md5

host   &nb= sp;   all         &n= bsp;            = ;      all      &nbs= p;            &= nbsp;        192.168.1.211/32    &nbs= p;            &= nbsp;            md5=

host   &nb= sp;   all         &n= bsp;            = ;      all      &nbs= p;            &= nbsp;        192.168.1.212/32    &nbs= p;            &= nbsp;            md5=

host   &nb= sp;   all         &n= bsp;            = ;      all      &nbs= p;            &= nbsp;        192.168.1.4/32     &n= bsp;            = ;             &= nbsp;   md5

 

using PGAdmin from the server itself, I = created 2 New login Role =E2=80=9C1=E2=80=9D and =E2=80=9C2=E2=80=9D , 2 Ta= blespace =E2=80=9C1=E2=80=9D and =E2=80=9C2=E2=80=9D as this
D:\tablesp= ace\1

D:\tablespace\2

which is next to the PG directo= ry D:\PostgreSQL

and h= ad to gave permission to the user: DOMAIN_NAME\postgres to D:\tablespace di= rectory

then created the database= =E2=80=9C1=E2=80=9D and =E2=80=9C2=E2=80=9D with the prospective user as o= wner and the tablespace

 

Logging from the remote machine with IP: 192.168.1.4 using the user 1, I ca= n see both 1 and 2 dbs

however when I changed the pg_hba.conf to

host       1     &nb= sp;            =             all = ;            &n= bsp;            = ;  192.168.1.4/32<= /a>            =        md5

restarting the service, I can=E2=80=99t login at all.&nb= sp; This entry does not work

 

however; these entries will work:

host    =    all          = ;            &n= bsp;     all       &= nbsp;           &nbs= p;        192.168.1.4/32      = ;             m= d5

host   &nb= sp;   all         &n= bsp;            = ;      1       =              &n= bsp;         192.168.1.4/32    &nb= sp;            =   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



------=_Part_416431_952625040.1293550877580--