From: Lou Picciano <loupicciano@comcast.net>
To: pgsql-admin@postgresql.org
Subject: Re: Postgre installation issue
Date: Tue, 28 Dec 2010 15:41:17 +0000 (UTC)
Message-ID: <1278458895.416432.1293550877580.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net> (raw)
In-Reply-To: <794756526.416397.1293550828138.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
But Dusan,
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 connect to all. (Someone here will correct me, I'm sure!) Lou
----- Original Message -----
From: "Dusan Misic" <promisic@gmail.com>
To: "ammar fallaha" <ammar.fallaha@automata4.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 Tue, 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:
- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: loupicciano@comcast.net
Subject: Re: Postgre installation issue
In-Reply-To: <1278458895.416432.1293550877580.JavaMail.root@sz0093a.westchester.pa.mail.comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox